Clean CSV
A clean, well-formed CSV with a header and 20 rows — the baseline case for CSV parser testing.
CSV files that break parsers
Clean and deliberately messy CSVs — quoted commas, embedded newlines, ragged rows, odd delimiters, and encodings.
Messy CSV (quoted commas, newlines, ragged rows)
A deliberately messy CSV: a quoted field with a comma, a quoted field with an embedded newline, escaped double-quotes, and ragged rows with too few and too many fields — the cases that break naïve parsers.
Semicolon-Delimited CSV
A CSV that uses semicolons as the delimiter (common in European locales) — for testing delimiter detection.
Tab-Separated Values (TSV)
A tab-separated values file with a header and 20 rows — for testing TSV parsing and delimiter handling.
Headerless CSV
A CSV with no header row — for testing parsers that must infer or be told the column names.
10,000-Row CSV
A CSV with 10,000 data rows — for testing streaming parsers, memory handling, and import performance.
Latin-1 Encoded CSV
A CSV encoded in Latin-1 (ISO-8859-1) with accented names — for testing encoding detection and mis-decoding (it will look wrong if read as UTF-8).