How to use
Use this tool to validate CSV structure and pinpoint formatting issues.
- Paste your CSV into the input box.
- Choose Delimiter: Auto (or force one) and keep the quote char as " unless your file differs.
- Click Check CSV to get a compact report (rows, columns, errors, and line/column hints).
- Optional: enable Include normalized CSV to output a cleaned version using consistent quoting.
FAQ
What does this CSV format checker validate?
It checks delimiter consistency, quote/escape correctness, and whether each row has the same number of columns.
Does it support commas inside quoted fields?
Yes. Values like "hello, world" are treated as a single field when quoting is correct.
What is “Strict quoting”?
Strict mode flags cases like characters after a closing quote or quotes appearing inside unquoted fields.
Can it detect the delimiter automatically?
Yes. Auto-detect picks from comma, tab, semicolon, or pipe based on the first row.
Why do I see “Inconsistent column count” errors?
At least one row has more or fewer fields than the first row (often caused by missing/extra delimiters or broken quotes).
Will this tool upload my CSV anywhere?
No. Everything runs locally in your browser; the tool does not send network requests.
What does “Include normalized CSV” do?
It outputs a cleaned CSV where fields are quoted only when needed and quotes are escaped correctly.