Find Incomplete CSV Records
Spot the rows in a CSV that have too few or too many fields.
Runs entirely in your browser.
Find Rows With Missing or Extra Fields
About Find Incomplete CSV Records
A CSV is meant to be rectangular, and an import will usually fail - or worse, quietly shift columns - when a row has the wrong number of fields. This compares every row against the header and reports the ones that do not match, with the line number and what it found.
The commonest cause is an unquoted comma inside a value, which splits one field into two. Rows with the right field count but blank cells are reported separately, since those are often fine.
Other CSV Tools
- Change CSV Separator — commas to semicolons, tabs or pipes
- Transpose CSV — swap rows and columns
- Insert a CSV Column — add a column at any position
- Swap CSV Columns — exchange two column positions
- CSV to TSV — and back
- CSV to XML — and back
- CSV to YAML — and back
- TSV to JSON — and back
- JSON to CSV — and back
- CSV Viewer — browse a CSV as a sortable table
- CSV to Markdown — build a Markdown table
