CSV files ready to download for testing, tutorials, classes and demos. There are realistic business datasets (customers, products, orders, employees, sales), capital-city coordinates for maps and, above all, files built to stress an importer or a parser: commas and line breaks inside quotes, semicolons with decimal commas, Excel's Windows-1252 encoding, leading zeros, missing values, mixed date formats and a 100,000-row file.
All data is fictitious: emails use the reserved example.com, example.org and example.net domains, and phone numbers are in ranges reserved for fiction. You can use the files freely, including in commercial projects. Every file can be opened in the site's CSV viewer without downloading it.
Large Sample CSV Files — Download sample CSV files with 1,000 to 5 million rows of realistic data, generated in your browser.
License: fictitious data released into the public domain (CC0). Use it however you like.
100 customers with name, email, phone, city, country and signup date. The right size for a tutorial or a quick test.
100 rows · 8 columns · 8 KB · Delimiter: , · Encoding: UTF-8
Columns: id, first_name, last_name, email, phone, city, country, signup_date
Download customers-100.csv · Open in viewer
id,first_name,last_name,email,phone,city,country,signup_date 1,Hugo,Nguyen,hugo.nguyen1@example.org,+1-555-0101,Manchester,United Kingdom,2020-12-07 2,Olivia,Tran,olivia.tran2@example.net,+44 20 7946 0002,Tokyo,Japan,2020-01-13 3,Emma,Tanaka,emma.tanaka3@example.net,+1-555-0103,Sevilla,Spain,2026-04-02
The same fields with 1,000 rows, to test filters, search and pagination.
1000 rows · 8 columns · 86 KB · Delimiter: , · Encoding: UTF-8
Columns: id, first_name, last_name, email, phone, city, country, signup_date
Download customers-1000.csv · Open in viewer
id,first_name,last_name,email,phone,city,country,signup_date 1,Omar,Müller,omar.muller1@example.org,+1-555-0101,Bangkok,Thailand,2021-11-03 2,Liam,Nguyen,liam.nguyen2@example.org,+44 20 7946 0002,Manchester,United Kingdom,2024-08-05 3,Inês,Brown,ines.brown3@example.org,+1-555-0103,Barcelona,Spain,2023-02-15
10,000 customers (about 900 KB): enough to notice the performance of an importer or a spreadsheet.
10000 rows · 8 columns · 878 KB · Delimiter: , · Encoding: UTF-8
Columns: id, first_name, last_name, email, phone, city, country, signup_date
Download customers-10000.csv · Open in viewer
id,first_name,last_name,email,phone,city,country,signup_date 1,Lucía,Martin,lucia.martin1@example.net,+1-555-0101,Chicago,United States,2019-07-16 2,Lucas,Martin,lucas.martin2@example.com,+44 20 7946 0002,Austin,United States,2023-08-10 3,Priya,Rossi,priya.rossi3@example.net,+1-555-0103,Chicago,United States,2020-03-17
A 100-product catalogue with SKU, category, price, stock, EAN-13 and active flag. Useful for online shop imports.
100 rows · 8 columns · 7 KB · Delimiter: , · Encoding: UTF-8
Columns: sku, name, category, price, currency, stock, ean13, active
Download products-100.csv · Open in viewer
sku,name,category,price,currency,stock,ean13,active SKU-00001,Wireless Mouse,Electronics,27.12,EUR,756,8417710028286,false SKU-00002,Wireless Mouse (Black),Electronics,105.74,EUR,332,8438335028826,true SKU-00003,Wireless Mouse (White),Electronics,444.96,EUR,347,8494837997737,true
1,000 orders with date, status, item count, total, country and payment method. Perfect for practising GROUP BY and pivot tables.
1000 rows · 9 columns · 62 KB · Delimiter: , · Encoding: UTF-8
Columns: order_id, customer_id, order_date, status, items, total, currency, country, payment_method
Download orders-1000.csv · Open in viewer
order_id,customer_id,order_date,status,items,total,currency,country,payment_method ORD-100001,455,2026-06-23,shipped,5,524.26,EUR,Mexico,card ORD-100002,229,2026-12-09,paid,4,329.08,EUR,Japan,card ORD-100003,215,2026-06-03,paid,1,84.59,EUR,Thailand,card
100 employees with department, job title, salary, hire date and manager (a hierarchy).
100 rows · 8 columns · 6 KB · Delimiter: , · Encoding: UTF-8
Columns: employee_id, first_name, last_name, department, job_title, salary, hire_date, manager_id
Download employees-100.csv · Open in viewer
employee_id,first_name,last_name,department,job_title,salary,hire_date,manager_id E0001,Jordi,Schmidt,Marketing,Content Writer,131000,2026-10-11, E0002,Linh,Fernández,Finance,Accountant,137000,2026-01-18, E0003,Lucas,Bianchi,Support,Support Lead,57000,2024-01-04,
Monthly sales for 2024 and 2025 by region: revenue, units and new customers. Ideal for time-series charts.
96 rows · 5 columns · 3 KB · Delimiter: , · Encoding: UTF-8
Columns: month, region, revenue, units, new_customers
Download sales-by-month.csv · Open in viewer
month,region,revenue,units,new_customers 2024-01,North,81111.81,850,137 2024-01,South,71066.24,873,58 2024-01,East,94732.47,347,54
40 world capitals with country, latitude and longitude in decimal degrees. Ready to convert to GeoJSON or KML.
40 rows · 4 columns · 1 KB · Delimiter: , · Encoding: UTF-8
Columns: city, country, latitude, longitude
Download world-capitals-coordinates.csv · Open in viewer
city,country,latitude,longitude Madrid,Spain,40.4168,-3.7038 Lisbon,Portugal,38.7223,-9.1393 Paris,France,48.8566,2.3522
CSV edge cases: commas, quotes and line breaks inside quoted fields, spaces, Unicode and emoji. If your parser reads this correctly, it reads almost anything.
6 rows · 4 columns · 1 KB · Delimiter: , · Encoding: UTF-8
Columns: id, company, note, quote
Download edge-cases-quotes-newlines.csv · Open in viewer
id,company,note,quote 1,"Acme, Inc.",Comma inside a quoted field,"He said ""hello""" 2,Smith & Sons,"Line break inside the field", 3,"""Quoted"" Ltd",Starts with a quote,""""""
A CSV the way Excel in Spain writes it: semicolon-separated, decimal commas, dd/mm/yyyy dates, ZIP codes with leading zeros and UTF-8 with BOM.
50 rows · 6 columns · 2 KB · Delimiter: ; · Encoding: UTF-8 with BOM
Columns: id, nombre, ciudad, código_postal, importe, fecha_alta
Download clientes-punto-y-coma-utf8-bom.csv · Open in viewer
id;nombre;ciudad;código_postal;importe;fecha_alta 1;Sophie Haddad;Málaga;28414;595,57;12/01/2026 2;Aiko Bianchi;Barcelona;13487;951,70;06/05/2020 3;Ploy Santos;Sevilla;05372;122,47;14/08/2020
A file saved the way Excel on Windows does: semicolons and Windows-1252 (ANSI) encoding. Use it to check whether your tool displays accents correctly.
30 rows · 4 columns · 1 KB · Delimiter: ; · Encoding: Windows-1252
Columns: id, nombre, ciudad, importe
Download excel-windows-1252-semicolon.csv · Open in viewer
id;nombre;ciudad;importe 1;Iñaki Muñoz;Logroño;572,83 2;Lucía Gómez;Cádiz;335,90 3;Jürgen Groß;A Coruña;197,80
200 tab-separated rows (TSV). For testing delimiter detection.
200 rows · 5 columns · 6 KB · Delimiter: tab · Encoding: UTF-8
Columns: id, first_name, last_name, country, score
Download tab-separated-200.tsv · Open in viewer
id first_name last_name country score 1 Jordi Srisuk Germany 87 2 Hugo Nguyen Italy 24 3 Fatima Haddad Spain 40
Codes with leading zeros (customer, ZIP, phone, account, GTIN). Excel breaks them when you double-click the file.
40 rows · 6 columns · 3 KB · Delimiter: , · Encoding: UTF-8
Columns: customer_code, zip_code, phone, account_number, product_ref, gtin
Download leading-zeros-codes.csv · Open in viewer
customer_code,zip_code,phone,account_number,product_ref,gtin 000001,06055,0686054025,0000996225649258,00761-A,0057348690577 000002,05751,0698379773,0000155220325570,00413-A,0072109140828 000003,09212,0648122215,0000540582625428,00577-A,0019476199592
Missing values written in several ways: empty cells, NULL and N/A. For testing data cleaning.
60 rows · 6 columns · 3 KB · Delimiter: , · Encoding: UTF-8
Columns: id, name, email, age, city, last_login
Download missing-values.csv · Open in viewer
id,name,email,age,city,last_login 1,Aiko Müller,aiko.muller1@example.org,24,Austin,N/A 2,Leon Müller,leon.muller2@example.net,30,New York,N/A 3,Jordi López,jordi.lopez3@example.com,35,Austin,2026-03-27
The same date in seven formats: ISO 8601, dd/mm/yyyy, mm/dd/yyyy, UTC date-time, Unix timestamp and text month.
40 rows · 7 columns · 3 KB · Delimiter: , · Encoding: UTF-8
Columns: id, iso_8601, european_dd_mm_yyyy, us_mm_dd_yyyy, datetime_utc, unix_timestamp, text_month
Download date-formats.csv · Open in viewer
id,iso_8601,european_dd_mm_yyyy,us_mm_dd_yyyy,datetime_utc,unix_timestamp,text_month 1,2023-07-14,14/07/2023,07/14/2023,2023-07-14T03:53:00Z,1689306780,14 Jul 2023 2,2024-11-02,02/11/2024,11/02/2024,2024-11-02T11:13:00Z,1730545980,2 Nov 2024 3,2020-02-08,08/02/2020,02/08/2020,2020-02-08T03:48:00Z,1581133680,8 Feb 2020
100,000 customers (about 9 MB) for load testing importers, viewers and scripts.
100000 rows · 8 columns · 8.8 MB · Delimiter: , · Encoding: UTF-8
Columns: id, first_name, last_name, email, phone, city, country, signup_date
Download customers-100000.csv · Open in viewer
id,first_name,last_name,email,phone,city,country,signup_date 1,Mia,Tanaka,mia.tanaka1@example.com,+1-555-0101,Lisbon,Portugal,2025-01-26 2,Linh,van der Berg,linh.vanderberg2@example.org,+44 20 7946 0002,Chicago,United States,2026-12-23 3,Omar,Bianchi,omar.bianchi3@example.org,+1-555-0103,Austin,United States,2023-11-22
Yes. The data is fictitious and released into the public domain (CC0): you can copy, modify and use it in any project, including paid courses and product demos, without attribution.
No. Names, emails, phone numbers, orders and salaries are randomly generated. Emails use the reserved example.com, example.org and example.net domains and phone numbers are in ranges reserved for fiction, so they belong to nobody. Only the capital-city coordinates are real data.
Start with edge-cases-quotes-newlines.csv, which combines commas, quotes and line breaks inside fields. Then try excel-windows-1252-semicolon.csv for encoding and semicolons, leading-zeros-codes.csv for leading zeros and customers-100000.csv for performance.
Because it is deliberately encoded the way Excel on Windows saves CSV, not as UTF-8. A program that assumes UTF-8 will display accents incorrectly. That is exactly what makes it useful for checking whether your tool detects the encoding; this site's CSV viewer does it automatically.
Use the Generate Test Data tool: define the fields (name, email, UUID, number, date, city...) and the number of rows, and download the CSV or JSON straight away.