Address Format Standardizer

1. Paste a table with headers into Address table data, or use Drop a CSV, TSV, or TXT file here and click browse files.
2. Map columns to Recipient / name, Street line 1, Street line 2, City / locality, State / region / county, Postal / ZIP code, Country, or Not used.
3. Set Regional layout, Line breaks, Component separator (single-line mode), Casing, Write normalized values, and Country requirement.
4. Check Standardized records and Flagged - needs review, then use Export CSV, Export Mapping Report, or the flagged section's Export CSV.

How to normalize address columns

Header names get editable role suggestions. If a role is assigned twice, the last assignment supplies it; the earlier mapped column stays unchanged. Values are trimmed before the layout is built.

The parser reads comma-separated rows and quoted fields. TSV and TXT uploads still use that parser, so tabs and other delimiters are not detected. Unexpected row widths and unterminated quoted fields are not reported.

With United Kingdom style (city, postcode last line) and Multi-line block, this input produces:

recipient,street1,city,postal,country
Jane Doe,221B Baker Street,London,NW1 6XE,United Kingdom

Jane Doe
221B Baker Street
London
NW1 6XE
United Kingdom

Address formatting options and layout rules

United States style puts city, region, and postal on one line, followed by country if present. United Kingdom style writes nonblank components on separate lines in recipient, street line 1, street line 2, city, region, postal, country order. Generic international (UPU-style, country last) puts postal before city, region after a comma, and country in uppercase. Custom order (set below) writes nonblank mapped roles one per line in your chosen order.

Single line under Line breaks joins layout lines with Comma + space ( , ), Space only, or Semicolon + space ( ; ). Multi-line block keeps lines separate. Under Casing, choose Preserve as supplied, Title Case, UPPERCASE, or lowercase. Country required - flag if missing checks for a blank country; Country optional does not.

Add normalized columns (keep originals) appends normalized_address. Overwrite mapped columns writes cased values into the mapped source columns and leaves unmapped columns as supplied. If a role is assigned twice, the earlier duplicate column stays unchanged.

When address rows are flagged

Rows appear in Flagged - needs review when Street line 1 is blank, City / locality or Postal / ZIP code is missing for the selected layout, Country requirement is Country required - flag if missing with Country blank, or a postal value fails the United States style or United Kingdom style pattern. Each row keeps original data and a reason.

The tool does not fill missing city, region, postal code, or country values. It does not geocode, query postal services, check deliverability, or correct postal values. Postal checks run only for United States style and United Kingdom style; Generic international (UPU-style, country last) and Custom order (set below) skip them.

Where address format standardization comes up

Different headers can map to the same roles across exports. Keep the original columns and append normalized_address for side-by-side review.

For one address per row, choose Single line and a separator, then use Export CSV. Flagged - needs review has its own Export CSV.

Choose the matching dataset clean tool

For table cleanup, see Dataset Clean Tools. Use Date Format Standardizer for date fields, Phone Number List Cleaner for phone fields, and Data Cleaner for CSV, TSV, Excel, JSON, JSONL, XML, or YAML tables.

Frequently asked questions