Free sample data · CSV · Excel · JSON · SQL

Sample datasets you can download in seconds

Realistic business tables and real public data for Excel, SQL, Power BI and Python practice, in any size up to 10,000 rows.

Same rows as our ready-made files. Excel workbooks are on each dataset page.

Preview · Sales ordersData dictionary

order_idtext	order_datedate	ship_datedate	ship_modetext	customer_idtext	customer_nametext	segmenttext	regiontext	statetext	citytext	categorytext	sub_categorytext	product_nametext	quantitynumber	unit_pricenumber	discountnumber	salesnumber	costnumber	profitnumber
SO-100001	2023-03-22	2023-03-25	Second Class	C0266	Patricia Murphy	Consumer	Northeast	NY	New York	Furniture	Furnishings	Desk Lamp	9	87.18	0	784.62	576.27	208.35
SO-100002	2024-06-15	2024-06-21	Standard	C0386	Susan Hill	Consumer	West	CA	Sacramento	Technology	Accessories	USB-C Hub	2	126.39	0	252.78	154.68	98.1
SO-100003	2024-01-19	2024-01-25	Standard	C0003	Stephanie Davis	Consumer	Midwest	MN	Minneapolis	Furniture	Tables	Folding Training Table	1	326.87	0	326.87	238.77	88.1
SO-100004	2023-12-05	2023-12-09	Second Class	C0481	Donna Jackson	Corporate	South	TX	Dallas	Office Supplies	Appliances	Desk Fan	1	35.16	0	35.16	23.05	12.11
SO-100005	2023-07-31	2023-08-03	Second Class	C0654	Diego Hall	Consumer	Midwest	MO	Kansas City	Technology	Machines	Laser Printer	3	473.83	0.1	1279.34	1041.54	237.8
SO-100006	2024-01-06	2024-01-09	Second Class	C0204	Charles Robinson	Consumer	Northeast	NY	Buffalo	Office Supplies	Paper	Cardstock 100 Sheets	9	10.7	0	96.3	58.95	37.35
SO-100007	2024-08-26	2024-08-28	Second Class	C0212	Ashley Nguyen	Consumer	West	CA	Los Angeles	Furniture	Chairs	Mesh Office Chair	1	288.97	0	288.97	222.81	66.16
SO-100008	2024-06-02	2024-06-06	Standard	C0724	Mei Hall	Consumer	Northeast	NY	New York	Technology	Accessories	Noise-Canceling Headset	5	31.86	0	159.3	108	51.3

1,000 rows × 19 columnssales-orders-1000.csv · 157 KBseed 42

Popular datasets

See all 18 datasets

synthetic

Sample sales data

Superstore-style retail orders with sales, cost, discount and profit.

10,000 rows max19 columns

synthetic

Sample employee data

An HR table: departments, titles, hire dates, salaries and managers.

10,000 rows max12 columns

synthetic

Sample SQL database

Four related tables (customers, products, orders, order items) for JOIN practice.

1,000 rows max4 tables

synthetic

Messy data for cleaning practice

A customer list with duplicates, blanks, mixed dates and text in number columns.

10,000 rows max12 columns

real data

U.S. state population data

Census Bureau population estimates for every state and DC, 2020-2024.

51 rows max13 columns

real data

Daily weather data, 2024

Daily temperature, rain and wind for 10 cities through 2024 (Open-Meteo).

3,660 rows max8 columns

textnumberdateyes/no

Pick your tool

each card counts the datasets shaped for it

Excel17

datasets that fit · 3 exercises

Power BI17

datasets that fit · 2 exercises

SQL10

datasets that fit · 1 exercise

Python14

datasets that fit · 2 exercises

Tableau9

datasets that fit · 2 exercises

Practise with answers

Every question is answered twice, once in SQL and once in Python, and the two must agree before it is published.

By file format

The same data, in the format your tool reads.

Where the data comes from

U.S. Geological Surveyearthquakes, public domain

U.S. Census Bureaustate population, public domain

World Bankpopulation and GDP, CC BY 4.0

Open-Meteo2024 weather, CC BY 4.0

The business tables are synthetic: generated by our own code from a fixed seed, so every file is repeatable and contains no real people. Sources, licences and method.