Test files › Structured data › quoting-nightmare.csv
Sample CSV file
Every RFC 4180 quoting edge case in one file: embedded commas, embedded newlines inside quoted fields, escaped double quotes, leading and trailing whitespace, and empty fields.
↓ Download quoting-nightmare.csv| Filename | quoting-nightmare.csv |
| Format | CSV |
| Size | 407 bytes (407 bytes) |
| MIME type | text/csv; charset=utf-8 |
| SHA-256 | 557f8d813aa8cec4212f6bcb3e6a11cfdeadc48fab3d825f2e9a7fb26bd36d5e |
What this file catchesNaive parsers that split on commas. A correct parser returns exactly 7 data rows; a naive one typically reports 9 or 10.
Download & verify
curl -fsSL -o "quoting-nightmare.csv" "https://files.hexaqa.com/csv/quoting-nightmare.csv"
curl -fsSL "https://files.hexaqa.com/csv/quoting-nightmare.csv" | sha256sum
# expect: 557f8d813aa8cec4212f6bcb3e6a11cfdeadc48fab3d825f2e9a7fb26bd36d5e