Test files › Structured data › bom-and-semicolons.csv
Sample CSV file
UTF-8 BOM, semicolon delimiters and comma decimal separators - the format Excel produces in most European locales.
↓ Download bom-and-semicolons.csv| Filename | bom-and-semicolons.csv |
| Format | CSV |
| Size | 124 bytes (124 bytes) |
| MIME type | text/csv; charset=utf-8 |
| SHA-256 | f011c1f7fd1b20aa993782865d5884ca6aa23089fabe5dc560b47c041bdf080a |
What this file catchesImporters hardcoded to comma delimiters, and the stray "" that appears before the first column header when the BOM is not stripped. Extremely common real-world support ticket.
Download & verify
curl -fsSL -o "bom-and-semicolons.csv" "https://files.hexaqa.com/csv/bom-and-semicolons.csv"
curl -fsSL "https://files.hexaqa.com/csv/bom-and-semicolons.csv" | sha256sum
# expect: f011c1f7fd1b20aa993782865d5884ca6aa23089fabe5dc560b47c041bdf080a