Test files › Structured data › 1million-rows.csv

CSV file with 1,000,000 rows

1,000,000 data rows, roughly 65 MB. Exceeds the Excel worksheet row limit of 1,048,576 minus headers.

↓ Download 1million-rows.csv
Filename1million-rows.csv
FormatCSV
Size34.1 MB (35,738,961 bytes)
MIME typetext/csv; charset=utf-8
SHA-256a7ff891008a07e7d56692a8fd415d54da8c5867116c1c572d2275133c5b8bca9
What this file catchesImport jobs that load the whole file into memory, and UIs that try to preview every row. Also useful for confirming your progress bar is honest.

Related guides and tools

Sample CSV fileCharacter encodingsUpload validation checklistVerify its SHA-256

Download & verify

curl -fsSL -o "1million-rows.csv" "https://files.hexaqa.com/csv/1million-rows.csv"
curl -fsSL "https://files.hexaqa.com/csv/1million-rows.csv" | sha256sum # expect: a7ff891008a07e7d56692a8fd415d54da8c5867116c1c572d2275133c5b8bca9

More structured data test files

1000-rows.csvbom-and-semicolons.csvformula-injection.csvquoting-nightmare.csvragged-rows.csvvalid-simple.csvdeeply-nested-100000.jsonlarge-array-100mb.json

← All Structured data files