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, work orders, and hockey player data.
Microsoft Excel, spreadsheet application launched in 1985 by the Microsoft Corporation. Excel is a popular spreadsheet system, which organizes data in columns and rows that can be manipulated through formulas that allow the software to perform mathematical functions on the data. Screenshot of Microsoft Excel. © 2010 Microsoft Corporation. Microsoft Excel offers users hundreds of different functions and formulas for a variety of purposes. Whether you have to analyze your personal finance or any large data set, it's the functions.
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:
- Copy and paste the data from the table below.
- Or, go to the Download section below, to get the Excel file
- Or, go to the More Sample Data Files section below
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.
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.
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.
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.
Click here to download the work orders data file. The zipped Excel file is in xlsx format, and does not contain any macros.
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.
Ms Excel 2010 Download
Related Links
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.
_____________________
How Excel Works
An Excel document is called a Workbook. A workbook always has at least one Worksheet. Workseets are the grid where you can store and calculate data. You can have many worksheets stored inside a workbook, each with a unique worksheet name.Worksheets are laid out in columns (vertical) and rows (horizontal). The intersection of any given row and column is a cell. Cells are really where you enter any information. A cell will accept a large amount of text, or you can enter a date, number, or formula. Each cell can be formatted individually with distinct border, background color, and font color/size/type.