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 processes your file on your computer and never uploads it. Once the page is open, it makes no further connections: 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.