Download a sample CSV with realistic fake data. Each dataset comes in several sizes, from 100 rows for quick tests to 1,000,000 rows for performance tests. The first rows of the customers file are shown below.
The 100,000-row and 1,000,000-row files are meant for load and performance tests: import speed, memory use, pagination and streaming parsers. Note that Excel opens at most 1,048,576 rows, so a 1M-row CSV is right at the limit — use a database, Python (pandas), or a streaming parser for anything larger.
CSV with semicolons, quotes and UTF-8
customers-1000-semicolon.csv uses ; as the separator — what Excel produces in many European locales.
customers-1000-utf8-bom.csv starts with a UTF-8 byte order mark so Excel on Windows shows accents correctly.
special-characters.csv contains the tricky cases: commas and quotes inside values, a line break inside a cell, accents, Chinese characters and emoji. It is a quick way to check that a CSV parser follows RFC 4180.
How to open CSV in Excel / Google Sheets
Excel: use Data → From Text/CSV, choose the file, set File origin to 65001: Unicode (UTF-8) and the right delimiter, then Load. Double-clicking also works for the BOM version.
Google Sheets:File → Import → Upload, then choose Separator type: Detect automatically.
Python:pandas.read_csv("customers-1000.csv"), or sep=";" for the semicolon file.
Frequently Asked Questions
Is the data real?
No. All names, emails, phone numbers, addresses and amounts are generated with the Faker library. Emails use reserved example domains such as example.com, and phone numbers use the fictional 555 prefix.
What encoding do the files use?
UTF-8 without BOM, comma-separated, with a header row and Unix line endings. If Excel shows broken characters, use the UTF-8 with BOM version; if your Excel expects semicolons (common in Europe), use the semicolon version.
Can I get the same data in Excel or JSON?
Yes. The sample Excel files use the same datasets, and the JSON page has an array of 1,000 user objects built from the customers data.