CSV Linter

Checks whether every row has the same number of fields as the header row — a ragged row is the single most common CSV defect, usually caused by an unescaped delimiter or a missing trailing field, and it silently corrupts anything downstream that assumes positional columns.

Delimiter detection

Auto-detect tries comma, semicolon, tab and pipe against the first 20 non-blank lines and picks whichever produces the most consistent field count — not just whichever character appears most often, which would be wrong for a file where the real delimiter is rare but the data happens to contain lots of commas.

For a non-comma delimiter, a literal comma appearing in unquoted data is a real ambiguity this tool does not attempt to resolve — nothing in the file marks it as data rather than a separator.