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 it does

Formats US phone numbers the same way: 212-555-0142, +1 (212) 555 0142, 001 212 555 0142 and 2125550142 all become (212) 555-0142 (or 212-555-0142 / +1 212-555-0142 — your choice)
Keeps extensions: "212 555 0142 x45" becomes (212) 555-0142 ext. 45
Standardizes addresses the USPS way: street types (St, Ave, Blvd), 2-letter state codes, ZIP codes with lost leading zeros
Removes rows that are exact duplicates after cleaning — upper/lower case and extra spaces are ignored
Shows you before/after examples and lists every entry it could not fix, so nothing is changed silently

Example

Before	After
+1 (312) 555-0107	(312) 555-0107
001 415 555 0163	(415) 555-0163
(404)5550121	(404) 555-0121
42 oak st., 10001 new york	42 Oak St, New York, NY 10001
7b Harbor Road, 02110 Boston	7B 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 it works

Download the toolClick the red button and save the file to your computer.

Open it in your web browserDouble-click the downloaded file. It opens in your browser — not in Excel. No installation, no account.

Choose your Excel file and save the cleaned copyClick "Run", check the before/after examples on screen, then save. Your original file stays untouched.

Good to know

Always keep a copy of your original file as a backup and check the cleaned copy before you use it.
Phone numbers from other countries (for example +44 or +49) are left unchanged and listed for you.
Columns are found by their header name: Phone, Tel, Mobile, Cell, Fax — and Address, Street, City, State, ZIP.
Reads .xlsx, .xls and .csv files and saves the result as a new .xlsx file.
Only the first worksheet is cleaned. Other worksheets and title rows above your table are kept unchanged.
Values, dates and number formats are kept. Cell colors and fonts are not carried over to the cleaned copy.
The tools are provided free of charge and "as is". We have built and tested them with great care, but we cannot guarantee that every entry is recognized or changed correctly. As far as permitted by law, we accept no liability for results or any damage arising from their use. See Legal Notice & Disclaimer.

More about this tool

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.

More free tools

🏠