Sample .xls and xlsx download | File Examples Download

sample excel file download

Download free, customizable Excel spreadsheet templates for budget you'll find a variety of free, easy-to-use Excel templates in a familiar spreadsheet format. 3, Excel (xlsx) Sample Worksheet. 4, Created with Microsoft Excel SP1, If you can see this page then you can open Excel files from Blackboard. Download Sample XLS. Have you ever wondered how a Microsoft Excel file would look on your Smartphone within an app while going for www.cronistalascolonias.com.ar file import?

Sample excel file download - can

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/	East	Jones	Pencil	95
1/23/	Central	Kivell	Binder	50
2/9/	Central	Jardine	Pencil	36
2/26/	Central	Gill	Pen	27
3/15/	West	Sorvino	Pencil	56
4/1/	East	Jones	Binder	60
4/18/	Central	Andrews	Pencil	75
5/5/	Central	Jardine	Pencil	90
5/22/	West	Thompson	Pencil	32
6/8/	East	Jones	Binder	60
6/25/	Central	Morgan	Pencil	90
7/12/	East	Howard	Binder	29
7/29/	East	Parent	Binder	81		1,
8/15/	East	Jones	Pencil	35
9/1/	Central	Smith	Desk	2
9/18/	East	Jones	Pen Set	16
10/5/	Central	Morgan	Binder	28
10/22/	East	Jones	Pen	64
11/8/	East	Parent	Pen	15
11/25/	Central	Kivell	Pen Set	96
12/12/	Central	Smith	Pencil	67
12/29/	East	Parent	Pen Set	74		1,
1/15/	Central	Gill	Binder	46
2/1/	Central	Smith	Binder	87		1,
2/18/	East	Jones	Binder	4
3/7/	West	Sorvino	Binder	7
3/24/	Central	Jardine	Pen Set	50
4/10/	Central	Andrews	Pencil	66
4/27/	East	Howard	Pen	96
5/14/	Central	Gill	Pencil	53
5/31/	Central	Gill	Binder	80
6/17/	Central	Kivell	Desk	5
7/4/	East	Jones	Pen Set	62
7/21/	Central	Morgan	Pen Set	55
8/7/	Central	Kivell	Pen Set	42		1,
8/24/	West	Sorvino	Desk	3
9/10/	Central	Gill	Pencil	7
9/27/	West	Sorvino	Pen	76
10/14/	West	Thompson	Binder	57		1,
10/31/	Central	Andrews	Pencil	14
11/17/	Central	Jardine	Binder	11
12/4/	Central	Jardine	Binder	94		1,
12/21/	Central	Andrews	Binder	28

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 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.

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 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 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 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.

Hockey Players

This sample file has data from the 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.

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.

_____________________

Last updated: November 24, PM

Источник: www.cronistalascolonias.com.ar

Sample excel file download