Skip to main content

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

BeforeAfterWhy it matters
MARGARET ELLISONMargaret EllisonNobody likes their name shouted on an envelope.
Ellison, MargaretMargaret · EllisonSplit names let a card say “Dear Margaret”.
Texas, Tex., txTXSorting machines read the two-letter code.
2134 (Boston)02134A four-digit ZIP code can’t be delivered.
59771.059771Spreadsheets sometimes store ZIP codes as decimals.
1907 West Main Street, apartment 21907 W Main St, Apt 2The Postal Service’s standard wording.
Two rows for the same personOne rowOne 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.

Clean list, handwritten cards.

Every card and envelope in real pen.

Send to a list
A note to Rosa in Clara handwriting: I'm still thinking about that lemon cake. Thank you for dinner, and for always making room for one more. Love, Kate. The card's front, Sweet of You, rests beside it.The whole open card from Kate, with a stamped envelope addressed to Rosa Thompson in pen tucked beneath it.