← Back to all tools
Tool 01

📞 Address List Optimizer

Cleans a US contact list in one pass: formats phone numbers the same way, standardizes addresses (street, city, state, ZIP) and removes duplicate rows.

🔒 Works offline — your file never leaves your computer

This page loads nothing from the internet. Try it with your Wi-Fi turned off. Your original file is never changed — you save a cleaned copy.

⚠️ Always keep a copy of your original file as a backup. Check the cleaned copy before you use it.
📄

Open your Excel file (stays on this computer)

Drag it into this box or click below — .xlsx, .xls or .csv

Options
212-555-0142, +1 (212) 555 0142, 001 212 5550142 and 2125550142 all become one format. Columns named Phone, Tel, Mobile, Cell or Fax are used.
Capitalization, street types, 2-letter state codes, ZIP codes with lost leading zeros. A one-cell address like "42 oak st., 10001 new york" becomes "42 Oak St, New York, NY 10001".
After cleaning, rows that are identical in every column are removed (the first one is kept). Upper/lower case and extra spaces are ignored when comparing.
Takes only a few seconds
✓

Cleanup complete

Only the first worksheet is cleaned. Other worksheets, and any title rows above your table, are kept unchanged. Values, number formats and dates are kept; cell colors and fonts are not carried over. Row numbers refer to your original file.