Data cleanup case study
From inconsistent input to dependable records
The source file contains realistic formatting mistakes. The finished workbook preserves the raw data, documents corrections, and summarizes quality improvements.
60Raw rows
8Fields standardized
6Duplicate candidates
0Unexplained deletions
Before
Mixed date styles, inconsistent casing, extra spaces, incomplete phone formatting, misspelled statuses, and repeat contacts.
Download messy CSVAfter
Normalized names, ISO dates, standardized phone numbers, controlled statuses, separated duplicates, and a detailed issue log.
Download cleaned workbook