Quick answer
In a valid CSV table, every row should have the same number of columns as the header (or first) row.
CSV Inconsistent Columns
In a valid CSV table, every row should have the same number of columns as the header (or first) row. If one row has more or fewer fields, parsers may fail or produce wrong data.
Common causes
- Missing or extra comma in one row.
- A comma inside an unquoted field (should be quoted).
- Truncated or merged lines when exporting or copying data.
How to fix
- Count commas (respecting quoted fields) per row; all rows should have the same count.
- Quote any field that contains a comma so it is treated as one field.
- Use a CSV validator to see which line has the wrong column count.
Examples
Bad
a,b,c 1,2 3,4,5
Good
a,b,c 1,2,3 4,5,6
FAQ
- Why does my CSV have different column counts?
- Usually a comma inside a field that was not quoted, or a missing/extra comma. Quote fields that contain commas.
- Does the header row define the column count?
- Yes. Most parsers expect every data row to have the same number of fields as the first row.
Fix it now
Try in validator (prefill this example)