Sample Orders CSV File — Free Download
An e-commerce orders table that references the sample customers file on customer_id, with order status values for filtering and a total column for revenue work — the file to use when you want to practise joins.
Download the sample file
CSV · 300 rows · 19.0 KB · synthetic data, free for any use
Download CSV samplePreview
| order_id | customer_id | date | product | quantity | total | status |
|---|---|---|---|---|---|---|
| ORD-2001 | CUST-0114 | 2026-06-30 | Mechanical Keyboard | 4 | 1122.80 | Shipped |
| ORD-2002 | CUST-0049 | 2026-04-26 | Laptop Stand | 3 | 292.08 | Shipped |
| ORD-2003 | CUST-0038 | 2026-06-21 | Standing Desk | 5 | 749.45 | Cancelled |
| ORD-2004 | CUST-0198 | 2026-05-05 | Wireless Mouse | 2 | 500.38 | Delivered |
| ORD-2005 | CUST-0079 | 2026-04-04 | Ergonomic Chair | 1 | 121.39 | Returned |
| ORD-2006 | CUST-0102 | 2026-05-30 | Laptop Stand | 3 | 828.96 | Delivered |
Showing the first 6 of 300 rows.
Columns
| Column | Type | Description |
|---|---|---|
order_id | string | Primary key, ORD-2001… |
customer_id | string | Foreign key to the customers sample (CUST-0001…) |
date | date (YYYY-MM-DD) | Order date over ~210 days |
product | string | Product ordered |
quantity | integer | Units ordered (1–5) |
total | decimal | Order total, USD |
status | string | Processing, Shipped, Delivered, Cancelled or Returned |
What makes this file useful
- Every customer_id here exists in the sample customers file, so an inner join loses no rows — ideal for teaching joins.
- status includes Cancelled and Returned, which you usually want to exclude from revenue — a good filtering exercise.
- Multiple orders share a customer_id, so per-customer aggregation produces meaningful groups.
Use cases
- Join orders to the sample customers CSV on customer_id
- Count and filter orders by status (how many still Processing?)
- Build a revenue-over-time chart from date and total
- Calculate average order value and repeat-purchase rate
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 sample order data real?
No. Orders, customers and totals are synthetic and generated for testing only.
Can I use this sample CSV commercially?
Yes, it is free to download and use for any purpose, including QA and demo pipelines.
How do I join it to the customers file?
Match orders.customer_id to customers.customer_id. Every order points at a customer that exists in that file.
How many rows?
300 order rows plus the header.
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.