Find Incomplete CSV Records
Paste CSV, choose its separator, and see exactly which records have missing or extra fields before you import the file.
A QUICK WALKTHROUGH
How to use this tool
- Paste CSV data and choose the separator used by your file.
- Choose whether the first row contains column names, then select Find incomplete records.
- Review row numbers, field counts, and the affected record text before fixing the source file.
Checks real CSV fields
Quoted commas, escaped quotes, and quoted line breaks are handled as CSV fields. A record is incomplete when its field count differs from the first record’s expected width.
Useful before importing
The report shows the source row number, actual field count, expected count, and a compact preview so you can find the problem quickly in a spreadsheet or export job.
Private and bounded
Parsing runs locally in your browser. Input is limited to 100,000 characters, 10,000 records, and 500 fields per record.
GOOD TO KNOW
Common questions
Does this upload my CSV?
No. The CSV is parsed and checked locally in your browser.
Does it understand quoted commas?
Yes. Commas, line breaks, and doubled quotes inside quoted fields are treated as part of the field.
What is the expected field count?
The first data record sets the expected width, or the header row when you enable the header option.
Can it fix incomplete records?
No. It reports the exact rows so you can correct the source data without silently changing values.