Best Excel Sample Data for Practice: Free Datasets by Domain
Where to find the best Excel sample data for practice
The fastest path to real Excel skill is working with realistic data, not toy examples. Curated collections of industry-specific datasets typically contain hundreds to thousands of rows per file, giving you enough volume to make pivot tables, VLOOKUP, and Power Query feel like second nature rather than a one-time experiment.
The top free sources for downloadable Excel practice data:
- Contextures (contextures.com): Office supply sales data with OrderDate, Region, Rep, Item, Units, UnitCost, and Total columns. Copy-paste ready or downloadable as .xlsx.
- Kaggle (kaggle.com): Thousands of community-uploaded datasets across every industry, many pre-formatted for Excel.
- Data.gov: U.S. government open data covering healthcare, demographics, finance, and more. Authoritative and free.
- GitHub (rohanmistry231 repo): 15 structured Excel datasets including FIFA World Cup, Superstore Sales, Stock Price, and Airbnb data.
- Northwind Traders (available via Wikiversity): A classic relational database sample covering orders, products, customers, and suppliers. Ideal for lookup and join practice.
- TrumpExcel: 15 curated industry datasets, each with 1,000 rows, plus a custom generator that builds files from 1 to 500,000 rows on demand.
Project management and inventory datasets you can use right now
Project management sample data typically includes columns like Project Name, Task Name, Assigned To, Start Date, Days Required, and End Date. That structure is perfect for practicing date arithmetic, conditional formatting to flag overdue tasks, and Gantt-style chart building.
Inventory records datasets go a layer deeper. Expect fields like Product ID, Product Name, Opening Stock, Purchase/Stock-in, Units Sold, Hand-in-Stock, Cost Price Per Unit, and Cost Price Total. Those columns set up natural exercises in:
- VLOOKUP and XLOOKUP to pull supplier details by product ID
- Sorting and filtering by stock level to identify reorder candidates
- Conditional formatting to highlight items below reorder thresholds
- SUMIF to calculate total purchase cost by category
Customer satisfaction, sales, and employee management practice data
Call center customer satisfaction data covers fields like Customer Name, Sentiment, CSAT Score, Call Timestamp, Response Time, Call Duration, and Call Center location. Run a pivot table on Sentiment by Call Center and you immediately see which location needs attention. Add a slicer for date range and you have a working dashboard in under an hour.
Sales datasets are the most versatile category for learners. A standard sales practice file includes OrderDate, Region, SalesRep, Item, Units, UnitCost, and Total. Those seven columns support sorting, filtering, SUMIFS by region, trend charts, and pivot table summaries. Supermarket sales data adds Tax, Ship Date, and Order Quantity for slightly more complex revenue calculations.
Employee management data brings a different challenge. Columns typically span Employee ID, Full Name, Job Title, Gender, Ethnicity, Age, Hire Date, Annual Salary, Bonus %, Department, Business Unit, Country, City, and Exit Date. That breadth makes it ideal for pivot table practice, workforce dashboards, and nested IF formulas that calculate tenure or flag departures.
Technology, engineering, and student marksheet datasets for Excel
Technology product datasets list device specs, pricing, and sales figures across categories like laptops, phones, and accessories. They work well for data validation exercises (restricting entries to valid product categories), conditional formatting by price tier, and COUNTIFS to count products meeting multiple spec criteria simultaneously.
Engineering and manufacturing data covers defect rates, production counts, batch numbers, and process timings. This is where learners practice statistical functions like AVERAGE, STDEV, and MIN/MAX across production runs, plus charting control limits on a line graph.
Student marksheet datasets are underrated for formula practice. A typical file includes Student ID, Name, scores across five or six subjects, attendance percentage, and a calculated grade. Key functions to practice here:
- IF and IFS: assign letter grades based on score ranges
- COUNTIFS: count students who passed all subjects
- AVERAGE and AVERAGEIF: compute class averages by subject or gender
- Conditional formatting: highlight failing scores in red automatically
Sports, healthcare, travel, and entertainment datasets
The 2022 FIFA World Cup dataset covers every player from the Argentina squad, including position, appearances, goals, and assists. The Tokyo Olympics dataset lists team names, Gold, Silver, Bronze, and total medal counts with rankings. Both files are ready-made for sorting exercises, ranking formulas like RANK.EQ, and comparative bar charts.
Healthcare insurance data includes age, BMI, smoking status, region, and claim amounts. It supports regression-style analysis in Excel using CORREL to check whether BMI or smoking status correlates with higher claims. That kind of question forces learners to think analytically, not just mechanically.
Travel destination distance data lists source city, destination city, latitude, longitude, distance in kilometers and miles, and travel mode. Time series and geography exercises both fit here. Netflix Movies data adds film title, genre, release year, rating, and duration, which is a natural fit for dashboard building and trend analysis by genre or decade.
How to get the most out of your practice datasets
Choosing a dataset with at least 1,000 rows matters because smaller files make pivot tables feel trivial and hide the performance differences between formula approaches. Scale is what separates a real learning experience from a demo.
Look for datasets that include a "Problem" sheet and a "Solution" sheet. That structure lets you check your work immediately without hunting for an answer key, which keeps the feedback loop tight and learning efficient.
- Use .xlsx files when you want to practice formulas, named ranges, and multi-sheet work.
- Use .csv files when you want to practice importing, cleaning, and handling raw text data.
- After pasting any data into Excel, convert it to a named Excel table immediately. Structured references and auto-expanding ranges make every formula cleaner.
- Work across multiple domains rather than repeating the same sales dataset. Financial, HR, and healthcare data each force different thinking patterns.
For academic learners building structured data skills, understanding research data categorization can also sharpen how you organize and label your own practice datasets before analysis.
Financial and accounting sample data
Financial results datasets typically include Account, Department, Business Unit, Amount, Month, Year, Scenario (Actuals/Forecast/Budget), and Currency. That Scenario column is the key feature. Filtering between Actuals and Budget lets you practice variance analysis with simple subtraction formulas, then chart the gap over 12 months. U.S. accounting audit sample data adds a compliance angle, with transaction IDs and approval flags that support IF-based exception flagging.
Marketing campaign sample data
Marketing datasets cover campaign name, channel (email, paid search, social), impressions, clicks, conversions, cost, and revenue generated. The click-through rate and cost-per-conversion columns are calculated fields, so learners practice writing formulas from scratch rather than reading pre-filled results. Pivot tables by channel reveal which medium drove the best return, a question every analyst faces in a real job.
Human resources and payroll sample data
HR and payroll data is one of the richest categories for advanced formula work. A full HR file includes the employee fields listed in the employee management section above, plus payroll columns like Gross Pay, Deductions, Net Pay, Pay Period, and Tax Withholding. Nested IFs for tax bracket calculations, SUMIFS for department payroll totals, and date functions for tenure calculations all fit naturally here. Logicexcel's free Excel exercises cover several of these function types interactively if you want guided practice alongside the raw data.
Real estate and property listings data
Property listing datasets include address, city, state, ZIP code, list price, sale price, square footage, bedrooms, bathrooms, days on market, and sale date. Price-per-square-foot is a derived column learners calculate themselves. Sorting by days on market, filtering by city, and building a scatter plot of list price versus sale price are all standard exercises. This data also works well for practicing Excel's built-in geography data type, which can pull in additional location attributes automatically.
Sample datasets that include formulas and functions examples
The most instructive practice files ship with formulas already written in a reference sheet, so you can reverse-engineer the logic. The electronics retail dataset from ExcelDemy, for instance, uses AND, IFERROR, and IFS together to calculate sales commissions, and SUMPRODUCT to find the most profitable weekday. Seeing those combinations in context teaches more than reading a function definition. Microsoft's own PivotTable documentation pairs well with any of these datasets when you are ready to move from raw data to summarized analysis.
*Key Takeaways
The most effective Excel practice datasets combine 1,000+ rows of realistic, domain-specific data with both .xlsx and .csv formats and structured problem-and-solution sheets.
| Point | Details |
| Aim for 1,000+ rows | Smaller files make pivot tables trivial; realistic row counts expose real formula performance differences. |
| Use both file formats | .xlsx preserves formulas and sheets; .csv trains raw data cleaning and import skills. |
| Choose problem-solution files | Datasets with a Solution sheet let you validate your work immediately without an external answer key. |
| Span multiple domains | Rotating across HR, financial, sales, and healthcare data builds transferable, industry-agnostic skills. |
| Test formulas on small copies first | Paste 5–10 rows into a blank sheet, confirm the formula works, then apply it to the full dataset. |
FAQ
What is the best free source for Excel sample data?
Contextures, TrumpExcel, and Kaggle are the top free sources. TrumpExcel offers 15 curated datasets each with a substantial number of rows, plus a custom generator that builds files to suit various size needs.
How many rows should a good practice dataset have?
Experts recommend at least 1,000 rows so that features like pivot tables, Power Query, and sorting feel realistic rather than trivial.
Should I use .xlsx or .csv files for practice?
Use .xlsx when practicing formulas, named ranges, and multi-sheet work. Use .csv when practicing data import, cleaning, and handling raw text.
Where can I practice Excel functions interactively alongside sample data?
Logicexcel offers 84 free interactive exercises covering functions, pivot tables, and dashboards, with instant feedback and no account required.
What Excel functions do practice datasets help you learn?
Standard datasets support VLOOKUP, XLOOKUP, SUMIFS, COUNTIFS, IF, IFS, IFERROR, AND, SUMPRODUCT, and pivot table creation, depending on the domain and column structure.