Practice downloads
16 free packs of original, fictional data for practising in Excel or Power BI Desktop. Each pack has messy CSV, XLSX or JSON files, tested .pq queries and step-by-step follow-along instructions.
What you get, honestly labelled
- Data files: plain CSV, JSON and XLSX. The XLSX files contain values only, with no formulas and no Power Query connection inside.
- Queries:
.pqtext you paste into the Advanced Editor. The first lines explain how each source is bound to the files and which folder to change. - Each query was run in the Power Query Exercises simulator against the exact files in its pack. We haven't run them in Excel or Power BI, so these aren't ready-to-refresh workbooks.
- CSV and XLSX files are protected against spreadsheet formula injection.
Café till export
A small coffee shop's till export with voided transactions, staff names typed three ways and timestamps to split into dates.
beginner · 1 file (CSV) · 2 queries
European invoices (semicolon CSV)
A German-format invoice export: semicolons between fields, day.month.year dates and decimal commas. The classic locale trap.
beginner · 1 file (CSV) · 1 query
Clinic appointments workbook
An XLSX workbook with one sheet per clinic site and a hidden notes sheet. Combine every visible site sheet and work out attendance.
intermediate · 1 file (XLSX) · 2 queries
Weather station JSON
A JSON export of stations, each with a list of readings and optional flags. Flatten it to one row per reading without losing the station that has none.
intermediate · 1 file (JSON) · 1 query
Coffee roaster monthly files
A folder of monthly sales CSVs from a coffee roaster. February added an Origin column. Combine by column name and practise a real refresh with the April file.
intermediate · 4 files (CSV) · 1 query
Department budget (wide months)
A budget workbook with one column per month. Unpivot it into a tidy table that keeps working when finance adds July.
intermediate · 1 file (XLSX) · 1 query
Orders, customers and regions
Three related CSVs with an order for a customer that doesn't exist and a customer in an unknown region. Practise join kinds and find the orphans.
intermediate · 3 files (CSV) · 2 queries
Gym membership sign-ups
Sign-ups where the same person appears several times with differently typed emails. Keep the latest sign-up per member, deterministically.
intermediate · 1 file (CSV) · 1 query
Warehouse report layout
A printed stock report with location header rows, subtotals and blank separators. Turn it into a proper table with Fill Down.
intermediate · 1 file (CSV) · 1 query
Product code parsing
A clothing catalogue whose codes pack style, colour and size into one text value, and whose descriptions hide a pack size.
beginner · 1 file (CSV) · 1 query
Fridge sensor log
Half-hourly fridge temperatures with ERR codes, gaps and a -999 sentinel. Classify every reading instead of letting errors break the refresh.
intermediate · 1 file (CSV) · 2 queries
Library loans
A month of library loans across three branches, some still out. Summarise loans and average days out per branch and genre.
beginner · 1 file (CSV) · 1 query
Survey responses
Survey answers stored one row per respondent and question. Pivot them into one row per respondent, with a gap where someone skipped a question.
intermediate · 1 file (CSV) · 2 queries
Calendar table with closure days
Generate a 2026 date table in M and flag the company's closure days from a small CSV. No external date source needed.
intermediate · 1 file (CSV) · 1 query
Contacts cleanup with a custom function
Messy phone numbers and postcodes, cleaned by small custom M functions you can reuse across queries.
advanced · 1 file (CSV) · 1 query
Meter readings to usage
Cumulative utility meter readings, out of order. Sort per meter and turn readings into usage between consecutive readings.
advanced · 1 file (CSV) · 1 query