CSV error: “Expected N fields, saw M” / rows have the wrong number of columns

Find the broken rows that make databases and importers reject your CSV.

The message you see
Expected N fields in line X, saw M
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Validate my CSV →

Why this happens

How to fix it

  1. 1Locate the reported line and check quotes and delimiters there.
  2. 2Wrap fields with commas or line breaks in double quotes.
  3. 3Validate the whole file, not just the first error.

Related guides

Still stuck? Ask SheetFix Support