CSV formatter vs Excel cleanup
A CSV formatter is a browser pass for catalog columns; Excel is a full spreadsheet. Use Excel for analysis, then format a clean UTF-8 CSV for Shopify import.
Excel rewrites files
Excel may change encoding, drop leading zeros on SKUs, and convert barcodes to scientific notation. That is fine for analysis and fatal for an import. Save CSV UTF-8 and re-check SKU columns as text.
What a formatter is for
CrossKit CSV Formatter is for seeing headers, spotting blank Handles, and tidying catalog columns in the browser without installing Excel on a warehouse laptop. It is not a pivot-table tool and does not connect to Shopify.
A practical sequence
Explore in Excel if you need filters. Copy a products-only sheet. Drop customer columns. Then run the formatter or a text editor to confirm UTF-8, quotes and Handles. Import a test slice.
Privacy
Do not put shopper emails into either tool’s product file. Catalog prep is not CRM export.
Related CrossKit tool
CSV Formatter
Open this browser tool after you read the article.
Frequently Asked Questions
Can I skip Excel entirely?
Yes if the export is already a product CSV. Use the formatter to inspect it. Use Excel when you need heavy joins.
Why did SKUs become 1.23E+11?
Excel treated them as numbers. Force the column to text and re-export.
Does CSV Formatter fix scientific notation automatically?
Inspect and correct columns before import. Do not assume a single click undoes Excel damage; keep a last-good export.