Skip to main content
excelforall
Get started
Contents

Five datasets, no download

Tab-separated, so a pasted block lands in columns instead of all in one cell.

Jump to the data

Featured image

Free Excel sample data

5 small datasets to practise on, in Excel, Google Sheets or anywhere else. Copy a block and paste it into a grid, no download, no sign-up, no file to open.

Published by

Chris

Updated on

Small on purpose. A dataset you can check by hand is one where you will notice your formula is wrong; a hundred thousand rows of generated noise teaches you nothing except that the file is slow. Every figure here is invented, so there is nothing to anonymise and nothing to attribute.

Sales log

Ten rows of regional sales with a rep, a unit count and a revenue figure. The workhorse set: small enough to check by hand, varied enough that conditional totals give different answers per region.

Good forSUMIF and SUMIFSCOUNTIFSorting and filteringPivot tables

RegionRepUnitsRevenue
NorthAda121240
SouthBen7730
NorthCleo192015
EastDev4410
SouthEve222380
NorthFinn151580
EastGia9950
SouthHal3320
NorthIris272890
EastJo111150

Tab-separated: pastes straight into a grid

 

Product catalogue

Six products with a code, a name and a price. The lookup table: pair it with the sales log, or look a code up against it directly.

Good forVLOOKUPXLOOKUPINDEX and MATCH

CodeProductPrice
P-100Desk lamp42
P-200Office chair189
P-300Monitor arm95
P-400Keyboard64
P-500Docking station143
P-600Laptop stand38

Tab-separated: pastes straight into a grid

 

Messy contact list

Deliberately dirty: stray spaces, inconsistent capitals, a duplicate row and a phone number that will lose its leading zero the moment Excel sees it. This is what an export actually looks like.

Good forTRIM and PROPERRemove duplicatesFind and replaceLeading zeros

NameEmailPhone
ada lovelace [email protected]0412555901
BEN CARTER[email protected]0477120364
cleo nakamura[email protected]0455908712
BEN CARTER[email protected]0477120364
dev osei [email protected]0433771208

Tab-separated: pastes straight into a grid

 

Monthly visitors

Twelve months of a single measure, with a dip in April and a run of growth after it. Enough shape to make a line chart worth drawing and a percentage change worth calculating.

Good forLine chartsPercentage changeMAX, MIN and AVERAGE

MonthVisitors
Jan812
Feb905
Mar1140
Apr998
May1203
Jun1388
Jul1402
Aug1655
Sep1590
Oct1744
Nov1812
Dec2105

Tab-separated: pastes straight into a grid

 

Exam marks

Two classes with the same mean and completely different spreads, plus one salary-style outlier column. Built for the statistics exercises, the average alone tells you almost nothing about these.

Good forMEDIAN against AVERAGESTDEV.SQUARTILE.INCNested IF grade bands

StudentClass AClass B
Student 15822
Student 26135
Student 35994
Student 46288
Student 56061
Student 65719
Student 76397

Tab-separated: pastes straight into a grid

 

Guides for working with data

Data is only worth having if you are going to do something to it. These walk through the operations the datasets above are built for.

How to remove duplicates in Excel without deleting the wrong rows covers the one that deletes your data if you get it wrong: what Excel actually compares, why a trailing space makes two identical-looking rows survive, and how to count the repeats before removing anything.

How to find duplicates in Excel before you delete anything is the one to read before the delete button: a COUNTIF column that shows exactly which rows repeat and how many times, so nothing is removed on trust.

Or skip the paste

Every exercise on this site already has its dataset loaded into a working grid, with a task attached and an answer checker that reads your formula. You do not need Excel open to use them.

Browse the exercisesTake the assessment test

See also Excel keyboard shortcuts and the full function list.

You might also like