Free Bulk Address Formatter

Clean, format, and standardize up to 25 addresses at once. Paste messy addresses, landmarks, or coordinates and download corrected results as CSV. No sign-up needed.

Enter addresses — one per line 0 addresses

Country hint:

Output:

Full Address Components

Cleaning addresses...

This may take a few seconds for multiple addresses

#	Original	Formatted Address

How It Works

Paste or Upload

Type addresses one per line, or import a CSV / Excel file with up to 25 addresses. Supports full addresses, landmarks, and coordinates.

Clean & Standardize

Google’s geocoding engine resolves each address, corrects misspellings, fills in missing components, and returns a properly formatted result.

Download Results

View formatted addresses in a table with confidence scores. Download everything as a clean CSV file with full address components.

What This Tool Fixes

Paste any messy address data and the formatter will clean it up using Google’s geocoding engine. Here are the most common issues it resolves:

Misspellings & Typos

Corrects common spelling mistakes in street names, city names, and state abbreviations.

123 Brodway, New Yrok → 123 Broadway, New York, NY

Missing Components

Fills in missing ZIP codes, state abbreviations, and country codes based on the resolved location.

1600 Amphitheatre Parkway, Mountain View → adds CA 94043, USA

Inconsistent Formatting

Standardizes capitalization, punctuation, and spacing so every address follows the same clean format.

gran via 1 madrid → Gran Vía, 1, Madrid, Spain

Abbreviation Standardization

Converts between full names and abbreviations for streets, states, and directions consistently.

123 North Main Street → 123 N Main St

Landmark Resolution

Resolves landmarks, business names, and points of interest to their full street addresses.

Eiffel Tower → Av. Gustave Eiffel, 75007 Paris, France

Coordinate Lookup

Converts latitude/longitude coordinates into full, readable addresses via reverse geocoding.

40.7128,-74.0060 → New York, NY 10007, USA

Common questions

Is this tool free?
How many addresses can I clean at once?
What file formats are supported?
How accurate is the address formatting?

The tool uses the Google Geocoding API, the same engine behind Google Maps. It resolves each address to a precise location, corrects misspellings, and fills in missing components like ZIP codes or state abbreviations. Results match what you would see in Google Maps.
Is my data stored or shared?
Can I use coordinates instead of addresses?
What does the country hint do?

The country hint biases results toward a specific country. This is useful when your addresses are ambiguous or missing country information. For example, “Springfield” exists in many countries, so setting the hint to “United States” helps resolve it correctly. Leave it on “Auto-detect” if your addresses already include country info.
What if I need to clean thousands of addresses?

Clean Thousands of Addresses in Excel

The Excel Address Formatter works directly in your spreadsheet. One-time purchase, lifetime updates.

Get the Excel Tool