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.

Tools in this kit

CSV Delimiter Detector

Guess , ; TAB | quickly.

Broken CSV Checker

Find mismatched line numbers.

CSV Column Count Checker

Rows + columns at a glance.

CSV Inspector

All-in-one checks.