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.

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.

Other tools