Data Cleaner
Fix the boring problems that break analysis: stray spaces, duplicates, blank rows, inconsistent nulls and casing. Get a clean CSV and a change log.
📂 Drop a CSV or browse
Cleaning steps
Why these steps matter
Most "wrong numbers" in reports aren't maths errors. They're data-entry noise. "Canada" and "Canada " group separately in a pivot table. A pasted row counted twice inflates revenue. N/A typed into a numeric column turns the whole column into text. The cleaner fixes these patterns in one pass and tells you exactly what changed.
- Order of operations: nulls are standardised and spaces trimmed before duplicates are detected, so near-duplicates that differ only by whitespace are caught.
- Case changes apply only to text values. Numbers and dates are left untouched.
- Regex find & replace uses JavaScript syntax with the global flag, for example
\D→ empty to strip non-digits from phone numbers.
For a deeper process, see the data cleaning checklist, then verify the result in the Data Profiler.
Cleaning a CRM or product catalogue?Get expert cleanup