Messy Data to Clean
Deliberately dirty rows — trailing spaces, mixed case, inconsistent dates and duplicate records — for data-cleaning practice.
What is in the file
6 columns, 100 rows by default. The first ten rows are shown below — the download contains exactly this data.
| Record ID | Customer Name | City | Signup Date | Amount | Status |
|---|---|---|---|---|---|
| REC-1000 | Adam | Austin | 2024-02-23 | 1837.25 | Refunded |
| REC-1001 | EMMA | Kraków | 2024-07-17 | 1053.26 | Overdue |
| REC-1002 | felix | Bologna | 2025-04-09 | 269.28 | Pending |
| rec-1003 | Sofia | toronto | 2025-09-01 | 3273.3 | Paid |
| REC-1004 | Jonas | Malmö | 2024-06-22 | 2489.31 | Refunded |
| REC-1005 | Mia | Berlin | 2024-11-14 | 1705.33 | Overdue |
| REC-1006 | Oliver | Austin | 2025-08-07 | 921.35 | Pending |
| REC-1007 | Liam | BERLIN | 2025-12-30 | 137.36 | Paid |
| REC-1008 | LUCAS | Lisbon | 2025-05-27 | 533.11 | Refunded |
| REC-1009 | Lena | Manchester | 2025-10-19 | 3537.13 | Overdue |
Built in your browser when you click. Nothing is uploaded, no signup, free for commercial use.
About this dataset
Every other practice file on the web is already clean, which makes it useless for the skill people actually search for. This one is broken on purpose and in named ways: padded and double-spaced text, SHOUTING and lower-case variants of the same value, duplicated records, and numbers stored as text. Clean it with TRIM, PROPER, Remove Duplicates and Text to Columns, then check your result against the tidy dataset it was derived from.
What you can practise with it
- TRIM and CLEAN padded text, then PROPER-case names
- Remove Duplicates and count what disappeared
- Convert numbers stored as text back to real numbers
- Split a combined "Last, First" column into two
Tools that work on this data
Free to use, share and republish — including commercially. Attribution isn't required, but it's what keeps these free to make, and there's one ready to paste below.
Questions
Is this messy data to clean free to use?
Yes — for practice, teaching, demos and commercial work alike. The rows are generated, so there is no personal data in the file. Attribution is not required; if you would like to credit it, there is a ready-made line at the bottom of this page.
Do I have to sign up or give an email address?
No. The file is built in your browser when you click download; nothing is uploaded and no account is involved.
Which formats can I download?
Excel (.xlsx), CSV and JSON. All three contain the same rows, so you can use the CSV for an import exercise and the .xlsx for a formula exercise.
Can I choose how many rows I get?
Yes. Pick a row count before downloading — the default is 100 rows, which is what the preview on this page is drawn from.