The sample data on this page is sales data for an fictional office supply company. Each row in the data represents one sales order for their stationery products.
There are 2 ways to get the sample data:
The sample data on this page is sales data for an fictional office supply company. The screenshot below shows a few rows of the data, and all 7 columns in the list..
The company sells stationery products, like pencils and binders, and office furniture too. There are sales in 3 regions, with sales reps in each region.

Each row in the Excel dummy data shows the following seven fields:
Instead of downloading the Office Supply data, you can quickly copy and paste the sales data (below) into your Excel file.
✅ Tip: Below the data, see my quick trick for changing the dates in the sample data
Here's the quick trick that I use to select website data, then copy it, and paste it into Excel. The written steps are below the video.
Here are the quick steps to copy the data from the table below, and paste into your Excel worksheet:
✅ Tip: Below the data, see my quick trick for changing the dates in the sample data
|
OrderDate |
Region |
Rep |
Item |
Units |
UnitCost |
Total |
|
1/6/2026 |
East |
Jones |
Pencil |
95 |
1.99 |
189.05 |
|
1/23/2026 |
Central |
Kivell |
Binder |
50 |
19.99 |
999.50 |
|
2/9/2026 |
Central |
Jardine |
Pencil |
36 |
4.99 |
179.64 |
|
2/26/2026 |
Central |
Gill |
Pen |
27 |
19.99 |
539.73 |
|
3/15/2026 |
West |
Sorvino |
Pencil |
56 |
2.99 |
167.44 |
|
4/1/2026 |
East |
Jones |
Binder |
60 |
4.99 |
299.40 |
|
4/18/2026 |
Central |
Andrews |
Pencil |
75 |
1.99 |
149.25 |
|
5/5/2026 |
Central |
Jardine |
Pencil |
90 |
4.99 |
449.10 |
|
5/22/2026 |
West |
Thompson |
Pencil |
32 |
1.99 |
63.68 |
|
6/8/2026 |
East |
Jones |
Binder |
60 |
8.99 |
539.40 |
|
6/25/2026 |
Central |
Morgan |
Pencil |
90 |
4.99 |
449.10 |
|
7/12/2026 |
East |
Howard |
Binder |
29 |
1.99 |
57.71 |
|
7/29/2026 |
East |
Parent |
Binder |
81 |
19.99 |
1619.19 |
|
8/15/2026 |
East |
Jones |
Pencil |
35 |
4.99 |
174.65 |
|
9/1/2026 |
Central |
Smith |
Desk |
2 |
125.00 |
250.00 |
|
9/18/2026 |
East |
Jones |
Pen Set |
16 |
15.99 |
255.84 |
|
10/5/2026 |
Central |
Morgan |
Binder |
28 |
8.99 |
251.72 |
|
10/22/2026 |
East |
Jones |
Pen |
64 |
8.99 |
575.36 |
|
11/8/2026 |
East |
Parent |
Pen |
15 |
19.99 |
299.85 |
|
11/25/2026 |
Central |
Kivell |
Pen Set |
96 |
4.99 |
479.04 |
|
12/12/2026 |
Central |
Smith |
Pencil |
67 |
1.29 |
86.43 |
|
12/29/2026 |
East |
Parent |
Pen Set |
74 |
15.99 |
1183.26 |
|
1/15/2027 |
Central |
Gill |
Binder |
46 |
8.99 |
413.54 |
|
2/1/2027 |
Central |
Smith |
Binder |
87 |
15.00 |
1305.00 |
|
2/18/2027 |
East |
Jones |
Binder |
4 |
4.99 |
19.96 |
|
3/7/2027 |
West |
Sorvino |
Binder |
7 |
19.99 |
139.93 |
|
3/24/2027 |
Central |
Jardine |
Pen Set |
50 |
4.99 |
249.50 |
|
4/10/2027 |
Central |
Andrews |
Pencil |
66 |
1.99 |
131.34 |
|
4/27/2027 |
East |
Howard |
Pen |
96 |
4.99 |
479.04 |
|
5/14/2027 |
Central |
Gill |
Pencil |
53 |
1.29 |
68.37 |
|
5/31/2027 |
Central |
Gill |
Binder |
80 |
8.99 |
719.20 |
|
6/17/2027 |
Central |
Kivell |
Desk |
5 |
125.00 |
625.00 |
|
7/4/2027 |
East |
Jones |
Pen Set |
62 |
4.99 |
309.38 |
|
7/21/2027 |
Central |
Morgan |
Pen Set |
55 |
12.49 |
686.95 |
|
8/7/2027 |
Central |
Kivell |
Pen Set |
42 |
23.95 |
1005.90 |
|
8/24/2027 |
West |
Sorvino |
Desk |
3 |
275.00 |
825.00 |
|
9/10/2027 |
Central |
Gill |
Pencil |
7 |
1.29 |
9.03 |
|
9/27/2027 |
West |
Sorvino |
Pen |
76 |
1.99 |
151.24 |
|
10/14/2027 |
West |
Thompson |
Binder |
57 |
19.99 |
1139.43 |
|
10/31/2027 |
Central |
Andrews |
Pencil |
14 |
1.29 |
18.06 |
|
11/17/2027 |
Central |
Jardine |
Binder |
11 |
4.99 |
54.89 |
|
12/4/2027 |
Central |
Jardine |
Binder |
94 |
19.99 |
1879.06 |
|
12/21/2027 |
Central |
Andrews |
Binder |
28 |
4.99 |
139.72 |
After you get the sample data into your Excel file, you can make a quick change to the order dates, with the easy trick that I show in this video.
Enter your new starting date in the first row of data, then fill down the rest of the column with this shortcut!
There are many more Excel files with sample data that you can download! Go to any of the pages listed below, and get more data sets for Excel practice.
![]() |
Food Sales - This sample Excel file has food sales data, from a fictional food company. For details on this data, and to download the zipped Excel file, go to the Food Sales Sample Data page. |
![]() |
Athlete Data - These sample Excel files have data for football players, and winter games athletes. For details on this data, and to download the zipped Excel file, go to the Athletes Sample Data page. |
![]() |
Hockey Player Data - This sample file has data from the 2018 Olympic Hockey teams, from Canada and the USA. For details on this data, and to download the sample file, go to the hockey player data analysis page. |
![]() |
Workplace Safety Data: This sample file has data for workplace safety incidents. For details on this data, and to download the zipped Excel file, go to the Workplace Safety Sample Data page. |
![]() |
Work Orders Data: This sample file has data for service department work orders. For details on this data, and to download the zipped Excel file, go to the Work Orders Sample Data page. |
![]() |
Insurance Policies: This sample file has commercial insurance policy data for a fictional insurance company. For details on this data, and to download the zipped Excel file, go to the Insurance Policy Sample Data page. |
![]() |
Food Nutrients: This sample file has food nutrient data for about 1000 food items. For details on this data, and to download the zipped Excel file, go to the Food Nutrients Sample Data page. |
Find new ideas for your Excel practice sessions, or for training topics.
![]() |
Excel Tables: Use named Excel tables for your data, so it's easier to sort and filter the data. There are written steps and a video on the Creating an Excel Table page. |
![]() |
Shortcuts -- Save time in Excel with data entry tips and shortcuts. Details on the Excel Data Entry Tips page. |
![]() |
Pivot Tables: See how to plan, get ideas, and build what you need, on the Pivot Table Setup page. |
![]() |
Pie Charts: Build a pie chart in Excel, and avoid problems, on the Pie Chart Examples page. |
Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up.
Next, when you get my reply, click the Confirm button. I add this step to protect you from spam!
In this section, you'll find related Excel tips, shortcuts, skills, and details. These things are nice to know, but not essential, so you can skip this section, and get back to work. Or dive in, for some extra Excel fun and knowledge!
--1) Why Use Sample Data in Excel?
--2) Tip: Create an Excel Table
--3) Create Your Own Test Data
Here are a few of the reasons that people have shared with me, as to why they like using these datasets, with dummy data for Excel:
After you copy the Office Supply Sales sample data from the table above, and paste it into Excel, you can format the data as a named Excel table. This will make it easier to sort and filter the data.
Watch this short video to see the steps, and there are written instructions on the Creating an Excel Table page.
If you need to create sample test data in Excel, the RANDBETWEEN function can help you get the job done quickly.
This video shows how to use the RANDBETWEEN function to quickly create test data with month headings, customer numbers, and random numbers. You'll also see how change the formulas to static values.
There are written steps on the Excel RAND and RANDBETWEEN Functions page.

Last updated: June 9, 2026 11:35 AM