Spreadsheet · 13 files
Sample CSV Files
CSV files of realistic fake customer records with a header row, from 10 to 1,000,000 rows. Twelve columns cover integers, names, emails, phone numbers, dates, decimals and booleans.
All 13 CSV files
Download all with curl
# 13 files, 414 MB in total
while read -r url; do curl -LO --fail "$url"; done <<'EOF'
https://files.samplefiles.com/spreadsheet/csv/sample-10-rows.csv
https://files.samplefiles.com/spreadsheet/csv/sample-100-rows.csv
https://files.samplefiles.com/spreadsheet/csv/sample-100kb.csv
https://files.samplefiles.com/spreadsheet/csv/sample-1k-rows.csv
https://files.samplefiles.com/spreadsheet/csv/sample-1mb.csv
https://files.samplefiles.com/spreadsheet/csv/sample-10k-rows.csv
https://files.samplefiles.com/spreadsheet/csv/sample-5mb.csv
https://files.samplefiles.com/spreadsheet/csv/sample-10mb.csv
https://files.samplefiles.com/spreadsheet/csv/sample-100k-rows.csv
https://files.samplefiles.com/spreadsheet/csv/sample-50mb.csv
https://files.samplefiles.com/spreadsheet/csv/sample-500k-rows.csv
https://files.samplefiles.com/spreadsheet/csv/sample-100mb.csv
https://files.samplefiles.com/spreadsheet/csv/sample-1m-rows.csv
EOF| File | Size | Details | Download |
|---|---|---|---|
| CSV, 10 rowssample-10-rows.csv | 1.5 KB | 10 rows | Download |
| CSV, 100 rowssample-100-rows.csv | 15 KB | 100 rows | Download |
| 100 KB CSV filesample-100kb.csv | 99.9 KB | 659 rows | Download |
| CSV, 1,000 rowssample-1k-rows.csv | 152 KB | 1,000 rows | Download |
| 1 MB CSV filesample-1mb.csv | 1023 KB | 6,671 rows | Download |
| CSV, 10,000 rowssample-10k-rows.csv | 1.5 MB | 10,000 rows | Download |
| 5 MB CSV filesample-5mb.csv | 4.9 MB | 33,020 rows | Download |
| 10 MB CSV filesample-10mb.csv | 9.9 MB | 65,903 rows | Download |
| CSV, 100,000 rowssample-100k-rows.csv | 15.2 MB | 100,000 rows | Download |
| 50 MB CSV filesample-50mb.csv | 49.9 MB | 326,252 rows | Download |
| CSV, 500,000 rowssample-500k-rows.csv | 77.2 MB | 500,000 rows | Download |
| 100 MB CSV filesample-100mb.csv | 99.9 MB | 651,099 rows | Download |
| CSV, 1,000,000 rowssample-1m-rows.csv | 154 MB | 1,000,000 rows | Download |
FAQ
Is the data real?
No. It is generated with Faker; emails use reserved example.com domains and phone numbers use the fictional 555-01xx range.
What encoding do the CSV files use?
UTF-8 without a BOM and LF line endings. BOM, UTF-16, Latin-1, Shift_JIS, CRLF and semicolon variants are in Edge Cases → Encoding.
What columns are in the files?
id, first_name, last_name, email, phone, company, job_title, city, country, signup_date, balance and active, with a header row.
Can Excel open the 1-million-row CSV?
Not completely. Excel stops at 1,048,576 rows per sheet, so it loads the file but warns that it didn’t load everything. Use it to test that limit, or a streaming reader such as pandas with chunksize.
How do I load a CSV into PostgreSQL?
Create a table with the twelve columns, then run \copy customers FROM 'sample-1k-rows.csv' WITH (FORMAT csv, HEADER true) in psql.
Can I load these files directly from my code?
Yes. Files are served from files.samplefiles.com with permissive CORS headers, so fetch(), <video>, <audio> and <img> can use the URLs directly.