Sample Sales Data
Order-level sales rows with region, product, channel, units and unit price. Calculate revenue, build PivotTables and compare with complete reference answers.
Start the 8-task practice package — files and complete answers
What is in the file
8 columns, 200 data rows by default, plus a header row. These are the first ten rows of the default file.
| Order ID | Order Date | Region | Channel | Product | Category | Units | Unit Price |
|---|---|---|---|---|---|---|---|
| ORD-1000 | 2026-06-06 | South | Direct | USB-C Dock | Hardware | 31 | 983.15 |
| ORD-1001 | 2026-03-23 | Central | Partner | Laptop Stand | Accessories | 23 | 1279.53 |
| ORD-1002 | 2026-01-06 | South | Retail | Webcam HD | Furniture | 8 | 143.9 |
| ORD-1003 | 2026-10-23 | Central | Online | Standing Desk | Peripherals | 39 | 440.28 |
| ORD-1004 | 2026-04-04 | North | Direct | Ergonomic Chair | Hardware | 37 | 736.65 |
| ORD-1005 | 2026-01-19 | East | Partner | Mechanical Keyboard | Accessories | 29 | 1033.02 |
| ORD-1006 | 2026-11-04 | North | Retail | USB-C Dock | Furniture | 14 | 1329.4 |
| ORD-1007 | 2026-08-21 | West | Online | Laptop Stand | Peripherals | 6 | 193.77 |
| ORD-1008 | 2026-10-10 | West | Direct | Monitor 27" | Hardware | 17 | 490.14 |
| ORD-1009 | 2026-07-26 | South | Partner | Noise-Cancel Headset | Accessories | 9 | 786.52 |
Download 200 rows
8 columns · header included · no signup
Direct files work without JavaScript. Choose another size below.
Get the matching tasks and answer filesBuilt in your browser when you click. Nothing is uploaded, no signup, free for commercial use.
About this dataset
The source is a flat, eight-column order table. Units and Unit Price are provided; Revenue is a derived column you create as part of the exercise. The package includes the full reference table, formulas and expected region/category and monthly summaries. Product, category and price are generated independently, so do not treat a product name as a unique price key.
The Excel download stores date columns as numeric Excel dates with a date format. CSV and JSON contain ISO date text; convert those fields to dates during import before using date arithmetic or grouping by month.
File layout and import notes
- The download occupies A:H when opened in a new worksheet with its header in row 1. G contains Units and H contains Unit Price; add Revenue in I without replacing a source column.
- Products, categories and prices are generated independently. These rows support formula practice, not real product pricing or business conclusions.
Free practice package · 200 source rows
Tasks, complete answers and a file to keep
Start with eight source columns, calculate Revenue, then build region/category and monthly PivotTables. The solution workbook contains formulas and expected tables; it does not pretend those tables are native PivotTable objects.
Version 2026-10-08.1. These answers match the default 200-row source file, not the other sizes in the download control.
1. Start with the source file
Keep an unchanged copy. Work through the tasks before opening the answers.
Tasks only (.md) — no answers2. Compare with complete answers
The workbook contains the original data, every reference row and expected checks. The CSV contains the full reference table.
All files download directly without signup or JavaScript. Markdown (.md) handouts are plain-text files you can open in a text editor. The answer sheets contain fixed reference values; formula sheets, where included, recalculate in your spreadsheet application.
The printable HTML files open in a browser. Choose Print or Save as PDF. The tasks sheet has writing space and no hidden answers; the worked-answer sheet includes formulas and expected tables.
Before you start
- Answers match the default 200-row file only. Revenue is not a source column: calculate Units × Unit Price and round each order to two decimals.
- Amounts are synthetic currency-neutral practice values. Product, category and price are generated independently; a product name is not a reliable price-lookup key.
- The default XLSX stores Order Date as numeric dates. CSV/JSON imports need explicit date conversion before grouping by month.
- The answer workbook includes formula results and expected summaries, not prebuilt interactive PivotTables. Create the PivotTables yourself using the steps below.
8 tasks to work through
Inspect the source table
Check that the source has eight columns and one record per order. Identify the two inputs needed for Revenue.
Show answer and method for task 1
200 records. G is Units and H is Unit Price. No source Revenue column exists yet.
Calculate revenue
Add Revenue in I and fill a per-order formula down.
Show answer and method for task 2
=ROUND(G2*H2,2)First order revenue: 30477.65. Sum I2:I201 to obtain 3051575.50.
Create a region/category PivotTable
Summarize revenue by region and category.
Show answer and method for task 3
Select A1:I201. Choose Insert > PivotTable > New Worksheet. Put Region in Rows, Category in Columns and Revenue in Values. In Value Field Settings choose Sum, not Count. Compare every cell with Region by category answers.
Cross-check one pivot cell
Independently reproduce the first region/category value with SUMIFS.
Show answer and method for task 4
=SUMIFS($I$2:$I$201,$C$2:$C$201,"Central",$F$2:$F$201,"Accessories")Central / Accessories: 198347.70. SUMIFS and the corresponding PivotTable cell should agree.
Prepare a month key
Add Month in J from the real Order Date.
Show answer and method for task 5
=TEXT(B2,"yyyy-mm")Fill down and use Month as a row field. Alternatively group numeric Order Date values by Years and Months in a PivotTable. Date-format tokens can differ in localized Excel.
Build monthly revenue totals
Create a second PivotTable with Month in Rows and Revenue in Values, summarized by Sum.
Show answer and method for task 6
There are 12 months present. The Monthly revenue answers sheet provides every expected total. Monthly totals must add to 3051575.50.
Calculate revenue per unit
Calculate the aggregate revenue per unit, not the unweighted average of order prices.
Show answer and method for task 7
=SUM(I2:I201)/SUM(G2:G201)685.44 displayed to two decimals. Total units: 4452. This ratio weights prices by units.
Refresh and reconcile
Change a Units value in your working copy, refresh your PivotTables and check both totals.
Show answer and method for task 8
The original answer file is a fixed reference for the unchanged source. After edits, both PivotTables must agree with your new Revenue total, not the old reference. Clear filters before comparing grand totals.
Check your results before opening the answers
Enter the values you calculated from the unchanged 200-row file. This checks a few totals and counts, not your whole workbook.
Use a decimal point, no thousands separators and at most two decimal places: 1234.56. Round averages to two decimals. Leave checks you have not tried blank.
Your entries are checked only in this page. They are not uploaded, saved or included in analytics. Use Clear values to remove them.
Need the worked solution? Go to the expected checks and summary tables below.
Show expected checks and summary tables
Check your work
| Check | Expected |
|---|---|
| Order records | 200 |
| Units | 4452 |
| Revenue | 3051575.50 |
| First order revenue | 30477.65 |
| Regions | 5 |
| Categories | 4 |
| Months present | 12 |
Region by category answers
| Region | Accessories | Furniture | Hardware | Peripherals | Total |
|---|---|---|---|---|---|
| Central | 198347.70 | 148982.36 | 191063.50 | 218626.31 | 757019.87 |
| East | 212811.04 | 162634.42 | 161857.66 | 121496.36 | 658799.48 |
| North | 184619.95 | 123095.94 | 199994.80 | 105790.72 | 613501.41 |
| South | 112183.27 | 122266.30 | 115801.91 | 116163.84 | 466415.32 |
| West | 176404.05 | 69496.90 | 147618.89 | 162319.58 | 555839.42 |
Monthly revenue answers
| Month | Revenue |
|---|---|
| 2026-01 | 302835.65 |
| 2026-02 | 290809.62 |
| 2026-03 | 439673.18 |
| 2026-04 | 223069.98 |
| 2026-05 | 230850.94 |
| 2026-06 | 190651.27 |
| 2026-07 | 226570.23 |
| 2026-08 | 89637.54 |
| 2026-09 | 169823.29 |
| 2026-10 | 276874.55 |
| 2026-11 | 294711.71 |
| 2026-12 | 316067.54 |
Preview the first three reference rows
| Order ID | Order Date | Region | Channel | Product | Category | Units | Unit Price | Revenue | Month |
|---|---|---|---|---|---|---|---|---|---|
| ORD-1000 | 2026-06-06 | South | Direct | USB-C Dock | Hardware | 31 | 983.15 | 30477.65 | 2026-06 |
| ORD-1001 | 2026-03-23 | Central | Partner | Laptop Stand | Accessories | 23 | 1279.53 | 29429.19 | 2026-03 |
| ORD-1002 | 2026-01-06 | South | Retail | Webcam HD | Furniture | 8 | 143.9 | 1151.2 | 2026-01 |
Use this in a lesson or tutorial
Share the source file and tasks-only handout first, then release the answers. Use the checks to discuss different approaches; matching one total does not prove every row is correct.
Free for practice, teaching, demos and commercial use. Attribution is welcome, not required. These are generated records, not real customer or student data. Link to this page so learners can get matching files.
Download starts and successful formula copies may be counted without sending your spreadsheet contents or a visitor identifier. The site respects Do Not Track and Global Privacy Control for these counts. Downloads are not proof of task completion.
Calculate revenue, then check the regional totals
Open the default 200-row download with headers in row 1. The file has eight source columns and no Revenue column. Add Revenue in I1, enter =G2*H2 in I2 and fill down to I201. Display revenue with two decimal places; keep A:H unchanged.
I2: calculate revenue for the first order
=G2*H2Outside A:I: total the calculated revenue
=SUM(I2:I201)Outside A:I: total North revenue
=SUMIF(C2:C201,"North",I2:I201)| Excel row | Order ID | G: Units | H: Unit Price | I: Calculated Revenue |
|---|---|---|---|---|
| 2 | ORD-1000 | 31 | 983.15 | 30477.65 |
| 3 | ORD-1001 | 23 | 1279.53 | 29429.19 |
| 4 | ORD-1002 | 8 | 143.90 | 1151.20 |
If columns are cut off, scroll the table sideways.
| Region | Revenue, displayed to 2 decimals |
|---|---|
| North | 613501.41 |
| South | 466415.32 |
| East | 658799.48 |
| West | 555839.42 |
| Central | 757019.87 |
| Grand total | 3051575.50 |
If columns are cut off, scroll the table sideways.
- Revenue is a reader-calculated helper, not a column supplied in the download. Multiplying Unit Price alone, or summing Unit Price, does not calculate order revenue.
- For a PivotTable check, use A1:I201 as the source, Region as a row field and Revenue as a summed value. Confirm it says Sum rather than Count; text values can produce a count instead.
- If your PivotTable was created before column I, include Revenue in its source and refresh before comparing these totals.
- These checks apply only to the default 200-row file. With another row count, extend the formula ranges and recalculate the expected results.
- Products, categories and prices are generated independently. The amounts have no assigned currency and do not represent real sales or realistic product margins.
- The formulas use English function names, comma separators and dot decimals. Convert CSV/JSON numeric text on import; localized Excel may require semicolons or translated function names.
Documentation reviewed .
Microsoft: Create a simple formulaMicrosoft: SUMIFMicrosoft: Create a PivotTable
What you can practise with it
- Calculate Revenue from Units and Unit Price
- Build a PivotTable of revenue by region and category
- Cross-check pivot cells with SUMIFS
- Summarize monthly revenue and reconcile grand totals
Try a related exercise
- Total a column with SUM — The first formula everybody learns, and the one place a typed-out chain of plus signs still costs people an afternoon.
- Total only the rows that match, with SUMIF — Aggregating a slice of the data instead of all of it — the step from a total to a report.
- Count rows that meet two conditions — COUNTIFS with two criteria — where "how many" questions actually start.
- Find the third-largest value without sorting — Top-n answers that do not disturb the sheet — and do not break when two values tie.
- Average one region over the last seven calendar days — Choose a date window that includes late readings on its final day, ignores missing observations and retains measured zeros.
Worked examples for this data
Tools that work on this data
Free to use, share and republish — including commercially. Attribution isn't required, but it's what keeps these free to make, and there's one ready to paste below.
Questions
Is this sample sales data free to use?
Yes — for practice, teaching, demos and commercial work alike. The rows are generated, so there is no personal data in the file. Attribution is not required; if you would like to credit it, there is a ready-made line at the bottom of this page.
Do I have to sign up or give an email address?
No. Direct links download the default-size files without JavaScript. The row-count control builds other supported sizes in your browser. Your spreadsheet contents are not uploaded and no account is involved.
Which formats can I download?
The original dataset is available as Excel (.xlsx), CSV and JSON. All three contain the same source rows, so you can use the CSV for an import exercise and the .xlsx for a formula exercise.
Can I choose how many rows I get?
Yes. The browser control offers 25, 100, 200, 500 data rows, plus a header. Direct source links contain 200 data rows; the preview shows the first ten of those rows.
Does this file include tasks and complete answers?
Yes. The practice package has 8 tasks, a separate tasks-only handout, a full walkthrough and a workbook with every reference row and expected checks. Answers apply only to the default 200-row source file. The workbook is a reference and formula solution, not a native Excel execution certificate or a prebuilt interactive PivotTable.