---
title: "Free Excel practice files: datasets and templates with exercises"
description: "Free Excel files to practice on: sales data, employee data and a budget template, with exercises and answers. Preview the sheets, then download free."
canonical_url: "https://excelsavvy.com/free-excel-files"
meta:
  "og:description": "Free Excel files to practice on: sales data, employee data and a budget template, with exercises and answers. Preview the sheets, then download free."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~RnJlZSBFeGNlbCBwcmFjdGljZSBmaWxlczogZGF0YXNldHMgYW5kIHRlbXBsYXRlcyB3aXRoIGV4ZXJjaXNlcw%2Cdescription_~RnJlZSBFeGNlbCBmaWxlcyB0byBwcmFjdGljZSBvbjogc2FsZXMgZGF0YSwgZW1wbG95ZWUgZGF0YSBhbmQgYSBidWRnZXQgdGVtcGxhdGUsIHdpdGggZXhlcmNpc2VzIGFuZCBhbnN3ZXJzLiBQcmV2aWV3IHRoZSBzaGVldHMsIHRoZW4gZG93bmxvYWQgZnJlZS4%2Csite_practiceexcel%2Cp_Ii9mcmVlLWV4Y2VsLWZpbGVzIg%2Cs_mCv796JbkZX3qBMj.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Free Excel practice files: datasets and templates with exercises"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~RnJlZSBFeGNlbCBwcmFjdGljZSBmaWxlczogZGF0YXNldHMgYW5kIHRlbXBsYXRlcyB3aXRoIGV4ZXJjaXNlcw%2Cdescription_~RnJlZSBFeGNlbCBmaWxlcyB0byBwcmFjdGljZSBvbjogc2FsZXMgZGF0YSwgZW1wbG95ZWUgZGF0YSBhbmQgYSBidWRnZXQgdGVtcGxhdGUsIHdpdGggZXhlcmNpc2VzIGFuZCBhbnN3ZXJzLiBQcmV2aWV3IHRoZSBzaGVldHMsIHRoZW4gZG93bmxvYWQgZnJlZS4%2Csite_practiceexcel%2Cp_Ii9mcmVlLWV4Y2VsLWZpbGVzIg%2Cs_mCv796JbkZX3qBMj.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **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.

.xlsx

## **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.

*A look at the Budget sheet*

| **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* |

[**See the file and its exercises **](https://excelsavvy.com/learn/excel-budget-template#download-budget)

## **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.

*A look at the Customers sheet*

| **Customer ID** | **First name** | **Last name** | **Email** | **City** | **Segment** | **Signup date** | **Orders** | **Total spent** | **Newsletter** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 2,001 | Noah | Davis | noah.davis@icloud.com | Austin | Private | 45,784 | 1 | 1,275 | Yes |
| 2,002 | Tyler | Smith | tyler.smith@gmail.com | Chicago | Private | 45,882 | 9 | 2,395 | No |
| 2,003 | Mia | King | mia.king@king-co.com | Chicago | Business | 44,249 | 21 | 86,231 | No |
| 2,004 | Mason | Smith | mason.smith@gmail.com | Denver | Private | 44,745 | 4 | 5,075 | Yes |

[**See the file and its exercises **](https://excelsavvy.com/learn/excel-customer-data#download-customers)

## **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.

*A look at the Employees sheet*

| **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 |

[**See the file and its exercises **](https://excelsavvy.com/learn/excel-practice-data#download-employees)

## **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.

*A look at the Inventory sheet*

| **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 |

[**See the file and its exercises **](https://excelsavvy.com/learn/excel-inventory-data#download-inventory)

## **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.

*A look at the Orders sheet*

| **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 |

[**See the file and its exercises **](https://excelsavvy.com/learn/excel-data-cleaning-practice#download-messy-data)

## **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.

*A look at the Sales sheet*

| **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 |

[**See the file and its exercises **](https://excelsavvy.com/learn/excel-practice-data#download-sales-data)

## **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.

*A look at the Transactions sheet*

| **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 |

[**See the file and its exercises **](https://excelsavvy.com/learn/excel-finance-practice-data#download-transactions)

## **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.

[**Create a free account**](https://excelsavvy.com/practice/the-grid/welcome)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/free-excel-files#webpage","@type":"WebPage","description":"Free Excel files to practice on: sales data, employee data and a budget template, with exercises and answers. Preview the sheets, then download free.","name":"Free Excel practice files: datasets and templates with exercises","url":"https://excelsavvy.com/free-excel-files","breadcrumb":{"@id":"https://excelsavvy.com/free-excel-files#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/free-excel-files"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/free-excel-files#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Free Excel practice files: datasets and templates with exercises","position":2}]},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
