Below is a table with the Excel sample data used for many of my web site examples. You can use this sample data to create test files, and build Excel tables and pivot tables from the data. Copy and paste from this table, or download the sample data file.
If you need more variety in your Excel sample data, go to the More Sample Data Files section below. There are sample files with property insurance data, food sales records, work orders, and hockey player data.
There are hundreds more sample Excel files that you can download, and Excel lessons, with videos and written steps.
To use this office supply sales sample data:
OrderDate |
Region |
Rep |
Item |
Units |
UnitCost |
Total |
1/6/2019 |
East |
Jones |
Pencil |
95 |
1.99 |
189.05 |
1/23/2019 |
Central |
Kivell |
Binder |
50 |
19.99 |
999.50 |
2/9/2019 |
Central |
Jardine |
Pencil |
36 |
4.99 |
179.64 |
2/26/2019 |
Central |
Gill |
Pen |
27 |
19.99 |
539.73 |
3/15/2019 |
West |
Sorvino |
Pencil |
56 |
2.99 |
167.44 |
4/1/2019 |
East |
Jones |
Binder |
60 |
4.99 |
299.40 |
4/18/2019 |
Central |
Andrews |
Pencil |
75 |
1.99 |
149.25 |
5/5/2019 |
Central |
Jardine |
Pencil |
90 |
4.99 |
449.10 |
5/22/2019 |
West |
Thompson |
Pencil |
32 |
1.99 |
63.68 |
6/8/2019 |
East |
Jones |
Binder |
60 |
8.99 |
539.40 |
6/25/2019 |
Central |
Morgan |
Pencil |
90 |
4.99 |
449.10 |
7/12/2019 |
East |
Howard |
Binder |
29 |
1.99 |
57.71 |
7/29/2019 |
East |
Parent |
Binder |
81 |
19.99 |
1,619.19 |
8/15/2019 |
East |
Jones |
Pencil |
35 |
4.99 |
174.65 |
9/1/2019 |
Central |
Smith |
Desk |
2 |
125.00 |
250.00 |
9/18/2019 |
East |
Jones |
Pen Set |
16 |
15.99 |
255.84 |
10/5/2019 |
Central |
Morgan |
Binder |
28 |
8.99 |
251.72 |
10/22/2019 |
East |
Jones |
Pen |
64 |
8.99 |
575.36 |
11/8/2019 |
East |
Parent |
Pen |
15 |
19.99 |
299.85 |
11/25/2019 |
Central |
Kivell |
Pen Set |
96 |
4.99 |
479.04 |
12/12/2019 |
Central |
Smith |
Pencil |
67 |
1.29 |
86.43 |
12/29/2019 |
East |
Parent |
Pen Set |
74 |
15.99 |
1,183.26 |
1/15/2020 |
Central |
Gill |
Binder |
46 |
8.99 |
413.54 |
2/1/2020 |
Central |
Smith |
Binder |
87 |
15.00 |
1,305.00 |
2/18/2020 |
East |
Jones |
Binder |
4 |
4.99 |
19.96 |
3/7/2020 |
West |
Sorvino |
Binder |
7 |
19.99 |
139.93 |
3/24/2020 |
Central |
Jardine |
Pen Set |
50 |
4.99 |
249.50 |
4/10/2020 |
Central |
Andrews |
Pencil |
66 |
1.99 |
131.34 |
4/27/2020 |
East |
Howard |
Pen |
96 |
4.99 |
479.04 |
5/14/2020 |
Central |
Gill |
Pencil |
53 |
1.29 |
68.37 |
5/31/2020 |
Central |
Gill |
Binder |
80 |
8.99 |
719.20 |
6/17/2020 |
Central |
Kivell |
Desk |
5 |
125.00 |
625.00 |
7/4/2020 |
East |
Jones |
Pen Set |
62 |
4.99 |
309.38 |
7/21/2020 |
Central |
Morgan |
Pen Set |
55 |
12.49 |
686.95 |
8/7/2020 |
Central |
Kivell |
Pen Set |
42 |
23.95 |
1,005.90 |
8/24/2020 |
West |
Sorvino |
Desk |
3 |
275.00 |
825.00 |
9/10/2020 |
Central |
Gill |
Pencil |
7 |
1.29 |
9.03 |
9/27/2020 |
West |
Sorvino |
Pen |
76 |
1.99 |
151.24 |
10/14/2020 |
West |
Thompson |
Binder |
57 |
19.99 |
1,139.43 |
10/31/2020 |
Central |
Andrews |
Pencil |
14 |
1.29 |
18.06 |
11/17/2020 |
Central |
Jardine |
Binder |
11 |
4.99 |
54.89 |
12/4/2020 |
Central |
Jardine |
Binder |
94 |
19.99 |
1,879.06 |
12/21/2020 |
Central |
Andrews |
Binder |
28 |
4.99 |
139.72 |
The sample data on this page is sales data for an imaginary office supply company, and each row represents one order. Each row shows:
To use this sample data, download the sample file, or copy and paste it from the table on this page.
After you paste the sample data into Excel, you can format it 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 copy numbers such as 1-4 or 3/5 and paste them into Excel, they will usually change to dates.
For example, copy the numbers below, and paste them onto a worksheet, to see how Excel adjusts them.
Learn how to paste this type of data, and keep the formatting -- instructions on the Data Entry Tips page.
Here are 4 more sample data files, if you'd like a bit of variety in your Excel testing.
This sample file has fake commercial property insurance policy data.
Click here to download the insurance policy data file. The zipped Excel file is in xlsx format, and does not contain any macros.
This sample file has fake food sales data.
Click here to download the food sales data file. The zipped Excel file is in xlsx format, and does not contain any macros.
This sample file has fake workplace safety report data.
Click here to download the workplace safety data file. The zipped Excel file is in xlsx format, and does not contain any macros.
This sample file has fake work orders data.
Click here to download the work orders data file. The zipped Excel file is in xlsx format, and does not contain any macros.
This sample file has data from the 2018 Olympic Hockey teams, from Canada and the USA. I used this data in my blog post on hockey player data analysis.
Click here to download the hockey player data file. The zipped Excel file is in xlsx format, and does not contain any macros.
Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.
_____________________
Last updated: February 23, 2021 12:15 PM