← Back to all tools
Tool 05

🏠 Format US Addresses

Brings US addresses into one clean USPS-style format: "42 oak st., 10001 new york" becomes 42 Oak St, New York, NY 10001. Works with one address column or separate Street / City / State / ZIP columns.

🔒 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
10001 → NY, 94105 → CA. States that are written out (California) always become 2-letter codes (CA).
2110 → 02110 (Boston). 9-digit ZIP codes become ZIP+4: 94105-1234.

Columns are found by their header: Address, Street, Address Line 1/2, City, State, ZIP / Postal Code. Addresses the tool cannot read with confidence are left unchanged and listed for you to check.

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.