Clean

Parse unstructured street addresses into street, unit, city, state, and postal code columns

Split unformatted postal addresses into clean structured address columns.

🛡️ Your rows never leave your browser.

Why Onfyt: Extracts secondary unit identifiers (Apt, Ste, Unit) into their own column instead of leaving them attached to the street line.

Interactive Sample Data

id	full_address
1	742 Evergreen Terrace, Apt 4B, Springfield, OR 97477
2	10 Downing Street, Westminster, London SW1A 2AA
3	PO Box 4501, Suite 200, Austin, TX 78701

How this tool works

Free-form address strings collected from web forms, invoice footers, or CRM exports pack street number, street name, unit, city, administrative region, postal code, and country into one cell. Downstream systems—postal APIs, route-optimisation engines, mapping dashboards—need each component in its own column. Splitting by comma or space fails the moment an address contains a comma in the unit field ("Suite 3, Building B") or a two-word city name. Because address syntax varies drastically across countries and users omit commas or misspell state abbreviations, regex-based address parsing requires careful heuristics. DataFix inspects common postal patterns, extracts leading street numbers and directional markers (North, NW), isolates secondary unit indicators (Apt, Ste, Bldg, Unit), and matches trailing tokens against known state abbreviations and postal code formats (5-digit US ZIP, ZIP+4, and UK alphanumeric postcodes). All tokenization runs locally inside your browser session using fast string segmentation algorithms. Discrete fields for postal code, street, and municipality ensure address payloads validate against carrier delivery rules.

Things that usually go wrong

Freeform address text is inherently ambiguous — the parser uses heuristics and may misclassify components for non-standard formats.
Addresses outside the US/UK/Kenyan formats may need manual review.

Edge cases we tested

🧪 Secondary unit markers (Apt, Suite, Unit, Fl, Ste)

Isolated into the unit column rather than corrupting the city name.

🧪 ZIP+4 hyphenated postal codes ('97477-1234')

Preserved in full without truncation to five digits.

🧪 P.O. Box addresses without street names

Classified cleanly as primary address line without throwing parsing errors.

Frequently Asked Questions

What address formats are supported?

US (123 Main St, Suite 400, New York, NY 10001), UK (123 High Street, London, W1A 1AA), and East African formats (Plot 42, Ngong Road, Nairobi, Kenya).

Can I recombine the parts?

Use the Add a Calculated Column tool to concatenate: street + ', ' + city + ', ' + country

Related tools

Clean

Split Full Name into First and Last

Separate full name columns into dedicated first_name and last_name columns in CSV and Excel spreadsheets.

Open Tool →

Clean

Combine First and Last Name

Merge separate first and last name columns into a single clean full_name column, trimming extra spaces.

Open Tool →

Clean

Remove Duplicate Rows

Eliminate duplicate rows across your entire dataset or based on specific unique key columns.

Open Tool →