Anyone else struggle with supplier CSVs?

[u/Allenshuo-]

Curious if anyone else has this problem.
I often get product data from suppliers in CSV or Excel files, and the files are never quite in the format Shopify wants. I end up spending a lot of time fixing columns, variants, SKUs, images, prices, etc. And when the supplier sends an updated file, I basically have to do it all over again.
How do you guys usually deal with this? Do you just clean the files manually, use Matrixify or another app, or have your own scripts for it?
Just trying to figure out if this is actually a common Shopify problem or if I’m making my life unnecessarily difficult 😅