Excel Sample Data

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.

Sample Data - Office Supply Sales

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:

• OrderDate: when the order was placed,
• Region: geographical area in which the sale was made
• Rep: sales representative's name
• Item: name of the item sold
• Units: number of units sold
• UnitCost: cost of one unit
• Total: total cost of the order - Units x UnitCost

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

Sample Data - Insurance Policies

This sample file has fake commercial property insurance policy data.

• There are 10 columns of data, with no calculations.
• There are 500 rows of data in the insurance policy table.

Each row shows the following fields:

• Policy: Policy number, entered as text
• Expiry: date that policy expires
• Location: location type - Urban or Rural
• State: name of state where property is located
• Region: geographic region where property is located
• InsuredValue: property value
• Construction: Construction type of property, e.g. frame or masonry
• BusinessType: Business use type for property, e.g. farming or retail
• Earth: Is earthquake coverage included? Y or N
• Flood: Is flood coverage included? Y or N

Get this insurance policy data in Excel format, in the download section at the end of this page

Sample Data - Food Sales

This sample file has food sales data, from an imaginary food company.

• There are 8 columns of data, including 1 column with a calculation.
• There are 244 rows of data in the food sales table.

Each row shows the following fields:

• OrderDate: Date the order was placed
• Region: geographic region where order will be shipped
• City: city where order will be shipped
• Category: product category - Bars, Cookies, Crackers or Snacks
• Product: product name
• Quantity: number of units ordered
• UnitPrice: product selling price per unit
• TotalPrice: total price of order - calculation - Quantity x UnitPrice

Get this data in Excel format, in the download section at the end of this page

Sample Data - Workplace Safety

This sample file has fake workplace safety report data.

• There are 14 columns of data, including 3 columns with a calculation.
• There are 514 rows of data in the workplace safety report table.

Each row shows the following fields:

• Date: Date of safety incident
• Injury Location: location on body where injury occurred
• Gender: employee gender
• Age Group: employee age group (18-24, 25-34, 35-49, 50+)
• Incident Type: Type of safety incident, e.g. Burn, Fall, Vehicle
• Days Lost: number of days employee off work
• Plant: manufacturing location were incident occurred
• Report Type: Type of safety report filed - First Aid, Lost Time, Medical Claim, Near Miss
• Shift: work shift when incident occurred - Afternoon, Day, Night
• Department: work department where incident occurred
• Incident Cost: total cost of safety incident
• WkDay: 3-letter code for day of the week (calculation, based on Date)
• Month: month number (calculation, based on Date)
• Year: year number (calculation, based on Date)

Get this data in Excel format, in the download section at the end of this page

Sample Data - Work Orders

This sample file has fake work orders data.

• There are 22 columns of data, including 9 columns with a calculation.
• There are 1000 rows of data in the work orders table.

Each row shows these 13 manual entry fields:

• WO: unique work order ID
• District: geographic area where work will be done
• LeadTech: head technician at the work location
• Service: type of work to be done - Assess, Deliver, Install, Repair, Replace
• Rush: is this a rush job? Yes or blank
• ReqDate: date the work order was entered in system
• WokDate: date the work was completed
• Techs: number of technicians required
• WtyLbr: is labor under warranty? Yes or blank
• WtyParts: are parts under warranty? Yes or blank
• LbrHrs: for completed work orders - number of hours labour
• PartsCost: cost of parts required to complete the work
• Payment: type of payment customer will use - Account, C.O.D, Credit, P.O., Warranty

Each row shows these 9 calculated fields:

• Wait: WorkDate - ReqDate
• LbrRate: hourly rate lookup, based on number of technicians
• LbrCost: LbrRate x LbrHrs
• LbrFee: labor cost, if not under warranty
• PartsFee: parts cost, if not under warranty
• TotalCost: LbrCost + PartsCost
• TotalFee: LbrFee +PartsFee
• ReqDay: 3-letter weekday name, based on ReqDate
• WorkDay: 3-letter weekday name, based on WorkDate

Get this data in Excel format, in the download section at the end of this page

Sample Data - Hockey Players

This sample file has data from the 2018 Olympic Hockey teams, from Canada and the USA.

• There are 15 columns of data, including 4 columns with calculations.
• There are 96 rows of data in the hockey player table.

Each row shows these 11 manual entry fields:

• ID: unique ID number for player
• Team: type of hockey team - Men, Women
• Country: country of hockey team - Canada, USA
• NameF: player's first name (given name)
• NameL: player's last name (family name)
• Weight: player weight in pounds
• Height: player height in feet and inches
• DOB: player date of birth
• Hometown: player's hometown city
• Prov: player's hometown province
• Pos: player's position on hockey team

Each row shows these 4 calculated fields:

• Age: player's age in years, based on date of birth
• HeightFt: player's height converted to feet, with 2 decimal places shown
• HtIn: player's height converted to inches (HeightFt x 12)
• BMI: player's BMI based on Weight and HtIn

Get this data in Excel format, in the download section at the end of this page

Sample Data - Hockey Player Analysis

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.

• For each value, there are 3 different summary functions – Average,  Minimum, and  Maximum.
• In the country subtotal row, conditional formatting highlights higher amounts in red, and lower amounts in green.
• A Slicer at the top left lets you see the data for Men's or Women's hockey teams

Get this data, with the data analysis, in Excel format, in the download section at the end of this page.

Create a Pivot Table

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.

Sample Data - Winter Athletes

This sample file has athlete data from the 2010 Winter Olympics, in Vancouver Canada.

• There are 6 columns of data, with no calculations in the table.
• There are 2606 rows of data in the athletes table.

Each row shows these 11 manual entry fields:

• Name: athlete's full name - LAST First
• Sport: sport(s) athlete will participate in
• Nationality: country athlete competes for
• Age: athlete's age in years
• Wt kg: athlete's weight in kilograms
• Ht: athlete's height in centimetres

Get this data in Excel format, in the download section at the end of this page

Office Supply Sales Table

Here are the quick steps to copy the data from the table below:

• Click at the end of the text heading above the table
• Scroll down to the end of the sample data table
• Press Shift, and click at the end of the last number in the table, to select all the data
• Press Ctrl + C to copy the data
• Paste it into an Excel workbook (Ctrl+V), for use in your own tests.

Sample Data

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 Table 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.

Download the Sample Data

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.

Related Links

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

-- Data Entry Tips

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.

-- Excel Power Query Course

-- Excel Power Pivot Course

-- Excel Dashboard Course

-- Excel Expert Course

_____________________