← Back to all tools
Tool 08

✂️ Clean Whitespace

Removes spaces at the start and end of cells, double spaces, invisible characters copied from websites (non-breaking and zero-width spaces), tabs and line breaks. This fixes VLOOKUP / XLOOKUP and filters that fail to match.

🔒 Works offline — your file never leaves your computer

This page loads nothing from the internet. Try it with your Wi-Fi turned off. Your original file is never changed — you save a cleaned copy.

⚠️ Always keep a copy of your original file as a backup. Check the cleaned copy before you use it.
📄

Open your Excel file (stays on this computer)

Drag it into this box or click below — .xlsx, .xls or .csv

Options
" John Smith " → "John Smith"
"John    Smith" → "John Smith"
Non-breaking spaces become normal spaces; zero-width spaces and other hidden characters are removed.
Uncheck this if you want to keep line breaks in multi-line cells.
Takes only a few seconds
✓

Cleanup complete

Only the first worksheet is cleaned. Other worksheets, and any title rows above your table, are kept unchanged. Values, number formats and dates are kept; cell colors and fonts are not carried over. Row numbers refer to your original file.