|
Home > Data > Sample > Sample Data Excel Sample Data Food Sales
|

This Excel file has sample sales data, from a fictional food company.
Click here to get the food sample sales data Excel file.

Each row in the food sales data has the following 8 fields, for manual data entry:
The screen shot below shows the first 6 columns in the Food Sales dataset table.

Each row in the food sales data also has one column with a formula calculation:
The screen shot below shows the last 3 columns in the Food Sales dataset table. In cell I2, the following formula multiplies the number in the Qty column by the number in the UnitPrice column:
Tip: I've added grey fill colour, and an orange heading cell, to column I, to show that it's different from the other columns, that are for manual entries.

You can use this food sales data as is, or make changes to the data, to customize it for your training sessions. For example:
See the video in the next section, for examples of using the Excel Find and Replace feature, to quickly modify existing data.
In this video, you'll see how to use the Excel Find and Replace commands, to clean up names in a contact list. For written steps, and the sample file, go to the Find and Replace page.
Video Timeline
In addition to the food sales data file, there is a second sample file that you can download. The second file has the same food sales data, along with the following types of data analysis examples:
Click here to get the food sales data Excel file, with pivot tables and pivot charts, analyzing the data.
In the data analysis sample file, there is a sheet named Totals, with summary formula examples.
To get the total quantities for each region, for each category, I entered this formula in cell C5:
The formula calculates a total:
The formula from cell C5 was copied down to row 8, and across to column D.

In Excel , you cn use the SUMIFS function to calculate a total for rows that meet two or more criteria. Watch this short video to see the steps, and there are written instructions on the Excel Sum Functions page.
In the data analysis sample file, there are two sheets where I've added pivot tables and pivot charts.
On the sheet named CatReg, there's a pivot table with 3 fields:

On the sheet named RegPct, there's a small pivot table with 2 fields:
Instead of showing the quantity numbers, I set that field to:
Tip: See more examples of using the Show Values Of setting options in a pivot table.

Watch this video, to see the steps for creating a pivot table in Excel 2013 and later. There are detailed steps on the Create a Pivot Table in Excel page.
In the data analysis sample file, there are two sheets where I've added pivot tables and pivot charts.
On the CatReg sheet, there's a pivot chart based on the pivot table from that sheet.
I used the 2-D Stacked Bar chart type, and it has three fields:
Tip: There is another Pivot Chart example, and detailed steps, on the Pivot Chart Compare Years page

On the RegPct sheet, there's a pivot chart based on the pivot table from that sheet.
I used the 2-D Pie chart type, and it has two fields:
Tip: There are formatting tips for this type of chart on the Excel Pie Chart page.

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.
![]() |
Office Supply Sales - This sample Excel file has office supply sales data, from a fictional stationery company. For details on this data, and to download the zipped Excel file, go to the Excel Sample Data for Practice page. |
![]() |
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 - 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: 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: 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: 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: 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. |
Be sure to get my monthly newsletter, with quick Excel tips, links, news, and a bit of fun. Just add your email, then click Sign Up.
Here are a few of my Contextures tutorials on working with data in Excel, organizing it in tables, and summarizing the data in pivot tables.
-- Excel Tables
-- Pivot Tables
Last updated: May 5, 2025 9:24 AM