Last updated: May 14, 2013 10:16 AM
Search Contextures Sites ![]()
Excel Sample Data
Below is a table with the Excel sample data used for many of my newsgroup and web site examples.
It's sales data for an imaginary stationery company, and shows when the order was placed, which region the sale was made in, the sales representative, the item sold and the number of units sold. It also shows the cost of a single unit, and calculates the total cost of the order.
You can select the Excel sample data in the table below, and copy it for use in your own tests. Or download the sample data in an Excel file, by clicking the link below. If you need a larger set of sample data, check out JP's Random Data Generator
Download the zipped Excel sample data workbook
For an interactive view of the data, click the button below. You can filter, sort, and download the data from the interactive view.
NOTE: The button works in Firefox and Chrome, but might not appear in Internet Explorer.
<===Click this button to open the Interactive View
OrderDateRegion Rep Item Units Cost Total 1/6/2012East Jones Pencil 95 1.99 189.05 1/23/2012Central Kivell Binder 50 19.99 999.50 2/9/2012Central Jardine Pencil 36 4.99 179.64 2/26/2012Central Gill Pen 27 19.99 539.73 3/15/2012West Sorvino Pencil 56 2.99 167.44 4/1/2012East Jones Binder 60 4.99 299.40 4/18/2012Central Andrews Pencil 75 1.99 149.25 5/5/2012Central Jardine Pencil 90 4.99 449.10 5/22/2012West Thompson Pencil 32 1.99 63.68 6/8/2012East Jones Binder 60 8.99 539.40 6/25/2012Central Morgan Pencil 90 4.99 449.10 7/12/2012East Howard Binder 29 1.99 57.71 7/29/2012East Parent Binder 81 19.99 1,619.19 8/15/2012East Jones Pencil 35 4.99 174.65 9/1/2012Central Smith Desk 2 125.00 250.00 9/18/2012East Jones Pen Set 16 15.99 255.84 10/5/2012Central Morgan Binder 28 8.99 251.72 10/22/2012East Jones Pen 64 8.99 575.36 11/8/2012East Parent Pen 15 19.99 299.85 11/25/2012Central Kivell Pen Set 96 4.99 479.04 12/12/2012Central Smith Pencil 67 1.29 86.43 12/29/2012East Parent Pen Set 74 15.99 1,183.26 1/15/2013Central Gill Binder 46 8.99 413.54 2/1/2013Central Smith Binder 87 15.00 1,305.00 2/18/2013East Jones Binder 4 4.99 19.96 3/7/2013West Sorvino Binder 7 19.99 139.93 3/24/2013Central Jardine Pen Set 50 4.99 249.50 4/10/2013Central Andrews Pencil 66 1.99 131.34 4/27/2013East Howard Pen 96 4.99 479.04 5/14/2013Central Gill Pencil 53 1.29 68.37 5/31/2013Central Gill Binder 80 8.99 719.20 6/17/2013Central Kivell Desk 5 125.00 625.00 7/4/2013East Jones Pen Set 62 4.99 309.38 7/21/2013Central Morgan Pen Set 55 12.49 686.95 8/7/2013Central Kivell Pen Set 42 23.95 1,005.90 8/24/2013West Sorvino Desk 3 275.00 825.00 9/10/2013Central Gill Pencil 7 1.29 9.03 9/27/2013West Sorvino Pen 76 1.99 151.24 10/14/2013West Thompson Binder 57 19.99 1,139.43 10/31/2013Central Andrews Pencil 14 1.29 18.06 11/17/2013Central Jardine Binder 11 4.99 54.89 12/4/2013Central Jardine Binder 94 19.99 1,879.06 12/21/2013Central Andrews Binder 28 4.99 139.72JP's Random Data Generator - Excel 2007
Contextures Inc., Copyright ©2013
All rights reserved.