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.

Sample Data

OrderDate

Region

Rep

Item

Units

UnitCost

Total

1/6/2016

East

Jones

Pencil

95

1.99

189.05

1/23/2016

Central

Kivell

Binder

50

19.99

999.50

2/9/2016

Central

Jardine

Pencil

36

4.99

179.64

2/26/2016

Central

Gill

Pen

27

19.99

539.73

3/15/2016

West

Sorvino

Pencil

56

2.99

167.44

4/1/2016

East

Jones

Binder

60

4.99

299.40

4/18/2016

Central

Andrews

Pencil

75

1.99

149.25

5/5/2016

Central

Jardine

Pencil

90

4.99

449.10

5/22/2016

West

Thompson

Pencil

32

1.99

63.68

6/8/2016

East

Jones

Binder

60

8.99

539.40

6/25/2016

Central

Morgan

Pencil

90

4.99

449.10

7/12/2016

East

Howard

Binder

29

1.99

57.71

7/29/2016

East

Parent

Binder

81

19.99

1,619.19

8/15/2016

East

Jones

Pencil

35

4.99

174.65

9/1/2016

Central

Smith

Desk

2

125.00

250.00

9/18/2016

East

Jones

Pen Set

16

15.99

255.84

10/5/2016

Central

Morgan

Binder

28

8.99

251.72

10/22/2016

East

Jones

Pen

64

8.99

575.36

11/8/2016

East

Parent

Pen

15

19.99

299.85

11/25/2016

Central

Kivell

Pen Set

96

4.99

479.04

12/12/2016

Central

Smith

Pencil

67

1.29

86.43

12/29/2016

East

Parent

Pen Set

74

15.99

1,183.26

1/15/2017

Central

Gill

Binder

46

8.99

413.54

2/1/2017

Central

Smith

Binder

87

15.00

1,305.00

2/18/2017

East

Jones

Binder

4

4.99

19.96

3/7/2017

West

Sorvino

Binder

7

19.99

139.93

3/24/2017

Central

Jardine

Pen Set

50

4.99

249.50

4/10/2017

Central

Andrews

Pencil

66

1.99

131.34

4/27/2017

East

Howard

Pen

96

4.99

479.04

5/14/2017

Central

Gill

Pencil

53

1.29

68.37

5/31/2017

Central

Gill

Binder

80

8.99

719.20

6/17/2017

Central

Kivell

Desk

5

125.00

625.00

7/4/2017

East

Jones

Pen Set

62

4.99

309.38

7/21/2017

Central

Morgan

Pen Set

55

12.49

686.95

8/7/2017

Central

Kivell

Pen Set

42

23.95

1,005.90

8/24/2017

West

Sorvino

Desk

3

275.00

825.00

9/10/2017

Central

Gill

Pencil

7

1.29

9.03

9/27/2017

West

Sorvino

Pen

76

1.99

151.24

10/14/2017

West

Thompson

Binder

57

19.99

1,139.43

10/31/2017

Central

Andrews

Pencil

14

1.29

18.06

11/17/2017

Central

Jardine

Binder

11

4.99

54.89

12/4/2017

Central

Jardine

Binder

94

19.99

1,879.06

12/21/2017

Central

Andrews

Binder

28

4.99

139.72

Sample Data Notes

This is sales data for an imaginary stationery company, and each row represents an order. It shows:

  • when the order was placed,
  • region in which the sale was made
  • the sales representative's name
  • the item sold
  • the number of units sold
  • the cost of a single unit
  • the total cost of the order

Get the Sample Data

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

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.

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

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 Tutorials

Excel Tables

Pivot Tables

Data Entry Tips

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search Contextures Sites

 

Excel Data Entry Popup List

 

Last updated: June 30, 2017 3:36 PM