Contextures

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 order. Each row shows:

  • 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

insurance sample data for testing

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.

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

insurance sample data for testing

Sample Data - Food Sales

This sample file has fake food sales data.

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

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

food sales sample data for testing

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.

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

workplace safety sample data for testing

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.

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

work order sample data for testing

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.

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

hockey sample data for testing

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.

hockey sample data pivot table analysis

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.

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

_____________________

Excel sample data for testing

Last updated: November 24, 2021 3:55 PM