Whitespace Cleaner
Stray spaces break joins, sorts and lookups — and they are invisible in Excel. This tool trims leading and trailing spaces and collapses runs of repeated spaces across every cell, showing you exactly what changed before you download.
[ Interactive Workspace ]
Whitespace Cleaner
Upload a CSV to trim leading/trailing spaces and collapse runs of repeated spaces.
100% client-side
No upload · No storage
Refresh or close the tab and your cleaned dataset is gone — download your file to keep it.
Parsing rows, detecting delimiters and profiling columns in your browser.
file.csv
Encoding notice
Data Quality Score
–
–
Points deducted from 100 for each problem found. Hover rows or see the report for details.
Columns
| Column | Type | Empty | Unique |
|---|
Detected problems & fixes
Duplicate options
Columns to match on:
Rows that will be removed (first 25):
Whitespace options
Format options
First 25 rows
Cleaning history
How to use it
Three steps
- 1Upload your CSVDrop the file onto the workspace above. Cells with irregular whitespace are detected and counted automatically.
- 2Choose what to cleanTick “Trim leading & trailing spaces” and/or “Collapse repeated inner spaces”. The after-preview updates live.
- 3Download the clean fileClick “Apply selected fixes” or “Download cleaned CSV”. Meaningful single spaces between words are preserved.
Example use cases
- Fixing VLOOKUP/INDEX-MATCH failures caused by trailing spaces in keys
- Normalizing names and addresses exported from CRMs with inconsistent padding
- Preparing data for dedup — trailing spaces make identical values look different
- Cleaning pasted data where invisible characters sneak into cells