Home > Data > Sample Data

Excel Sample Data for Practice

Debra Dalgleish - Contextures

Get this Microsoft Excel sample data for practice and training. Quickly download the dummy data for office supply orders, then use it to while learning how to lookup, sort, filter, create formulas, pivot tables and more Excel skills!

Excel sample data for practice sort filter pivot and more

1) Get Sample Data for Practice

The sample data on this page is sales data for an fictional office supply company. Each row in the data represents one sales order for their stationery products.

There are 2 ways to get the sample data:

  1. Excel File: To get the sample data in an Excel file, click the link below:
  2. Copy Paste: To copy and paste the sales data into your Excel file, go the Copy Paste Sample Data section, further down this page.

2) About the Sample Data

The sample data on this page is sales data for an fictional office supply company. The screenshot below shows a few rows of the data, and all 7 columns in the list..

The company sells stationery products, like pencils and binders, and office furniture too. There are sales in 3 regions, with sales reps in each region.

sample data for testing

2.1) Sample Data Columns (Fields)

Each row in the Excel dummy data shows the following seven fields:

  1. Order Date: first column shows date that the order was placed
  2. Region: geographical area where the sale was made - East, West or Central
  3. Rep: sales representative's last name (family name)
  4. Item: name of the office supply item sold, such as binder, pencil, or desk.
  5. Units: number of units sold
  6. UnitCost: cost of one unit
  7. Total: total cost of the order

3) Sample Data - Copy Paste

Instead of downloading the Office Supply data, you can quickly copy and paste the sales data (below) into your Excel file.

✅  Tip: Below the data, see my quick trick for changing the dates in the sample data

3.1) Quick Steps to Copy and Paste

Here's the quick trick that I use to select website data, then copy it, and paste it into Excel. The written steps are below the video.

Here are the quick steps to copy the data from the table below, and paste into your Excel worksheet:

  1. First, select a few letters, at the start of the Order Date heading
  2. Next, scroll down to the end of the sample data table
  3. On your keyboard, press Shift, and then click at the end of the last number in the Total column, to select all the data
  4. Then, on your keyboard, press Ctrl + C to copy the selected data
  5. Next, go to Excel, and select the cell where you want to paste the data
  6. Right-click that cell, and click the Paste command
    • Or use the paste shortcut: Ctrl + V

✅  Tip: Below the data, see my quick trick for changing the dates in the sample data

3.2) Office Supply Sales Data

OrderDate

Region

Rep

Item

Units

UnitCost

Total

1/6/2026

East

Jones

Pencil

95

1.99

189.05

1/23/2026

Central

Kivell

Binder

50

19.99

999.50

2/9/2026

Central

Jardine

Pencil

36

4.99

179.64

2/26/2026

Central

Gill

Pen

27

19.99

539.73

3/15/2026

West

Sorvino

Pencil

56

2.99

167.44

4/1/2026

East

Jones

Binder

60

4.99

299.40

4/18/2026

Central

Andrews

Pencil

75

1.99

149.25

5/5/2026

Central

Jardine

Pencil

90

4.99

449.10

5/22/2026

West

Thompson

Pencil

32

1.99

63.68

6/8/2026

East

Jones

Binder

60

8.99

539.40

6/25/2026

Central

Morgan

Pencil

90

4.99

449.10

7/12/2026

East

Howard

Binder

29

1.99

57.71

7/29/2026

East

Parent

Binder

81

19.99

1619.19

8/15/2026

East

Jones

Pencil

35

4.99

174.65

9/1/2026

Central

Smith

Desk

2

125.00

250.00

9/18/2026

East

Jones

Pen Set

16

15.99

255.84

10/5/2026

Central

Morgan

Binder

28

8.99

251.72

10/22/2026

East

Jones

Pen

64

8.99

575.36

11/8/2026

East

Parent

Pen

15

19.99

299.85

11/25/2026

Central

Kivell

Pen Set

96

4.99

479.04

12/12/2026

Central

Smith

Pencil

67

1.29

86.43

12/29/2026

East

Parent

Pen Set

74

15.99

1183.26

1/15/2027

Central

Gill

Binder

46

8.99

413.54

2/1/2027

Central

Smith

Binder

87

15.00

1305.00

2/18/2027

East

Jones

Binder

4

4.99

19.96

3/7/2027

West

Sorvino

Binder

7

19.99

139.93

3/24/2027

Central

Jardine

Pen Set

50

4.99

249.50

4/10/2027

Central

Andrews

Pencil

66

1.99

131.34

4/27/2027

East

Howard

Pen

96

4.99

479.04

5/14/2027

Central

Gill

Pencil

53

1.29

68.37

5/31/2027

Central

Gill

Binder

80

8.99

