This page has Excel sample data that you can freely use for testing, Excel training and demos, and other educational purposes. There is a table with office supply sales sample data, or download one of the sample data files in Excel format - property insurance data, food sales records, work orders, and other topics.
The first set of sample data on this page is sales data for an imaginary office supply company, and each row represents one sales order.
Each row shows the following fields:
To get this sample data:
-- Copy and paste the data from the Office Supply Sales Table on this page
-- OR, get the sample data in an Excel file, in the download section at the bottom of this page
This sample file has fake commercial property insurance policy data.
Each row shows the following fields:
Get this insurance policy data in Excel format, in the download section at the end of this page
This sample file has food sales data, from an imaginary food company.
Each row shows the following fields:
Get this data in Excel format, in the download section at the end of this page
This sample file has fake workplace safety report data.
Each row shows the following fields:
Get this data in Excel format, in the download section at the end of this page
This sample file has fake work orders data.
Each row shows these 13 manual entry fields:
Each row shows these 9 calculated fields:
Get this data in Excel format, in the download section at the end of this page
This sample file has data from the 2018 Olympic Hockey teams, from Canada and the USA.
Each row shows these 11 manual entry fields:
Each row shows these 4 calculated fields:
Get this data in Excel format, in the download section at the end of this page
This sample file has the same data as the file above -- 2018 Olympic Hockey teams, from Canada and the USA. In addition to the data, this file includes the pivot tables that I showed in my blog post on hockey player data analysis.
For example, one pivot table shows player counts, for each position, plus age, height and weight.
Get this data, with the data analysis, in Excel format, in the download section at the end of this page.
Watch this video, to see the steps for creating a pivot table in Excel 2013 and later. There are written instructions. For detailed steps, go to the Create a Pivot Table in Excel page.
This sample file has athlete data from the 2010 Winter Olympics, in Vancouver Canada.
Each row shows these 11 manual entry fields:
Get this data in Excel format, in the download section at the end of this page
Here are the quick steps to copy the data from the table below:
OrderDate |
Region |
Rep |
Item |
Units |
UnitCost |
Total |
1/6/2020 |
East |
Jones |
Pencil |
95 |
1.99 |
189.05 |
1/23/2020 |
Central |
Kivell |
Binder |
50 |
19.99 |
999.50 |
2/9/2020 |
Central |
Jardine |
Pencil |
36 |
4.99 |
179.64 |
2/26/2020 |
Central |
Gill |
Pen |
27 |
19.99 |
539.73 |
3/15/2020 |
West |
Sorvino |
Pencil |
56 |
2.99 |
167.44 |
4/1/2020 |
East |
Jones |
Binder |
60 |
4.99 |
299.40 |
4/18/2020 |
Central |
Andrews |
Pencil |
75 |
1.99 |
149.25 |
5/5/2020 |
Central |
Jardine |
Pencil |
90 |
4.99 |
449.10 |
5/22/2020 |
West |
Thompson |
Pencil |
32 |
1.99 |
63.68 |
6/8/2020 |
East |
Jones |
Binder |
60 |
8.99 |
539.40 |
6/25/2020 |
Central |
Morgan |
Pencil |
90 |
4.99 |
449.10 |
7/12/2020 |
East |
Howard |
Binder |
29 |
1.99 |
57.71 |
7/29/2020 |
East |
Parent |
Binder |
81 |
19.99 |
1,619.19 |
8/15/2020 |
East |
Jones |
Pencil |
35 |
4.99 |
174.65 |
9/1/2020 |
Central |
Smith |
Desk |
2 |
125.00 |
250.00 |
9/18/2020 |
East |
Jones |
Pen Set |
16 |
15.99 |
255.84 |
10/5/2020 |
Central |
Morgan |
Binder |
28 |
8.99 |
251.72 |
10/22/2020 |
East |
Jones |
Pen |
64 |
8.99 |
575.36 |
11/8/2020 |
East |
Parent |
Pen |
15 |
19.99 |
299.85 |
11/25/2020 |
Central |
Kivell |
Pen Set |
96 |
4.99 |
479.04 |
12/12/2020 |
Central |
Smith |
Pencil |
67 |
1.29 |
86.43 |
12/29/2020 |
East |
Parent |
Pen Set |
74 |
15.99 |
1,183.26 |
1/15/2021 |
Central |
Gill |
Binder |
46 |
8.99 |
413.54 |
2/1/2021 |
Central |
Smith |
Binder |
87 |
15.00 |
1,305.00 |
2/18/2021 |
East |
Jones |
Binder |
4 |
4.99 |
19.96 |
3/7/2021 |
West |
Sorvino |
Binder |
7 |
19.99 |
139.93 |
3/24/2021 |
Central |
Jardine |
Pen Set |
50 |
4.99 |
249.50 |
4/10/2021 |
Central |
Andrews |
Pencil |
66 |
1.99 |
131.34 |
4/27/2021 |
East |
Howard |
Pen |
96 |
4.99 |
479.04 |
5/14/2021 |
Central |
Gill |
Pencil |
53 |
1.29 |
68.37 |
5/31/2021 |
Central |
Gill |
Binder |
80 |
8.99 |
719.20 |
6/17/2021 |
Central |
Kivell |
Desk |
5 |
125.00 |
625.00 |
7/4/2021 |
East |
Jones |
Pen Set |
62 |
4.99 |
309.38 |
7/21/2021 |
Central |
Morgan |
Pen Set |
55 |
12.49 |
686.95 |
8/7/2021 |
Central |
Kivell |
Pen Set |
42 |
23.95 |
1,005.90 |
8/24/2021 |
West |
Sorvino |
Desk |
3 |
275.00 |
825.00 |
9/10/2021 |
Central |
Gill |
Pencil |
7 |
1.29 |
9.03 |
9/27/2021 |
West |
Sorvino |
Pen |
76 |
1.99 |
151.24 |
10/14/2021 |
West |
Thompson |
Binder |
57 |
19.99 |
1,139.43 |
10/31/2021 |
Central |
Andrews |
Pencil |
14 |
1.29 |
18.06 |
11/17/2021 |
Central |
Jardine |
Binder |
11 |
4.99 |
54.89 |
12/4/2021 |
Central |
Jardine |
Binder |
94 |
19.99 |
1,879.06 |
12/21/2021 |
Central |
Andrews |
Binder |
28 |
4.99 |
139.72 |
Create an Excel TableAfter 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. |
Office Supply Sales: To get the sample office supply sales data in an Excel file, click this link: Office Suply Sales sample data workbook. The zipped file is in xlsx format, and does not contain any macros.
Insurance Policies: Click here to get the insurance policy data file. The zipped Excel file is in xlsx format, and does not contain any macros.
Food Sales: Click here to get the food sales data file. The zipped Excel file is in xlsx format, and does not contain any macros.
Workplace Safety: Click here to get the workplace safety data file. The zipped Excel file is in xlsx format, and does not contain any macros.
Work Orders: Click here to get the work orders data file. The zipped Excel file is in xlsx format, and does not contain any macros.
Hockey - Data Only: Click here to get the hockey player data file, with the data only. The zipped Excel file is in xlsx format, and does not contain any macros.
Hockey - Data Analysis: Click here to get the hockey data file, with pivot tables and pivot charts, analyzing the data. The zipped Excel file is in xlsx format, and does not contain any macros.
Winter Athletes: Click here to get the winter athletes data file. The zipped Excel file is in xlsx format, and does not contain any macros.
Here are a few of my Contextures tutorials on working with data in Excel, organizing it in tables, and summarizing the data in pivot tables.
-- Excel Tables
-- Pivot Tables
For video-based lessons on working with Excel data, I recommend these highly-rated courses, offered by Mynda Treacy. These are affiliate links, and I will earn a small commission if you purchase a product through these links.
_____________________
Last updated: May 15, 2022 2:51 PM