Free tools that clean messy Excel and CSV lists right in your browser. Your file never leaves your computer — no upload, no account, no limits.
Formats US phone numbers as (212) 555-0142, standardizes addresses and removes duplicate rows — in one pass.
Clean my address listShows duplicate rows side by side. You pick what gets deleted — nothing is removed automatically.
Find duplicate rowsTurns text into real dates, shows 1.23E+11 numbers in full, converts text numbers and fixes ZIP code zeros.
Fix dates and numbersDeletes empty rows and columns and fills blank cells with a value or the value above.
Remove empty cellsUSPS-style addresses: "42 oak st., 10001 new york" becomes "42 Oak St, New York, NY 10001".
Format US addressesCombines columns with any separator — First + Last Name = "John Smith". No formulas needed.
Merge columnsTitle Case, UPPERCASE, lowercase or Sentence case — keeps McDonald, LLC and NY correct.
Fix text caseRemoves extra and invisible spaces that break VLOOKUP, filters and duplicate checks.
Remove extra spaces| What is wrong? | Which tool helps? |
|---|---|
| Phone numbers in five different formats | Address List Optimizer |
| The same customer appears twice | Find and remove duplicates |
| Dates that will not sort, numbers like 1.23E+11, ZIP codes without the leading zero | Fix dates and number formats |
| Empty rows and blank cells that break your filters | Clean empty cells |
| Addresses typed in capitals or with the ZIP code in the wrong place | Format US addresses |
| First name and last name in separate columns | Merge columns |
| JOHN SMITH in one row and john smith in the next | Fix text case |
| VLOOKUP shows #N/A although both values look the same | Clean Whitespace |
Download the tool you need (one small file) or use it right on this website. Free, no sign-up.
Double-click the file — it opens in Chrome, Edge, Firefox or Safari. Then choose your Excel or CSV file.
Click Run, check the before/after examples and save. Your original file stays untouched on your PC.