Sample data for Excel practice
Ready-made .xlsx and .csv files with typed numbers and dates, plus formula questions with answers you can check. Updated 3 November 2026.
Start here
Every dataset here downloads as an .xlsx workbook (numbers stored as numbers, dates as real dates) and as CSV. Start with the sales orders for PivotTables, the employee and invoice tables for SUMIFS, COUNTIFS and AVERAGEIFS, and the messy customer list for cleaning.
Use the .xlsx files: numbers are stored as numbers and dates as real Excel dates, so SUMIFS, PivotTables and date grouping work straight away. The .csv files open in Excel too.
Datasets for Excel
| Dataset | What it is | Max rows |
|---|---|---|
| Sample sales data | Superstore-style retail orders with sales, cost, discount and profit. | 10,000 |
| Sample employee data | An HR table: departments, titles, hire dates, salaries and managers. | 10,000 |
| Sample customer data | A customer list with segments, order counts, lifetime spend and activity. | 10,000 |
| Messy data for cleaning practice | A customer list with duplicates, blanks, mixed dates and text in number columns. | 10,000 |
| Sample inventory data | Stock levels, reorder points and stock value across four warehouses. | 10,000 |
| Sample website traffic data | Daily sessions, users, bounce rate and conversions by channel. | 10,000 |
| Sample marketing campaign data | Budget, spend, impressions, clicks, CPA and ROAS per campaign. | 10,000 |
| Sample student data | Test scores, averages, letter grades and attendance for grades 9-12. | 10,000 |
| Sample call center data | Calls with queue, reason, wait and handle time, resolution and CSAT. | 10,000 |
| Sample restaurant sales data | Order lines with menu items, tickets, order type and payment. | 10,000 |
| Sample invoice data | Invoices with due dates, payment dates, tax, status and days late. | 10,000 |
| Sample bank transaction data | One fictional account: debits, credits, categories and a running balance. | 10,000 |
| Earthquake data (USGS) | Every magnitude 2.5+ earthquake worldwide in a 30-day window, from USGS. | 2,013 |
| U.S. state population data | Census Bureau population estimates for every state and DC, 2020-2024. | 51 |
| World population by country | World Bank population for 217 countries and economies, 2000-2023. | 5,208 |
| GDP by country | World Bank GDP in current U.S. dollars for 217 countries and economies, 2000-2023. | 5,208 |
| Daily weather data, 2024 | Daily temperature, rain and wind for 10 cities through 2024 (Open-Meteo). | 3,660 |
Exercises
Excel PivotTable practice
Build PivotTables from 1,000 order lines and check your totals against ours.
exerciseExcel formula practice
Conditional sums, counts, averages and lookups on real-looking business tables, with the formulas.
exerciseData cleaning practice dataset
Find and fix duplicates, blanks, mixed date formats and text in number columns.