Contextures

Excel Sample Data

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, and hockey player data.

There are hundreds more sample Excel files that you can download, and Excel lessons, with videos and written steps.

Sample Data

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

Sample Data Notes

The 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

Get the Sample Data

To use this sample data, download the sample file, or copy and paste it from the table on this page.

Download the Sample File

  • To download the sample data in an Excel file, click this link: Excel sample data workbook
  • The zipped file is in xlsx format, and does not contain any macros
  • NOTE: The Total column contains values. You could change it to a formula, to multiply the Units and Cost columns.

Copy and Paste

  • Click at the end of the "Sample Data" heading, above the table (you won't see anything happen)
  • 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, for use in your own tests.

Create an Excel Table

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.

Sample Data - Formatted Numbers

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.

  • 3/4
  • 02345
  • 1-3

Learn how to paste this type of data, and keep the formatting -- instructions on the Data Entry Tips page.

More Sample Data Files

Here are 4 more sample data files, if you'd like a bit of variety in your Excel testing.

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.

Click here to download the insurance policy data file. The zipped Excel file is in xlsx format, and does not contain any macros.

insurance sample data for testing

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.

Click here to download the food sales data file. The zipped Excel file is in xlsx format, and does not contain any macros.

food sales sample data for testing

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.

Click here to download the workplace safety data file. The zipped Excel file is in xlsx format, and does not contain any macros.

workplace safety sample data for testing

Hockey Players

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.

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

Click here to download the hockey player data file. The zipped Excel file is in xlsx format, and does not contain any macros.

hockey sample data for testing

Related Links

Excel Tables

Pivot Tables

Data Entry Tips

More Sample Files

Excel Topics

Don't Miss Our Excel Tips

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.

Get weekly Excel tips from Debra

_____________________

Excel sample data for testing

Last updated: November 24, 2020 4:05 PM