Address Formatting and Standardization Tool

The Address Standardization Tool turns messy address data into a consistent format. Upload a spreadsheet or paste address rows, map the address columns, choose automatic or custom formatting, and download standardized address results as CSV.

Use it for lists from forms, customer files, orders or old systems. Not sure what a clean address looks like? Read our guide to address formatting. Up to 2,500 addresses are free in your browser. Bigger files run as a paid background job.

Upload a fileSelect an Excel, CSV file, or text from your computer
Copy & PasteCopy and paste addresses from a list or table

After uploading your file, map the street, house number, city, postcode, country, and other address columns. The tool keeps your original data and adds standardized address output that is easier to compare, import, and reuse.

How Address Standardization Works

The tool puts every address into the same clean shape: the same capital letters, the same order of parts, and a postcode where one was missing.

Free Standardization Workflow

Up to 2,500 addresses

Best for quick cleanup, previews, and smaller address lists

  1. 1

    Upload or paste

    Add an XLSX, CSV, or TXT file, or paste addresses directly.

  2. 2

    Map columns

    Match street, house number, city, postcode, country, and other fields.

  3. 3

    Standardize rows

    Run automatic formatting or apply a custom address format.

  4. 4

    Download results

    Review standardized fields and download the CSV.

Paid Standardization Workflow

More than 2,500 addresses

Use background processing for larger address files

  1. 1

    Upload full dataset

    Add the complete file you want to standardize.

  2. 2

    Map columns

    Match address fields and keep any reference columns.

  3. 3

    Submit paid job

    Confirm row count, review the price, and submit.

  4. 4

    We process it

    The standardization job runs in the background.

  5. 5

    Receive results

    Get an email with the CSV download link.

Address Formatting: Automatic or Custom

Leave the format field blank to use automatic formatting, or define a custom output format with placeholders. A placeholder is a word in % signs that the tool replaces with a part of the address.

Automatic format. Each address follows the style of its own country. In one test list, the tool wrote 350 5th Avenue for New York, but Unter den Linden 77, 10117 Berlin for Berlin, and filled in the missing Berlin postcode.

Custom format. Every row gets the same layout. This is useful when another program, such as a mail merge for labels, expects one fixed layout. With the format %street% %housenumber%, %postcode% %city%, %country_code%, the same test list came out like this:

BeforeAfter
unter den linden 77 berlinUnter den Linden 77, 10117 Berlin, de
5 av. anatole france 75007 parisAvenue Anatole France 5, 75007 Paris, fr
350 5th ave , new york NY5th Avenue 350, 10118 New York, us

This layout fits Germany, but not the US or France, where the house number comes first. A custom format uses one order for every row, so build it in the order of your country.

Examples:

%name%, %street% %housenumber%, %postcode% %city%, %country_code%
%country%, %postcode%-%city%, %street% %housenumber%

Common placeholders include %name%, %housenumber%, %street%, %suburb%, %district%, %postcode%, %city%, %county%, %county_code%, %state%, %state_code%, %country%, and %country_code%.

You may also need

If you need to validate address quality, verify real-world matches, or convert standardized addresses to coordinates, these related tools can help.

Address ValidationCheck address structure, missing fields, and quality warnings.Try nowAddress VerificationConfirm whether addresses can be matched to real-world locations.Try nowAddress to Lat LonConvert addresses into latitude and longitude coordinates.Try nowReverse Address LookupLook up structured address details, coordinates, and map context.Try now

Frequently Asked Questions

What is address formatting?
Address formatting means writing every part of an address in the right order and style for its country. For example, the US puts the house number before the street, and Germany puts it after. Our address formatting guide shows examples.
How do I format addresses for labels or a mail merge?
Use a custom format, so every row gets the same layout. For example, %housenumber% %street%, %city% %postcode% writes the house number first, then the street, the city, and the postcode.
Is the Address Standardization Tool free to use?
Yes. You can standardize up to 2,500 address rows per run for free in your browser. Larger files can be processed as paid background jobs.
What does address standardization do?
Address standardization turns inconsistent address data into a consistent format. It can normalize casing, reorder address components, format postal codes, and create standardized output fields for each row.
What files can I upload?
Upload XLSX, CSV, or TXT files, or paste addresses directly. Clear columns such as street, house number, city, postcode, and country make mapping faster.
Can I use a custom address format?
Yes. Leave the format field empty for automatic formatting, or define a custom format with placeholders such as %street%, %housenumber%, %postcode%, %city%, and %country%.
Can I standardize international addresses?
Yes. Include a country column when possible, or choose a default country before processing. This helps the tool apply local address conventions and return clearer formatted output.
Are my original columns preserved?
Yes. Your original columns stay in the output next to the standardized address fields, so IDs, customer references, source fields, and notes remain available in the downloaded CSV.
What happens when a row cannot be standardized?
Rows that cannot be standardized remain in the result file with empty or partial output fields and notes that explain what should be reviewed.
When should I use address validation instead?
Use address validation when your main goal is checking missing fields, address quality, and whether a row needs review before use.