Free Excel files to practice on
Real data to practice formulas and pivot tables on, and a budget template you can use right away. You can preview the sheets here. The files are free with an account.
Excel budget template
A ready-made budget in Excel: monthly bills, bills paid quarterly or yearly, spending by category, a running balance and your savings goals.
4 sheets
- Budget: Income and expenses per month and per year. Quarterly, twice-a-year and yearly bills are turned into a monthly amount.
- Spending: What you buy, with a date and a category. SUMIF shows how much of the budget is left in each category.
- Balance: Money in and out with a running balance: the balance above plus what came in, minus what went out.
- Savings: Your savings goals, what is still needed and how many months are left, rounded up with ROUNDUP.
| Item | Amount | Paid | Per month | Per year | Share of income |
|---|---|---|---|---|---|
| Income after tax | 5,200 | Monthly | formula | formula | |
| Rent | 1,650 | Monthly | formula | formula | formula |
| Electricity and gas | 140 | Monthly | formula | formula | formula |
| Water | 180 | Quarterly | formula | formula | formula |
Customer data for Excel practice
150 customers with name, email, city, segment, signup date, orders and total spent. For COUNTIFS, XLOOKUP, text functions and dates.
1 sheets
- Customers: 150 customers with ID, name, email, city, segment, signup date, orders, total spent and newsletter.
| Customer ID | First name | Last name | City | Segment | Signup date | Orders | Total spent | Newsletter | |
|---|---|---|---|---|---|---|---|---|---|
| 2,001 | Noah | Davis | [email protected] | Austin | Private | 45,784 | 1 | 1,275 | Yes |
| 2,002 | Tyler | Smith | [email protected] | Chicago | Private | 45,882 | 9 | 2,395 | No |
| 2,003 | Mia | King | [email protected] | Chicago | Business | 44,249 | 21 | 86,231 | No |
| 2,004 | Mason | Smith | [email protected] | Denver | Private | 44,745 | 4 | 5,075 | Yes |
Employee data for Excel practice
60 employees with department, title, start date, salary, city and full-time status. For COUNTIFS, AVERAGEIF, lookups and dates.
1 sheets
- Employees: 60 employees with ID, name, department, title, start date, annual salary, city and full-time status.
| Employee ID | First name | Last name | Department | Title | Start date | Annual salary | City | Full-time |
|---|---|---|---|---|---|---|---|---|
| 1,001 | Robert | Williams | IT | Developer | 42,887 | 50,500 | Austin | Yes |
| 1,002 | Sarah | Johnson | Warehouse | Warehouse worker | 41,153 | 42,500 | Chicago | Yes |
| 1,003 | Brian | Brown | Sales | Sales rep | 45,352 | 48,000 | Denver | Yes |
| 1,004 | Megan | Jones | Warehouse | Warehouse worker | 44,348 | 38,500 | Chicago | No |
Inventory data for Excel practice
80 products with SKU, category, supplier, stock, reorder point, cost and price. For XLOOKUP, SUMPRODUCT, COUNTIFS and stock value.
1 sheets
- Inventory: 80 products with SKU, category, supplier, units in stock, reorder point, unit cost, sale price and last delivery.
| SKU | Product | Category | Supplier | In stock | Reorder point | Unit cost | Sale price | Last received |
|---|---|---|---|---|---|---|---|---|
| SKU-1001 | Notebook A5, squared | Paper | PaperWorks | 236 | 20 | 24 | 40 | 45,897 |
| SKU-1002 | Coat stand | Furniture | Nordic Supply | 14 | 7 | 410 | 690 | 45,818 |
| SKU-1003 | Copy paper A4, 500 sheets | Paper | PaperWorks | 38 | 40 | 32 | 60 | 45,768 |
| SKU-1004 | Paper cups, 100 | Kitchen | CleanCo | 180 | 25 | 42 | 75 | 45,785 |
Messy data for Excel cleanup practice
60 orders with extra spaces, wrong case, numbers and dates stored as text, mixed phone formats and duplicates. For TRIM, PROPER, VALUE and SUBSTITUTE.
1 sheets
- Orders: 60 exported orders with order number, customer, city, date, amount, phone and status, mess included.
| Order no. | Customer | City | Order date | Amount | Phone | Status |
|---|---|---|---|---|---|---|
| 5,001 | amy ross | AUSTIN | 2025-01-20 | 2,150 | 705 555 4852 | Unpaid |
| 5,002 | TOM FISHER | Seattle | 2025-02-26 | 2,050 | 574 555 6356 | Paid |
| 5,003 | Jack Gray | Austin | 2025-04-03 | 1,325 | 4305554942 | Paid |
| 5,004 | Mark Evans | DENVER | 2025-03-11 | 825 | 8925559900 | Unpaid |
Sales data for Excel practice
240 orders from one year with date, region, salesperson, product, category, units and revenue. For SUMIFS, lookups, dates and pivot tables.
1 sheets
- Sales: 240 orders from 2025 with date, region, salesperson, product, category, units, unit price and revenue.
| Order ID | Date | Region | Salesperson | Product | Category | Units | Unit price | Revenue |
|---|---|---|---|---|---|---|---|---|
| 1,001 | 45,658 | West | Lucas Ward | Monitor | Electronics | 15 | 1,400 | 21,000 |
| 1,002 | 45,658 | North | Emma Carter | Keyboard | Electronics | 7 | 350 | 2,450 |
| 1,003 | 45,658 | North | Emma Carter | Keyboard | Electronics | 4 | 350 | 1,400 |
| 1,004 | 45,659 | South | Noah Price | Office chair | Furniture | 10 | 1,800 | 18,000 |
Finance data for Excel practice
A year of bank transactions for a small firm: 188 entries with date, voucher, description, category and amount. For SUMIF, SUMIFS and percentages.
1 sheets
- Transactions: 188 bank transactions from 2025 with date, voucher number, description, category and amount.
| Date | Voucher | Description | Category | Amount |
|---|---|---|---|---|
| 45,658 | 1 | Rent, January | Rent | -18,500 |
| 45,660 | 2 | Cleaning | Office | -2,125 |
| 45,664 | 3 | Accounting software | Software | -349 |
| 45,667 | 4 | Invoice 1001 | Sales | 55,250 |
Good to know
Why practice on real data?
An exercise with five rows shows you how a formula works. A file with hundreds of rows shows you whether you can use it: whether the ranges cover every row, whether the formula survives being copied down, and whether the answer looks reasonable. That is how Excel gets used at work.
How to download the files
Click a file to see all its sheets and exercises. The file itself needs a free account. Create one and you are sent straight back to the file.
Get the files free
A free account gives you every file and saves your progress in the exercises.