Use the input methods and map columns
Paste comma-separated data with a header row into the text area, or drop a CSV, TSV, or TXT file into the upload area. You can also click browse files. The columns are detected automatically as soon as the data is available.
Map each address role once
Assign source columns to Recipient / name, Street line 1, Street line 2, City / locality, State / region / county, Postal / ZIP code, Country, or Not used. Header suggestions are editable, and columns left as Not used stay unchanged.
Assign each role to no more than one source column. If you map a role more than once, only the last assigned source column is retained for that role; earlier duplicate-mapped columns remain unchanged.
Choose the output layout and line order
Choose United States style (city, state abbr, ZIP), United Kingdom style (city, postcode last line), Generic international (UPU-style, country last), or Custom order (set below). The regional presets use fixed grouping rules. The United States layout uses the supplied region value; it does not create a state abbreviation.
Set Multi-line block or Single line. For a single line, choose Comma + space ( , ), Space only, or Semicolon + space ( ; ). Custom order reorders seven fixed roles with the move controls. It does not select or deselect components; each nonblank mapped component is written on its own line.
Set casing, country handling, and write mode
Choose Preserve as supplied, Title Case, UPPERCASE, or lowercase. With Generic international (UPU-style, country last), the country line is forced to uppercase after the selected casing is applied.
Choose Country optional or Country required - flag if missing. For output, select Add normalized columns (keep originals) to append one normalized_address column, or Overwrite mapped columns to replace values in the source column retained for each mapped role. Unmapped columns remain unchanged.
Standardize, review flags, and export
Processing starts automatically when the input and settings are ready. Successful rows appear under Standardized records. Rows with no usable Street line 1, missing required components, a missing required country, or an unusual postal shape appear under Flagged - needs review instead.
Postal-shape checks apply to United States style (city, state abbr, ZIP) and United Kingdom style (city, postcode last line). They do not apply to Generic international (UPU-style, country last) or Custom order (set below). Unusual US or UK postal values are flagged, not corrected.
Use Export CSV under Standardized records for successful rows or the separate Export CSV under Flagged - needs review for flagged rows. Use Export Mapping Report for the mapping, settings, and normalized values from successful rows.
Understand parser limits and validation boundaries
Mapped field values are trimmed at the beginning and end. The parser expects comma-separated data and treats the first parsed row as headers. Although the upload area lists CSV, TSV, and TXT, the parser does not detect tabs or other delimiters.
The parser does not report malformed row widths or unterminated quoted fields. If columns load incorrectly, check the delimiter, header row, quotes, and row shape before mapping.
This tool re-formats supplied components. It does not geocode addresses, validate deliverability, infer missing facts, or correct unusual postal values. Use a separate address validation service when you need deliverability checks.
Frequently asked questions
Does this validate or verify that an address is deliverable?
No. This tool only re-formats the address components you already supplied - it does not geocode, query postal services, or confirm that mail or packages would actually be delivered. Records that look incomplete are flagged for your review, not confirmed or corrected.
Will it fill in a missing city, state, or postal code?
No. The tool never infers missing address facts. If a required component is blank for the layout you selected, the record is flagged for review instead of being guessed or filled in.
How is this different from an address validator?
An address validator checks a single address against postal or geocoding data to confirm it exists and is deliverable. This tool standardizes the presentation of address components you supply across a whole list - order, separators, casing, and line breaks - and never claims deliverability.
Can I keep my original columns?
Yes. Choose Add normalized columns (keep originals) to keep the original columns and append normalized_address, or choose Overwrite mapped columns to replace only the mapped address fields.