📞 Clean a US Address List in Excel
Formats phone numbers, standardizes addresses and removes duplicate rows in your contact list — all in one pass.
What the Address List Optimizer 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
Before and after: phone numbers and addresses
| 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 |
How to clean a US address list in Excel in 3 steps
Before you start: limits and backup
- 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.
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
Format US Addresses
USPS-style street, city, state, ZIP
Find & Remove Duplicates
Review duplicate rows before deleting
Fix Date & Number Formats
Real dates, full numbers, ZIP zeros