Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (2024)

Sample data in Excel refers to datasets used for practice purposes. While learning various Excel features and functions, or performing data analysis in Excel, users often need a sample dataset.

In this Excel tutorial, you will find 13 ideal Excel sample data. These sample datasets will cover a wide variety of areas such as sales, finance, management, sports, movies, etc. so that you can get your preferred type of data.

A set of sample data in Excel consists of multiple rows and columns. Each row represents a single observation and each column depicts a single variable. The sample data can be in xlsx or csv file format and users can download the files to get the dataset. Users can also use various Excel functions and features to load data from online sources and create their own datasets.

With meaningful sample data in Excel, users can perform various testing, learning, development, and data analysis tasks.

Here are 13 ideal sets of sample data in Excel:

Project Management Sample Data

A project management sample data is suitable for various types of data filtering, analyzing, and visualizing. Here are the variables that we have included in the sample data:

  • Project Name
  • Task Name
  • Assigned to
  • Start Date
  • Days Required
  • End Date
  • Progress

Here is a preview of the project management dataset:

Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (1)

Download Sample Workbook

Project Management Sample Data.xlsx

Inventory Records Sample Data in Excel

Inventory management records consist of product and stock information. In our sample dataset, we have included the following fields:

  • Product ID
  • Product Name
  • Opening Stock
  • Purchase/Stock-in
  • Number of Units Sold
  • Hand-in-stock
  • Cost Price Per Unit
  • Cost Price Total

Here is a preview of the inventory records sample data:

Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (2)

Download Sample Workbook

Inventory Records Sample Data.xlsx

Call Center Customer Satisfaction Data

Call centers deal with customer service and receive various types of feedback from customers. In our Call Center Customer Satisfaction data, we have included the following fields:

  • ID
  • Customer Name
  • Sentiment
  • CSAT Score
  • Call Timestamp
  • Reason
  • City
  • State
  • Channel
  • Response Time
  • Call Duration
  • Call Center

Here is a preview of our sample data:

Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (3)

Download Sample Workbook

Supermarket Sales Sample Data in Excel

Supermarket sales sample data is a popular dataset for learning and practicing your Excel skills. Here is the list of variables we have included in our supermarket sales sample data:

  • Order No.
  • Order Date
  • Customer Name
  • Ship Date
  • Retail Price
  • Order Quantity
  • Tax
  • Total

Here is a preview of the sample supermarket sales data in Excel:

Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (4)

Download Practice Workbook

Supermarket Sales Sample Data.xlsx

Employee Management Data

Employee management data contains information on all employees in an organization. In our sample employee management data in Excel, we have listed the following variables:

  • Employee ID
  • Full Name
  • Department
  • Designation
  • Hire Date
  • Annual Salary

Here is a preview of the employee management data:

Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (5)

Download Sample Workbook

Employee Management Sample Data.xlsx

Technological Product Sample Data

Any technological product information requires various specifications. In our sample dataset, we have listed the following specifications:

  • Brand
  • Device
  • Model
  • Country of Origin
  • Release Date
  • Price

The following image shows a preview of our sample technological product dataset:

Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (6)

Download Sample Workbook

Technological Products Sample Data.xlsx

Engineering and Manufacturing Sample Data

Engineered or manufactured products also require various specifications. Here is the list of variables we have included in our sample engineering and manufacturing sample data:

  • Product ID
  • Name
  • Category
  • Manufacturer
  • Price
  • Stock Quantity

Here is a preview of the sample dataset:

Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (7)

Download Sample Workbook

Engineering and Manufacturing Sample Data.xlsx

Students Marksheet Sample Data in Excel

A student mark sheet contains the student identifiers and marks in various subjects. In our sample students marksheet dataset, we have listed the following variables:

  • ID
  • Name
  • Marks in Mathematics
  • Marks in Physics
  • Marks in Chemistry
  • Percentage

Here is a preview of the sample student marksheet dataset:

Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (8)

Download Sample Workbook

Students Marksheet Sample Data.xlsx

2022 FIFA World Cup Performance Data

