← sources

How do you actually handle messy supplier Excel sheets without losing your mind?

source: reddit (reddit:smallbusiness)published 2026-11-19 15:44ingested 2026-11-20 02:37

retained text

Curious how other small business owners deal with this.

Every time I look at how companies handle supplier price lists or product catalogs, it’s the same nightmare: merged cells, 3-row headers, dimensions mixed into descriptions, random formatting, and prices changing every month.

If you sell physical products (retail, wholesale, custom goods, etc.), what’s your actual workflow when a supplier sends a messy spreadsheet?   
Do you clean it up manually in Excel/Google Sheets?  
What’s the most painful part — updating prices in your store, or turning those sheets into clean PDF catalogs / price lists / quotes for customers?  
Have you found any lightweight tool that actually handles messy files, or is everyone still stuck doing copy-paste / hiring VAs?

Trying to understand where the real bottleneck is in day-to-day operations.

document fetched 2026-11-20 00:30 · canonical https://reddit.com/r/smallbusiness/comments/1y0ck2p/how_do_you_actually_handle_messy_supplier_excel