Medium
Thursday, October 1Challenge 01
Customer Import Rescue
Clean a customer export before it is allowed into a CRM.
Starts when you’re readyFull challenge
Dirty Data Lab™
Nine October data-cleaning puzzles. Think Sudoku, but for messy spreadsheets.
Clean the sheet directly in your browser, check your work instantly, and keep going until every cell is right. A new challenge lands every Monday and Thursday.
Mondays + Thursdays Save streaks with a free Lab profile
Loading your Lab profile…
Play on this page
Pick a challenge and start cleaning.
No download required. Your score updates after you check your work.
Hard
Thursday, October 22 · timed sprintProperty Roster Audit
A property roster has duplicate leases, inconsistent units, messy rent strings and ended leases mixed into active occupancy.
Show cleanup rules
- Normalize lease_id, property, unit, tenant name and tenant email.
- Normalize move_in to YYYY-MM-DD and monthly_rent to a decimal amount.
- Normalize status to Active or Ended.
- Remove duplicate lease_id records after trimming.
- Sort by property then unit.
- Calculate Active lease count and total Active monthly rent.
Loading the puzzle board…
October board
All nine challenges
Medium-Hard
Monday, October 5Challenge 02
Vendor Master Merge
Turn a vendor master with duplicate records into one reliable source of truth.
Starts when you’re readyFull challenge
Hard
Thursday, October 8Challenge 03
Invoice Reconciliation
Reconcile invoice rows where formatting hides duplicates and credits.
Starts when you’re readyFull challenge
Hard
Monday, October 12Challenge 04
CRM Collision Course
Resolve duplicate CRM contacts using normalized identity fields and recency.
Starts when you’re readyFull challenge
Very Easy
Thursday, October 15Challenge 05
The Five-Minute Cleanup
A deliberate breather: one blank row, one duplicate, and simple formatting.
Starts when you’re readyFull challenge
Medium-Hard
Monday, October 19Challenge 06
Order Export Maze
Clean line-item data, expose duplicate keys, then prove the revenue total.
Starts when you’re readyFull challenge
Hard
Thursday, October 22Challenge 07
Property Roster Audit
Clean a lease roster and recover the real active-rent roll.
Starts when you’re readyFull challenge
Medium-Hard
Monday, October 26Challenge 08
UTM Aggregation Puzzle
Normalize campaign dimensions, then combine rows that only look different.
Starts when you’re ready Opens Monday, October 26
Hard
Thursday, October 29Challenge 09
Month-End Data Audit
Finish October with a finance-style audit where every cleanup rule matters.
Starts when you’re ready Opens Thursday, October 29
Have a real file instead?
The Lab is practice. Clean That Sheet is for the spreadsheet that actually has to go out the door.
Clean a real spreadsheet Take the habit into Google Sheets
Practice here. Preflight real sheets with CTS Guard.
Clean That Sheet Guard checks the active Google Sheet for duplicates, missing data, formatting issues and other handoff problems before you share or import it.