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 MFastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- A value contains the delimiter (comma or semicolon) without quotes.
- Line breaks inside a field split one record over several lines.
- Some rows were pasted with extra or missing columns.
How to fix it
- 1Locate the reported line and check quotes and delimiters there.
- 2Wrap fields with commas or line breaks in double quotes.
- 3Validate the whole file, not just the first error.
Related guides
CSV
CSV opens in one column in Excel — how to split it correctly
CSVStrange characters like é or ’ in your CSV — how to fix the encoding
HubSpotHubSpot import error: “Make sure each column with data has a header”
Still stuck? Ask SheetFix Support