Tool 01

📞 Clean a US Address List in Excel

Formats phone numbers, standardizes addresses and removes duplicate rows in your contact list — all in one pass.

🔒 Works offline — your file never leaves your computer

What the Address List Optimizer does

Before and after: phone numbers and addresses

BeforeAfter
+1 (312) 555-0107(312) 555-0107
001 415 555 0163(415) 555-0163
(404)5550121(404) 555-0121
42 oak st., 10001 new york42 Oak St, New York, NY 10001
7b Harbor Road, 02110 Boston7B Harbor Rd, Boston, MA 02110
Real output of the tool with the default settings.
⬇ Download Tool — Free
or use it right here in your browser →
Single HTML file · opens in Chrome, Edge, Firefox or Safari · no installation, no sign-up

How to clean a US address list in Excel in 3 steps

1
Download the toolClick the red button and save the file to your computer.
2
Open it in your web browserDouble-click the downloaded file. It opens in your browser — not in Excel. No installation, no account.
3
Choose your Excel file and save the cleaned copyClick "Run", check the before/after examples on screen, then save. Your original file stays untouched.

Before you start: limits and backup

Why contact lists need cleaning

A contact list that was put together from several sources almost never looks consistent. One row has the phone number as 212-555-0142, the next as +1 (212) 555 0142, another as 2125550142. Addresses are typed in capitals, in lowercase, with and without the state, and the same customer shows up twice.

This tool fixes all three problems at once. Phone numbers are brought into one US format, addresses are standardized to the familiar "42 Oak St, New York, NY 10001" pattern, and rows that turn out to be identical after cleaning are removed. The first occurrence of each row is always kept.

Everything happens on your own computer. You open the tool in your web browser, choose your Excel or CSV file and save a cleaned copy. The original file is never changed and nothing is uploaded anywhere.

Entries the tool cannot read with confidence — a phone number with too few digits, an address without a city — are not guessed. They stay exactly as they were and are listed on screen so you can check them yourself.

Common questions about cleaning a US address list

How do I format phone numbers in Excel all the same way?

Open your file in the Address List Optimizer. It finds columns named Phone, Tel, Mobile, Cell or Fax and writes every US number the same way, for example (212) 555-0142. You can also choose 212-555-0142 or +1 212-555-0142. Numbers from other countries stay unchanged and are listed for you.

Can I clean phone numbers, addresses and duplicates in one step?

Yes. The tool formats phone numbers, standardizes addresses and removes rows that are exact duplicates after cleaning, all in one pass. Upper and lower case and extra spaces are ignored when it compares rows, and the first occurrence of each row is always kept.

What happens to entries the tool cannot read?

They are not guessed. A phone number with too few digits or an address without a city stays exactly as it was and is listed on screen, so you can check it yourself.

More free Excel cleanup tools

← View all tools