CSV Debug Kit
Use these tools together to quickly diagnose common CSV issues (delimiter, broken rows, inconsistent columns).
Workflow
- 1) Detect the delimiter
If you are not sure whether it is comma, semicolon, TAB, or pipe, start with CSV Delimiter Detector.
- 2) Find broken rows
Use Broken CSV Checker to locate lines that do not match the header’s column count.
- 3) Sanity-check size and shape
Use CSV Column Count Checker to quickly confirm how many rows you pasted and how many columns are in the first line.
- 4) Use the all-in-one inspector
When you want everything in one place, open CSV Inspector.
Example
If your header has 5 columns, every data row should also have 5 columns. A broken row usually means an extra delimiter, missing delimiter, or a comma inside a value.
id,name,city,age,source 1,Ana,London,31,ads 2,Bob,Paris,29 3,Chris,Tokyo,28,ads
Row 2 is missing one value, so the column count does not match.
Important note
These are lightweight checks designed for speed. They assume simple CSV (for example: comma-separated without quoted commas inside a cell). If your CSV uses RFC-compliant quoting/escaping, you may need a full CSV parser.