Sample Sales CSV File — Free Download
A realistic retail sales dataset with orders spread across six months, five regions and a dozen products — enough volume to build a real pivot table, revenue chart or region breakdown.
Download the sample file
CSV · 240 rows · 16.4 KB · synthetic data, free for any use
Download CSV samplePreview
| order_id | date | product | quantity | unit_price | total | region | salesperson |
|---|---|---|---|---|---|---|---|
| SO-1001 | 2026-05-04 | Mechanical Keyboard | 6 | 112.70 | 676.20 | North | Sofia Kowalski |
| SO-1002 | 2026-06-26 | USB-C Hub | 6 | 35.78 | 214.68 | South | Sofia Kowalski |
| SO-1003 | 2026-03-08 | Standing Desk | 1 | 111.15 | 111.15 | South | Elena Cohen |
| SO-1004 | 2026-02-14 | Webcam 1080p | 1 | 112.67 | 112.67 | East | Omar Haddad |
| SO-1005 | 2026-02-22 | Webcam 1080p | 1 | 54.09 | 54.09 | Central | Sofia Kowalski |
| SO-1006 | 2026-01-18 | Desk Lamp | 4 | 215.54 | 862.16 | West | Omar Haddad |
Showing the first 6 of 240 rows.
Columns
| Column | Type | Description |
|---|---|---|
order_id | string | Unique order identifier (SO-1001…) |
date | date (YYYY-MM-DD) | Order date across a 180-day window |
product | string | Product name, 12 distinct values |
quantity | integer | Units on the order (1–8) |
unit_price | decimal | Price per unit in USD |
total | decimal | quantity × unit_price, USD |
region | string | Sales region (North, South, East, West, Central) |
salesperson | string | Rep who owns the order, 6 distinct names |
What makes this file useful
- total is pre-computed from quantity × unit_price, so you can validate your own aggregation logic against it.
- Dates span roughly Jan–Jun 2026, which gives you at least six monthly buckets for trend work.
- Every region and salesperson appears many times, so grouped counts are never based on a single row.
Use cases
- Build a revenue-by-month pivot table or line chart
- Practise GROUP BY region / salesperson aggregations in SQL
- Test a "top products by revenue" dashboard widget
- Try a running-total or month-over-month growth calculation
Open it in a tool
Load this sample — or your own file — into a real tool. Everything runs client-side.
Related guides
More sample datasets
Frequently asked questions
Is this real sales data?
No. Every order, price and name is synthetic and generated for testing. It is safe to publish in tutorials or demos.
Can I use it commercially?
Yes. It is free for any use, including paid courses, QA pipelines and product demos.
How many rows does it have?
The file has 240 data rows plus a header row.
Does it join to the other sample files?
The salesperson names overlap conceptually with the employees sample, and you can treat region as a shared dimension, but there is no strict foreign key — use the orders + customers samples for join practice.
Turn this into a saved workflow
Create a free account to save the steps from this guide as a reusable workflow and re-run it on any file, from any device.
Follow HowToCSV on Google
Add us as a preferred source on Google Search so our latest CSV guides and tutorials surface more often in your Top stories.