How to use
Use this CSV checker to validate structure (not business rules).
- Paste your CSV into the input box.
- Choose Delimiter: Auto (or set it explicitly).
- Pick options like Has header and Allow ragged rows.
- Click Check CSV to get a report with row/column counts and any errors by line.
FAQ
What does this CSV checker validate?
It validates CSV parsing (delimiter, quotes, row breaks) and checks that rows have a consistent number of fields unless you allow ragged rows.
Does it auto-detect the delimiter?
Yes—Auto-detect compares common delimiters (comma, tab, semicolon, pipe) on the first non-empty lines and picks the most consistent match.
How are line numbers calculated?
Line numbers refer to the input text lines after normalizing CRLF/CR to LF; errors are reported on the line where they occur.
My CSV has commas inside quotes—will it work?
Yes. Quoted fields can contain delimiters and newlines; doubled quotes ("") are treated as an escaped quote.
What does “Allow ragged rows” do?
It disables the “expected X fields” error so you can still inspect delimiter/quote issues in files where rows legitimately vary in length.
Will this upload my CSV anywhere?
No. The checker runs entirely in your browser and does not make network requests.
Can I validate very large CSV files here?
Pasting huge files can be slow in any browser; for best performance, validate a representative slice or run checks in smaller chunks.