--- title: "Free Excel practice files: datasets and templates with exercises | PracticeExcel" 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://practiceexcelonline.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://practiceexcelonline.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 | PracticeExcel" "twitter:image": "https://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.com/learn/excel-budget-template#download-budget) ## **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://practiceexcelonline.com/learn/excel-practice-data#download-employees) ## **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://practiceexcelonline.com/learn/excel-practice-data#download-sales-data) ## **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://practiceexcelonline.com/practice/the-grid/welcome) ```json {"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.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://practiceexcelonline.com/free-excel-files","breadcrumb":{"@id":"https://practiceexcelonline.com/free-excel-files#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/free-excel-files"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/free-excel-files#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Free Excel practice files: datasets and templates with exercises","position":2}]},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]} ``` ## Sitemap See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.