In our sample dataset, we have listed the information of each player from the World Cup-winning Argentina team. Here is the list of variables we have included:

  • Player Name
  • Position
  • Jersey Number
  • Player DOB
  • Club
  • Appearances
  • Goals Scored
  • Assists Provided
  • Dribbles per 90 Min
  • Interceptions per 90 Min
  • Tackles per 90 Min
  • Total Duels Won per 90 Min

You can preview the sample dataset in the following image:

Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (9)

Download Sample Workbook

2022 FIFA World Cup Performance Sample Data.xlsx

Tokyo Olympic Data

This sample dataset contains the team names, number of Gold, Silver, Bronze, and total medals, and ranking of teams (based on gold medal and total medal count) in the Tokyo Olympics. Here is a preview of the sample dataset:

Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (10)

Download Sample Workbook

Tokyo Olympic Sample Data.xlsx

Healthcare Insurance Sample Data in Excel

The price of healthcare insurance depends on various factors such as current age, BMI, smoking habits, etc. In our sample healthcare insurance dataset, we have listed the following variables:

  • Name
  • Age
  • Gender
  • BMI
  • Children
  • Smoking Status
  • Location
  • Insurance Price

You can preview the sample dataset in the following image:

Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (11)

Download Sample Workbook

Healthcare Insurance Sample Data.xlsx

Travel Destination Distance Data in Excel

While deciding on a travel destination, we need to take the distance, available travel modes, travel duration, etc. factors into consideration. In our sample travel destination dataset, we have listed the following variables:

  • Source City
  • Source Latitude
  • Source Longitude
  • Destination City
  • Destination Latitude
  • Destination Longitude
  • Distance (in km)
  • Distance (in mile)
  • Travel Mode
  • Duration

Here is a preview of the sample dataset:

Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (12)

Download Sample Workbook

Travel Destination Distance Sample Data.xlsx

Netflix Movies Sample Data

The movie dataset provided in this section contains the following variables:

  • Movie Name
  • Year
  • Age Rating
  • Duration
  • Category
  • IMDb Rating

You can preview the dataset in the image below:

Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (13)

Download Practice Workbook

Netflix Movies Sample Data.xlsx

This ends our article on Excel sample data. We provided 13 ideal sample data that you can download as an xlsx file. After downloading the workbook, you can use the dataset directly in that workbook. You can also copy or import the sample data to your target workbook using Excel functions and features. We hope that the provided datasets were helpful to you. If you have any feedback or queries on this article, feel free to share them in the comment section.

Excel Sample Data: Knowledge Hub

  • GST State Code List in Excel
  • Historical Data of NSE Stocks in Excel

<< Go Back to Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Excel Sample Data (Free Download 13 Sample Datasets) - ExcelDemy (2024)

FAQs

Where can I find free Excel data sets? ›

A few free government datasets we recommend:
  • Data.gov.
  • USA.gov Data and Statistics.
  • Federal Reserve Data.
  • U.S. Bureau of Labor Statistics.
  • California Open Data Portal.
  • New York Open Data.
  • NOAA Data Access (mostly via API)
  • NASA Open Data Portal.

How to get Excel sample data? ›

To tell Excel that you want to sample data from a data set, first click the Data tab's Data Analysis command button. When Excel displays the Data Analysis dialog box, select Sampling from the list and then click OK. Excel displays the Sampling dialog box. Identify the input range.

What is the format of dataset in Excel? ›

Excel datasets are collections of data that are stored and organized in an Excel spreadsheet, which is a commonly used software that enables users to create, manipulate and analyze data in a structured format. These datasets can come in two main formats: Excel(.xlsx) and Comma Separated Values (CSV).

What is a data set in Excel? ›

Data sets are configurable objects that store your data (think of them as Excel worksheets, or database tables, or tabular lists). You can give each data set a name, define its columns, set user permissions, and import data.

How to download free datasets? ›

10 Great Places to Find Free Datasets for Your Next Project
  1. Google Dataset Search. Type of data: Miscellaneous. ...
  2. Kaggle. Type of data: Miscellaneous. ...
  3. Data.Gov. Type of data: Government. ...
  4. Datahub.io. ...
  5. UCI Machine Learning Repository. ...
  6. Earth Data. ...
  7. CERN Open Data Portal. ...
  8. Global Health Observatory Data Repository.
