Mailing list cleaner
Nothing is uploaded.
Drop in a spreadsheet of names and addresses. In a few seconds the ALL CAPS names are fixed, full names are split into first and last, states become two-letter codes, ZIP codes get their lost zeros back, and duplicates are gone. Every change is highlighted, and you download a clean copy.
Drop your spreadsheet here
Excel (.xlsx) or CSV, up to 25,000 rows.
Your list never leaves your computer. Nothing is uploaded.
Include the heading row so we know which column is which.
What it fixes
| Before | After | Why it matters |
|---|---|---|
| MARGARET ELLISON | Margaret Ellison | Nobody likes their name shouted on an envelope. |
| Ellison, Margaret | Margaret · Ellison | Split names let a card say “Dear Margaret”. |
| Texas, Tex., tx | TX | Sorting machines read the two-letter code. |
| 2134 (Boston) | 02134 | A four-digit ZIP code can’t be delivered. |
| 59771.0 | 59771 | Spreadsheets sometimes store ZIP codes as decimals. |
| 1907 West Main Street, apartment 2 | 1907 W Main St, Apt 2 | The Postal Service’s standard wording. |
| Two rows for the same person | One row | One card each, not two. |
What it won’t do
It won’t guess. A row with no street, a ZIP code that doesn’t look like one, or a state it can’t recognize is flagged for you to check, never filled in. Changed cells are highlighted, and you can hover over one to see what it said before.
Before you mail to a list
- Sort by ZIP code and scan for blanks. The “Need a look” filter does this for you.
- Check anyone who moved recently. A clean address is still the wrong address if they’ve left.
- Keep one master copy. Clean it once a year rather than fixing the same rows every campaign.
Good questions.
Is my list uploaded anywhere?
No. The cleaning happens inside your browser, on your own computer. The file never reaches our servers, which is why it works on lists you'd never paste into a website.
Does it check that the addresses really exist?
No. It fixes how addresses are written and flags rows that are missing a street, city, state or ZIP. Checking that an address is real needs the Postal Service's address database, which this free tool doesn't use.
Why did my ZIP codes lose their first zero?
Excel treats a ZIP code like 02134 as a number and drops the zero. Addresses in Connecticut, Maine, Massachusetts, New Hampshire, New Jersey, Rhode Island, Vermont and Puerto Rico are affected. The cleaner puts the zero back when the state tells it to.
Will it change names like McAllister or DeShawn?
No. Only names typed entirely in capitals or entirely in lowercase are changed. A name with its own capitals is left exactly as it was.
How do I split first and last names in Excel?
You don't need to. Upload the file with its full-name column and the cleaner adds First name and Last name columns. It also turns “Ellison, Margaret” around.
What counts as a duplicate?
The same name at the same street address and ZIP code, ignoring capitals and abbreviations. “1907 West Main Street” and “1907 W Main St” match. Two different people at one address are kept.
How many rows can it handle?
Up to 25,000 rows in one file, from Excel (.xlsx), CSV or tab-separated text.
More free tools
- Whose name goes first? Where does the apartment go?How to address an envelopeType the names and address. See the envelope written out the right way, for couples, families, widows and more.Open
- How many stamps do I need?Stamp calculatorHow many stamps your card, letter or invitation needs, with today's prices.Open
- Is the post office open today?Is there mail today?Today's answer where you are, the next day with no mail, and every USPS holiday through 2027.Open
- When's the last day to mail Christmas cards?Christmas mailing deadlinesThe last day to mail cards and packages for Christmas, from the Postal Service's own 2026 dates.Open
- What do I write?What to write in a cardTell us who it's for and one thing about them. Get three messages that sound like you.Open
- Who's on the list this year?Christmas card listKeep every address in one place. Tick off who you sent to and who sent you one. It's still here next year.Open