719.20

6/17/2027

Central

Kivell

Desk

5

125.00

625.00

7/4/2027

East

Jones

Pen Set

62

4.99

309.38

7/21/2027

Central

Morgan

Pen Set

55

12.49

686.95

8/7/2027

Central

Kivell

Pen Set

42

23.95

1005.90

8/24/2027

West

Sorvino

Desk

3

275.00

825.00

9/10/2027

Central

Gill

Pencil

7

1.29

9.03

9/27/2027

West

Sorvino

Pen

76

1.99

151.24

10/14/2027

West

Thompson

Binder

57

19.99

1139.43

10/31/2027

Central

Andrews

Pencil

14

1.29

18.06

11/17/2027

Central

Jardine

Binder

11

4.99

54.89

12/4/2027

Central

Jardine

Binder

94

19.99

1879.06

12/21/2027

Central

Andrews

Binder

28

4.99

139.72

3.3) Change the Dates (Optional)

After you get the sample data into your Excel file, you can make a quick change to the order dates, with the easy trick that I show in this video.

Enter your new starting date in the first row of data, then fill down the rest of the column with this shortcut!

4) Get More Sample Data Files

There are many more Excel files with sample data that you can download! Go to any of the pages listed below, and get more data sets for Excel practice.

food sales data

Food Sales - This sample Excel file has food sales data, from a fictional food company. For details on this data, and to download the zipped Excel file, go to the Food Sales Sample Data page.

athlete data

Athlete Data - These sample Excel files have data for football players, and winter games athletes. For details on this data, and to download the zipped Excel file, go to the Athletes Sample Data page.

hockey player data

Hockey Player Data - This sample file has data from the 2018 Olympic Hockey teams, from Canada and the USA. For details on this data, and to download the sample file, go to the hockey player data analysis page.

Workplace Safety data

Workplace Safety Data: This sample file has data for workplace safety incidents. For details on this data, and to download the zipped Excel file, go to the Workplace Safety Sample Data page.

work orders data

Work Orders Data: This sample file has data for service department work orders. For details on this data, and to download the zipped Excel file, go to the Work Orders Sample Data page.

Insurance Policies data

Insurance Policies: This sample file has commercial insurance policy data for a fictional insurance company. For details on this data, and to download the zipped Excel file, go to the Insurance Policy Sample Data page.

Food Nutrients data

Food Nutrients: This sample file has food nutrient data for about 1000 food items. For details on this data, and to download the zipped Excel file, go to the Food Nutrients Sample Data page.

5) Where To Go Next

Find new ideas for your Excel practice sessions, or for training topics.

excel tables

Excel Tables: Use named Excel tables for your data, so it's easier to sort and filter the data. There are written steps and a video on the Creating an Excel Table page.

Excel shortcuts

Shortcuts -- Save time in Excel with data entry tips and shortcuts. Details on the Excel Data Entry Tips page.

create a pivot table

Pivot Tables: See how to plan, get ideas, and build what you need, on the Pivot Table Setup page.

excel pie chart

Pie Charts: Build a pie chart in Excel, and avoid problems, on the Pie Chart Examples page.

 

Get Monthly Excel Tips!

Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up.

Next, when you get my reply, click the Confirm button. I add this step to protect you from spam!

6) Down the Rabbit Hole 🐰

In this section, you'll find related Excel tips, shortcuts, skills, and details. These things are nice to know, but not essential, so you can skip this section, and get back to work. Or dive in, for some extra Excel fun and knowledge!

--1) Why Use Sample Data in Excel?

--2) Tip: Create an Excel Table

--3) Create Your Own Test Data

6.1) Why Use Sample Data in Excel?

Here are a few of the reasons that people have shared with me, as to why they like using these datasets, with dummy data for Excel:

  • Quick way to get interesting data for Excel training class exercises
  • No privacy concerns about using real data from your employer or your client's company
  • Useful for testing macros and manual processes - you might discover problems that didn't occur with original test data
  • Handy data to share when helping with Excel forum questions.
    • Send people to this page, so they can download the sample data, and recreate their problem or error there.
    • It's easier to help with troubleshooting when you both have the same data
  • Easy to prepare class demos for sum and count formulas, lookup functions, pivot tables, summary reports, and other Excel skills training

6.2) Tip: 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.

6.3) Create Your Own Test Data

If you need to create sample test data in Excel, the RANDBETWEEN function can help you get the job done quickly.

This video shows how to use the RANDBETWEEN function to quickly create test data with month headings, customer numbers, and random numbers. You'll also see how change the formulas to static values.

There are written steps on the Excel RAND and RANDBETWEEN Functions page.

 

Excel sample data for practice sort filter pivot and more

Last updated: June 9, 2026 11:35 AM