Nov 9, 2023

Is Excel no longer free? ›

All you need is to sign up for a Microsoft account with a new or existing email address. Use Word, Excel, PowerPoint and more for free on the web. Tip: If you're a small business owner looking for more information on how to get Microsoft 365 set up, visit Small business help & learning.

Where can I get Excel data for practice? ›

Use sample datasets: Just search "sample datasets for excel" on google, you'll get numerous websites which serves various datasets for practice. You have to visit one of them sites and then download the samples. You'll get the samples for excel practice.

Where can I download data from Excel? ›

Select File > Save As > Download a Copy. If Excel asks whether to open or save the workbook, select Save.

Where can I find data source in Excel? ›

In Excel Select Data > Get Data > Data Source Settings.

What is the difference between Excel and Excel data format? ›

Unlike Microsoft Excel format, Microsoft Excel - Data only format does not merge cells, each object is added to only one cell. This format can also export certain kinds of summaries in Crystal Reports as Excel functions. The summaries that are supported are SUM, AVERAGE, COUNT, MIN and MAX.

How do I open a dataset in Excel? ›

Import Data
  1. Click the Data tab on the Ribbon..
  2. Click the Get Data button. Some data sources may require special security access, and the connection process can often be very complex. ...
  3. Select From File.
  4. Select From Text/CSV. ...
  5. Select the file you want to import.
  6. Click Import. ...
  7. Verify the preview looks correct. ...
  8. Click Load.

How do I convert Excel to dataset? ›

3: Export to SQL Server
  1. Open up SQL Server Management Studio (SSMS) and connect to a Database Engine. ...
  2. Right click on a Database and under Tasks, select "Import Data". ...
  3. Click on "Next", and select "Microsoft Excel" from the dropdown menu of Data sources.
  4. Click on the "Next" button and if it works for you, congrats!

What is a dataset example? ›

A data set is a collection of numbers or values that relate to a particular subject. For example, the test scores of each student in a particular class is a data set. The number of fish eaten by each dolphin at an aquarium is a data set.

How to create a dataset in Excel? ›

Select the file. If the Excel file contains multiple sheets or tables, select the appropriate Sheet Name and Table Name for this dataset, as shown below. If you added parameters for this dataset, click Add Parameter. Enter the Name and select the Value.

Where can I get a free Excel spreadsheet? ›

Free Excel for the web templates
  • Go to Create.Microsoft.com.
  • Click Templates at the top of the page.
  • On the Templates page, click Excel. ...
  • Click the template you want, click Edit in Browser, sign in if prompted, and then click Continue.

Where can I get MS Excel for free? ›

How to get Microsoft 365 for free if you're not a student or faculty member
  • Go to Microsoft365.com.
  • Click Sign up for the free version of Office under the "Sign in" button.
  • Log in to your Microsoft account or create one for free. ...
  • Select the app you want to use and save your work in the cloud with OneDrive.
May 30, 2024

How do I find a set of data in Excel? ›

Press Ctrl+F or go to Home > Find & Select > Find. In Find what type the text or numbers you want to find. Select Find All to run your search for all occurrences. Note: The dialog box expands to show a list of all the cells that contain the search term, and the total number of cells in which it appears.

Top Articles
Latest Posts
Article information

Author: Corie Satterfield

Last Updated:

Views: 5468

Rating: 4.1 / 5 (42 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Corie Satterfield

Birthday: 1992-08-19

Address: 850 Benjamin Bridge, Dickinsonchester, CO 68572-0542

Phone: +26813599986666

Job: Sales Manager

Hobby: Table tennis, Soapmaking, Flower arranging, amateur radio, Rock climbing, scrapbook, Horseback riding

Introduction: My name is Corie Satterfield, I am a fancy, perfect, spotless, quaint, fantastic, funny, lucky person who loves writing and wants to share my knowledge and understanding with you.