Remove Whitespace from Excel in 1 Click — Free, No Upload, Data Safe

How to Remove Leading and Trailing Spaces from Excel Online

1. Drop one .xlsx, .xlsm, or .xls workbook — processing is fully local and the file is never uploaded.
2. Pick the two cleanup options: collapse repeated inner spaces into one (off by default) and treat NBSP / full-width spaces as regular spaces (on by default).
3. Click Clean spaces — every text cell on every sheet loses its leading and trailing whitespace, including tabs and line breaks.
4. Review the report — each sheet lists how many cells changed, with a total at the top.
5. Download the result as a clean .xlsx named your-file-name-trimmed.xlsx.

How It Works

This tool trims whitespace in Excel cells. Internally: it reads the .xlsx workbook (ZIP of XML parts) in the browser, scans each cell’s text value for leading spaces, trailing spaces, and/or extra internal spaces (depending on the trim mode the user picks), applies the trimming in place to the cell values, then repackages the modified XML parts back into a fresh .xlsx ZIP. All local — no upload.

Your file never leaves your device. All parsing, trimming and repackaging happens in JavaScript inside the browser — no upload, no queue, and no file-size limit beyond what your machine can hold in memory.

Compared to the TRIM Function

Most people trim whitespace in Excel with the TRIM() formula, which collapses leading/trailing/internal spaces. But TRIM needs a helper column, only works cell-by-cell, and leaves the original data untouched — you then have to paste-as-values over the originals. This tool trims directly in the source cells, across the whole sheet at once, no formulas needed.

Option 1: Collapse Repeated Inner Spaces

Trimming always removes whitespace at both edges of a text cell. With collapse off (the default), spaces, tabs, and line breaks between words are kept exactly as they are. Turn collapse on to shrink every run of inner whitespace into one ordinary space.

Option 2: Handle NBSP and Full-Width Spaces

A non-breaking space (U+00A0, common in text copied from the web) and an ideographic full-width space (U+3000, common in Japanese and Chinese typography) look exactly like a normal space but are different characters — VLOOKUP and exact-match filters treat them as different. With the option on (the default), both are converted to ordinary spaces before trimming; with it off, they are left completely untouched.

A cell that looks empty can actually contain a single NBSP or full-width space. Excel’s own TRIM() function does not remove NBSP either — you would normally need SUBSTITUTE for that. With this option on, the tool performs that substitution for you in one pass.

When You Need to Clean Spaces in Excel

• VLOOKUP, XLOOKUP, INDEX/MATCH, or COUNTIF fails even though two values look identical — one of them usually carries a trailing space or an NBSP.
• Preparing data exported from another system or scraped from the web before importing it into a database, CRM, or ERP that rejects mismatched keys.
• Comparing or joining columns by codes, email addresses, or phone numbers where one hidden space breaks the match.
• Normalizing form submissions and pasted text before analysis or pivot tables.

Only text cells are modified. Numbers, dates, booleans, and truly empty cells pass through untouched — a value stored as 0 stays 0, and date cells keep their Date value.

Limitations

• The output is a value-level .xlsx rebuilt from your data: cell styles, column widths, merged cells, and charts are simplified.
• Whitespace inside formulas is not changed; only cached text values are processed.
• Encrypted workbooks (password required to open) cannot be read.
• Legacy .xls files are supported, but are converted to .xlsx on output.