Split a full address into street, city, state and zip columns
In short: Reads each address from the end: country, postal code (US ZIP and ZIP+4, Canadian, UK, Australian), state or province, then city; unit lines such as Suite 200 or Apt 4B go in their own column. Works with and without commas; rows it had to guess are flagged. Other CSV columns are kept. Limit: Addresses outside the US, Canada, Australia and the UK aren't parsed beyond comma splitting.
Paste addresses one per line or upload a CSV with an address column. Each one is split into street, unit, city, state, postal code and country, reading from the end, so 500 Oak Ave Suite 200, Portland, OR 97204 gives 500 Oak Ave, Suite 200, Portland, OR and 97204. Addresses without commas are split after the street type, and anything uncertain is flagged.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. See pricing
Sample result
7 addresses split; 1 flagged because it has no postal code.
- Split cleanly
- 6
- With a unit
- 2
- Countries read
- US, CA, UK
What this means for you
Street, unit, city, state and zip are separate columns now, with the zero in 02108 kept.
- With or without commas
- Units in their own column
- ZIP+4, Canada, UK, AU
- Guesses flagged
- Addresses
- Zip codes
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Also in: Português (Brasil) · Español
How do I check the email addresses on the same list?
- Download the split file.
- Upload it at /verify. Every email address gets a live mailbox check, and valid, risky and invalid download as separate files with your address columns kept. The first 100 email checks are free with a Google sign-in, no card.
- Use the valid file for the campaign.
How do I separate an address into columns?
- Paste one address per line, or upload a CSV; the column named address (or the one that looks like addresses) is used, and other columns are kept.
- Pick the country most addresses are in. Others are still read; their country column is filled in.
- Press Split addresses and look at the Check column for rows it had to guess, such as a city with no comma before it and no street type.
- Download the CSV with street, unit, city, state, postal_code, country and check columns added.
Example
- You enter
- 7 rows with email and address columns: US addresses with and without commas, a Suite and an Apt line, a ZIP+4, a Washington DC address ending
USA, a Toronto address and a London one. - You get
500 Oak Avenue Suite 200, Portland, OR 97204-1234gives street500 Oak Avenue, unitSuite 200, city Portland, state OR, postal 97204-1234;42 Elm Street Apt 4B Boston MA 02108splits without commas and keeps the zero; Toronto reads as ON and M5H 2S6, London as SW1A 2AA.Springfield ILis flagged: no postal code.- Limits
- Runs in your browser with no row cap; an uploaded file can be up to 25 MB.
Why doesn't Text to Columns split addresses properly?
Text to Columns splits on every comma, so 500 Oak Ave, Suite 200, Portland, OR 97204 gives four columns and 42 Elm Street Boston MA 02108 gives one; the state and zip stay stuck together either way, and Excel drops the zero from 02108. Formulas such as =TEXTAFTER(A2," ",-1) for the zip work until one row has a ZIP+4, a unit line or no commas.
This tool reads from the end instead, where addresses are most regular: an optional country, then the postal code by its shape (12345 or 12345-6789, A1A 1A1, SW1A 2AA, 3000), then the state or province by name or code, then the city. Unit designators (Apt, Suite, Ste, Unit, Floor, #) are moved to their own column. Postal codes stay text, so leading zeros survive in the CSV; open it with the CSV to Excel tool to keep them in Excel too.
What happens to addresses without commas?
The street is cut after its last street type (St, Ave, Rd, Blvd, Lane, Way and about 50 more) and an optional direction such as NW, and whatever follows is the city. 42 Elm Street Apt 4B Boston MA 02108 splits cleanly. A street with no street type, such as 1200 Calle Ocho, needs a comma before the city; without one the row is flagged rather than guessed.
Who uses this tool, and for what?
- Marketing ops
- Turn a one-column address export into the separate fields a direct-mail or CRM import needs.
- Sales ops
- Split billing or shipping addresses to segment a list by state or zip.
- Agencies
- Clean a client's event or store list into mail-merge-ready columns.
What can’t this tool tell you?
- Addresses outside the US, Canada, Australia and the UK aren't parsed beyond comma splitting.
- Without commas, a street with no street type runs into the city; those rows are flagged.
- It doesn't validate or standardise addresses against postal data (USPS CASS, Canada Post).
- It doesn't check the email addresses on the same rows. That needs a mailbox check.
Common questions
- Does it check that the address exists?
- No. It splits the text; it doesn't look anything up, correct spellings or add ZIP+4.
- Which countries does it read?
- US, Canada, Australia and the UK. Other formats come out with the street and city where commas allow and the rest flagged.
- Are states written as codes?
- Yes, as the two- or three-letter code. To switch between codes and full names, use the state abbreviation converter.
- Is my file uploaded?
- No. It's read in your browser.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.