Tool 05

🏠 Format US Addresses in Excel

Brings every address in your list into the same USPS-style format — whether your addresses are in one column or split into Street, City, State and ZIP.

🔒 Works offline — your file never leaves your computer

What it does

Puts one-cell addresses in the standard order: Street, City, ST ZIP — even when the ZIP code was typed before the city
Fixes capitalization: 7B HARBOR RD → 7B Harbor Rd, new york → New York (names like McDonald and DeKalb stay correct)
Street types abbreviated the USPS way (St, Ave, Blvd, Apt, Ste) — or spelled out, if you prefer
State names become 2-letter codes (California → CA); a missing state is added from the ZIP code (10001 → NY)
ZIP codes get their lost leading zero back (2110 → 02110) and 9-digit ZIPs become ZIP+4 (94105-1234)
Works with separate Street / City / State / ZIP columns too

Example

Before	After
42 oak st., 10001 new york	42 Oak St, New York, NY 10001
7B HARBOR RD, 2110 BOSTON	7B Harbor Rd, Boston, MA 02110
15 maple avenue, 60601, chicago	15 Maple Ave, Chicago, IL 60601
900 Pine str. 94105 San Francisco	900 Pine St, San Francisco, CA 94105
1 main street apt 4b, springfield, illinois 62701	1 Main St Apt 4B, Springfield, IL 62701

Real output of the tool with the default settings (street types abbreviated).

⬇ 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.
Made for US addresses. Addresses from other countries are not recognized and are left unchanged.
Addresses the tool cannot read with confidence (for example without a city) are never guessed — they stay as they are and are listed for you.
The tool formats addresses; it does not check whether an address really exists.
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

Address lists from different sources rarely match. One export writes "42 OAK STREET, NEW YORK", the next "42 oak st., 10001 new york", a third puts the ZIP code before the city. For mailings, labels or imports into a CRM you need every address in the same format.

This tool standardizes US addresses the way the Postal Service writes them: street number and name, street type (St, Ave, Blvd), unit (Apt, Ste), then city, 2-letter state code and ZIP code. Capitalization is fixed, state names become codes and a missing state is added from the ZIP code.

It works whether your list has one address column or separate columns for Street, City, State and ZIP. Columns are recognized by their header name.

You see before/after examples on screen, and every address the tool could not read with confidence is listed instead of being changed. Your file never leaves your computer.

More free tools

📞