CCleanMySheet

CleanMySheet guide

Split a US address column in a CSV

Split address runs on Address-like headers and only keeps new columns if enough rows match city/state/ZIP patterns. Low-confidence parses are rolled back so you do not get junk columns.

Open the cleaner

Steps

  1. Upload mailing list
  2. Apply Split address
  3. Check new Street/City/State/Zip columns

International addresses

Non-US formats often will not match. Leave the original column; do not force a split.

Related searches this page answers

  • split address excel
  • parse street city state zip csv