Sample Sales Data
Order records with region, product, channel, units and unit price. Calculate revenue and build PivotTables using the complete practice package.
Preview and practiceExcel sample data & practice files
Download generated spreadsheet datasets as Excel, CSV or JSON — free, with previews and no signup.
Choose sales data for PivotTables, student grades for score summaries, or deliberately messy rows for cleanup practice. Every page offers direct downloads at the default row count. Use its browser control to choose another supported size; nothing is uploaded and no email is required.
Start with a complete practice package
Download the file, solve a clear task, then compare with every reference row and expected result. No account, no email gate.
- Clean messy data — 9 tasks, 100 source rows, a complete answer workbook and separate teaching handouts.
- Analyse student scores — 8 tasks, 180 source rows, a complete answer workbook and separate teaching handouts.
- Build sales PivotTables — 8 tasks, 200 source rows, a complete answer workbook and separate teaching handouts.
Try the employee-ID lookup lesson: six requests on the 150-row roster, with complete answers shown on the page. The XLSX, CSV and JSON downloads are the raw source files.
Prefer a workbook with blank responses? Try the 100-row cleanup project with seven checks, or the 180-record subject-summary project with 36 responses. Each has a visible answer key.
The answers match each default source file. Other download sizes need new ranges and expected totals.
Prefer a browser exercise? Practise formulas interactivelyAll sample datasets
Sample Employee Data
An HR roster with department, job title, hire date, salary and city — for lookups, headcount reporting and date maths.
Preview and practiceSample Financial Data
Monthly revenue, cost of goods, operating expense and headcount — a compact P&L base for margin, growth and CAGR work.
Preview and practiceSample Inventory Data
SKU-level stock with warehouse, quantity on hand, reorder point and unit cost — for conditional formatting and stock alerts.
Preview and practiceMessy Data to Clean
Deliberately dirty rows with padded text, mixed case, inconsistent dates, numbers stored as text and duplicate records for data-cleaning practice.
Preview and practiceSample Student Grades
A long-format student grades table with one score per row, subject and term columns, and attendance values. Download as CSV, Excel or JSON.
Preview and practiceSample Expense Data
Dated business expenses by category, department and payment status — for budget tracking and SUMIFS by month.
Preview and practiceSample Customer Data
A CRM-shaped contact list with email, city, signup date and lifetime value — for merges, list comparison and text functions.
Preview and practiceSample Project Task List
Tasks with owner, start date, duration and percent complete — a flat input table for a stacked-bar Gantt chart.
Preview and practiceSample Time Tracking Data
Same-day clock-in / clock-out values in decimal hours, with break minutes — for duration, hour totals and overtime practice.
Preview and practiceQuestions
Are these Excel practice files really free?
Yes. Every dataset downloads without an account or an email address, and you can use the files for teaching, demos, testing and commercial work.
Is the data real or generated?
Generated, and deliberately so — the rows are realistic in shape and range but contain no real people or companies, so there is nothing sensitive in a file you hand to a class or paste into a bug report.
What formats can I download?
The source data is available as Excel (.xlsx), CSV and JSON with identical source rows. The three practice packages also include answer workbooks, reference CSV files and teaching handouts. The separate optional cleanup and student subject-summary projects are fixed XLSX workbooks with tasks and visible answer keys; those projects are not CSV or JSON files.
Can I download without JavaScript or choose more rows?
Direct Excel, CSV and JSON links work without JavaScript at each dataset’s default size. The browser control offers other supported row counts. Practice-package answers match only the default source size printed on the package.
Which files include complete tasks and answers?
Messy Data, Student Grades and Sales Data each have a complete practice package. The original file, tasks-only handout, full walkthrough and answer workbook are separate downloads so you can try the exercises before seeing the answers.