CSV · Check before you import
Check and clean a CSV
Find format problems before you import a spreadsheet. If the file reads correctly, save a clean copy as UTF-8 with commas and consistent quoting.
- You need
- A CSV or TSV file, or pasted table text, up to 2 MB
- You get
- A list of problems and, when the structure is sound, a clean UTF-8 CSV
- Where files go
- Processed in this browser only. Nothing is uploaded; closing the page clears it.
1
Add your CSV
Drop a CSV file here
.csv, .tsv or .txt · up to 2 MB
Up to 20,000 records and 200 columns. No autosave. Original files are never overwritten.
3
Preview: first 20 records and 10 columns; long cells shortened here only. Export includes all checked records.
Output: UTF-8 with BOM, comma separators, CRLF line endings and quoted cells. Import identifier columns as Text in Excel; quoting alone does not prevent Excel changing them.
What this check can and cannot fix
Checks and keeps
- Checks quoting, column counts and encoding before export.
- Keeps dates, decimals, spaces and identifiers as written.
- Exports UTF-8 with BOM, comma separators and consistent quoting.
- Exports formula-like cells only after you choose how to handle them.
Does not
- Repair broken quotes or inconsistent column counts. Correct them before export.
- Reconstruct missing leading zeros or rounded digits.
- Check Shopify, Stripe or accounting business rules.
- Guarantee that a platform accepts the import.
For platform requirements, consult Shopify CSV import guidance.