Free Example Data Sets For Spreadsheets [Instant Download]
Spreadsheet Sample Data in Excel & CSV Formats
I have put this page together to provide everyone with data that you would come across in the REAL WORLD. Whether you are looking for some Pivot Table practice data or data that you can flow through an Excel dashboard you are building, this article will hopefully provide you with a good starting point.
All the example data is free for you to use any way you’d like. I have saved the data in both an Excel format (.xlsx) and a comma-separated values format (.csv).
What Can This Data Be Useful For?
- Feeding Dashboards
- Manipulating in Power Query
- Feeding into Power BI
- Practicing Excel Formulas (VLOOKUP Practice Data)
- Testing Spreadsheet Solutions
- Example Data for Articles or Videos You Are Making
Which Spreadsheet/BI Programs Can I Use This Data With?
- Power BI
- Tableau
- LibreOffice (OpenOffice)
- Microsoft Excel
- Google Sheets
- Apple Numbers
- Excel’s Power Query
- Tell me in the comments if there are others!
Company Employee Example Data
Folks in Human Resources actually deal with a lot of data. This data can be great for creating dashboards and summarizing various aspects of a company’s workforce. In this database, there are 1,000 rows of data encompassing popular data points that HR professionals deal with on a regular basis.
You can use this data to practice popular spreadsheet features including Pivot Table, Vlookups, Xlookups, Power Query automation, charts, and Dashboards.
Columns in this Data Set:
Below is a list of all the fields of data included in the sample data.
- Employee ID
- Full Name
- Job Title
- Gender
- Ethnicity
- Age
- Hire Date
- Annual Salary (USD)
- Bonus %
- Department
- Business Unit
- Country
- City
- Exit Date
Data Preview (Employee Records)
Download This Sample Data
If you would like to download this data instantly and for free, just click the download button below. The download will be in the form of a zipped file (.zip) and include both a Microsoft Excel (.xlsx) and CSV file version of the raw data.
Sales Force Example Data (Coming Soon!)
Columns in this Data Set:
Below is a list of all the fields of data included in the sample data.
- Employee Name
- Region
- Office
- Prospecting
- Negotiating
- Orders
- YTD Sales
- Commission Rate
- Phone Number
- Leader Name
- Units Sold
- Avg. Price Per Unit
Data Preview (Sales Team Data)
Company Financial Results Example Data
Columns in this Data Set:
Below is a list of all the fields of data included in the sample data.
- Account
- Department
- Business Unit
- Amount
- Month
- Year
- Scenario (Actuals/Forecast/Budget)
- Currency
Data Preview (Financial Data)
Website Traffic Example Data (Coming Soon!)
Columns in this Data Set:
Below is a list of all the fields of data included in the sample data.
- Users
- Bounce Rate
- Keywords
- Avg. SERP
- Avg. Time on Page
- Page URL
- Page Title
- Pageviews
- Sessions
- Social Media Traffic
Data Preview (Web Traffic)
I Hope This Microsoft Excel Article Helped!
Hopefully, you were able to find 1 or more data sets that you can use for your spreadsheet project. If you have any questions about the data I’ve compiled or suggestions on more datasets that would be useful, please let me know in the comments section below.
Learn my best Excel chart design hacks. These will turn your ugly charts into professionally crafted graphics, leaving your boss speechless!!!
Keep Learning
![Which Excel Versions Have XLOOKUP Function? [Solved]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/10/DoIHaveXLOOKUP.png)
Chris Newman
Chris is a finance professional and Excel MVP recognized by Microsoft since 2016. With his expertise, he founded TheSpreadsheetGuru blog to help fellow Excel users, where he shares his vast creative solutions & expertise. In addition, he has developed over 7 widely-used Excel Add-ins that have been embraced by individuals and companies worldwide.