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 the address formatter does

Before and after: US addresses

BeforeAfter
42 oak st., 10001 new york42 Oak St, New York, NY 10001
7B HARBOR RD, 2110 BOSTON7B Harbor Rd, Boston, MA 02110
15 maple avenue, 60601, chicago15 Maple Ave, Chicago, IL 60601
900 Pine str. 94105 San Francisco900 Pine St, San Francisco, CA 94105
1 main street apt 4b, springfield, illinois 627011 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 to format US addresses 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 addresses need one format

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.

Common questions about formatting US addresses

How do I put street, city, state and ZIP in the right order?

The tool puts one cell addresses in the standard order Street, City, ST ZIP, even when the ZIP code was typed before the city. It also works with separate Street, City, State and ZIP columns, which it finds by their header names.

How do I add the state from a ZIP code in Excel?

The tool does this for you. A missing state is added from the ZIP code, so 10001 becomes NY, and state names such as California become two letter codes like CA. ZIP codes also get a lost leading zero back.

Does the tool check whether an address really exists?

No. It formats addresses but does not check them. It is made for US addresses, and addresses from other countries are left unchanged. Addresses it cannot read with confidence, for example without a city, are never guessed and are listed for you.

More free Excel cleanup tools

← View all tools