Excel Data Cleaner — Free Online Tool
Trim whitespace, strip the invisible characters that silently break VLOOKUP, delete blank rows and columns, and normalise text case — all in your browser in seconds. Your file never leaves your device.
Drop your Excel or CSV file here
.xlsx · .xls · .csv — up to 100 MB · stays in your browser
Cleaning operations
Text case
Your file is never uploaded · all processing runs in your browser
What is Excel data cleaning?
Excel data cleaning is the process of fixing common quality problems in a spreadsheet before you use the data in analysis, reporting, or a database import. Dirty data — leading spaces, invisible characters, blank rows, inconsistent capitalisation — causes formulas to return wrong results, pivot tables to miscount, and SQL imports to duplicate rows.
The most insidious problem is invisible characters: a non-breaking space (the HTML character, Unicode U+00A0) is visually identical to a regular space but is a completely different byte. VLOOKUP, XLOOKUP, and MATCH compare raw bytes, so a cell containing “Apple” with a trailing non-breaking space never matches “Apple”without one — even when both look identical on screen. This tool detects and fixes all such characters in one pass.
When does Excel data need cleaning?
Common situations where a quick data clean saves hours of formula-debugging or import errors.
VLOOKUP / XLOOKUP returning #N/A unexpectedly
Data pasted from a web page, CRM export, or ERP system often carries invisible characters. VLOOKUP then fails silently because the key in the lookup range has a hidden trailing non-breaking space that the value in your formula does not. Cleaning the file fixes it instantly.
Database or data-warehouse imports duplicating rows
SQL imports treat "Alice " (trailing space) and "Alice" as different values, producing duplicate customer records, split invoice totals, or incorrect GROUP BY aggregations. Trimming and normalising the export before import eliminates the problem at the source.
CSV exports from web forms and SaaS tools
Web forms frequently insert non-breaking spaces in address fields, phone number fields, and free-text columns. Cleaning the CSV before loading it into Excel, Power Query, or a Python script prevents the "same" record from matching nothing.
Mixed-case name and product catalogues
A product list exported from one system with "LAPTOP 15IN" and another with "Laptop 15in" will not VLOOKUP-match each other. Title-casing or lowercasing both files before merging solves the mismatch without touching the source systems.
Pivot table miscounting on blank rows
A pivot table over a range with scattered blank rows counts "(blank)" as a category and skews totals. Removing blank rows before creating the pivot keeps every count accurate.
Data shared between teams with different input habits
One analyst types " London" (leading space), another types "London". COUNTIF sees two distinct values. A single clean pass before hand-off standardises the entire column in seconds rather than requiring every contributor to fix their own rows.
Excel Data Cleaning: SimpleTool vs Excel Built-in vs Power Query
Three approaches to cleaning messy Excel data. Different effort, different coverage.
| Feature | SimpleTool | Excel Built-in (TRIM / CLEAN) | Power Query |
|---|---|---|---|
| Cost | Free | Bundled with Excel | Bundled with Excel (Windows only) |
| Trim leading / trailing spaces | Yes — all cells at once | TRIM() — per column formula | Yes |
| Remove non-breaking spaces (U+00A0) | Yes | SUBSTITUTE() workaround needed | Yes (Text.Trim in extended mode) |
| Remove zero-width / invisible chars | Yes — all variants detected | CLEAN() removes control chars only | Partial |
| Delete entire blank rows | Yes — whole sheet at once | Manual filter or Go To Special | Yes |
| Delete entire blank columns | Yes | Manual | Yes |
| Text case normalisation | lower / UPPER / Title / Sentence | LOWER/UPPER/PROPER() — per column | Yes |
| Modifies original workbook | No — new download | Yes — overwrites in place | Loads into new table |
| Works without Excel installed | Yes (browser) | No | No |
| Setup time for a new file | < 30 seconds | 5-15 minutes per file | 3-10 minutes per file |
Frequently asked questions
Why does VLOOKUP return #N/A even when the value looks identical?
The most common culprit is invisible characters: a non-breaking space (Unicode U+00A0) or a zero-width space (U+200B) that is visually indistinguishable from a regular space but fails byte-by-byte comparison. Excel's VLOOKUP, XLOOKUP, and MATCH all compare raw characters, so "Apple" with a hidden trailing NBSP never matches "Apple" without one. This tool's "Remove invisible characters" option detects and fixes these silently.
What invisible characters does this tool detect?
Non-breaking spaces (U+00A0, the common ), zero-width spaces (U+200B), zero-width non-joiners (U+200C), zero-width joiners (U+200D), word joiners (U+2060), zero-width no-break spaces / BOM characters mid-string (U+FEFF), and soft hyphens (U+00AD). Non-breaking spaces are replaced with regular spaces; the zero-width characters are removed entirely.
Is my file uploaded to a server?
No. All processing runs entirely in your browser using JavaScript. Your file is never sent to any server. SimpleTool has no back-end that receives Excel or CSV files — not even temporarily.
Which file formats are supported?
.xlsx, .xls, and .csv files up to 100 MB. The output is always a .xlsx file regardless of the input format. For CSV files, the tool auto-detects the byte-order mark (BOM) to handle UTF-8, UTF-16 LE, and UTF-16 BE encodings correctly.
What does "Remove blank rows" do exactly?
It deletes any row where every cell is empty (null, undefined, or a whitespace-only string). A row with at least one non-empty cell is kept. The operation runs after trimming and invisible-character removal, so a row containing only spaces is treated as blank.
Does the tool preserve formulas, cell formatting, and column widths?
The tool reads and writes cell values. Formulas are converted to their last calculated value during the round-trip through SheetJS. Cell colours, borders, and font styles are not preserved. Column widths from the original sheet are carried forward where possible.
My CSV file has special characters that look wrong — what do I do?
CSV files from Windows software often use Windows-1252 or another legacy encoding without a BOM. The tool defaults to UTF-8 for BOM-less files, which may render legacy characters incorrectly. In this case, open the CSV in Excel first, save as .xlsx, then use this tool on the .xlsx version.
More Productivity Tools
Explore our other privacy-focused tools designed to boost your productivity
Excel Password Remover
Remove password protection from Excel files safely in your browser
Excel Books Comparer
Spot differences between two Excel workbooks instantly — no uploads
Excel Data Cleaner
Trim whitespace, fix invisible characters, and remove blank rows — browser-only