CSV Validator
Checks a CSV file's structure and reports every problem it finds, rather than stopping at the first. It detects the delimiter, then flags rows whose field count does not match the header, empty or duplicated column names, and unterminated quoted fields. The response also reports the delimiter, column count, and data row count.
Checks a CSV file's structure and reports every problem it finds, rather than stopping at the first. It detects the delimiter, then flags rows whose field count does not match the header, empty or duplicated column names, and unterminated quoted fields. The response also reports the delimiter, column count, and data row count.
Use cases
- Finding which row breaks a failing CSV import
- Checking a generated export before shipping it to a client
Examples
Well-formed CSV
name,age Ada,36
{"valid": true, "delimiter": ",", "columns": 2, "rows": 1, "problems": []}FAQ
Is my data sent to a server?
Yes — validation runs on the server for this tool.
Does it stop at the first error?
No. Every problem is listed, so a file with several bad rows can be fixed in one pass.
Which delimiters are recognised?
Comma, semicolon, tab, and pipe, detected from the header row.