How to split address into separate columns in a CSV
Your CSV has full addresses crammed into a single column, but you need street, city, state, and zip in separate fields. Manually parsing thousands of addresses is error-prone and tedious.
Want to do this right now, free?
Use the free in-browser tool — no signup, nothing uploaded.
Open free Split Column tool →See it in action
Prompt
"Split the address into street, city, state, and zip columns"
Before
| # | name | address |
|---|---|---|
| 1 | John Smith | 742 Evergreen Terrace, Springfield, IL 62701 |
| 2 | Jane Doe | 123 Main St, Austin, TX 78701 |
| 3 | Bob Wilson | 456 Oak Ave, Seattle, WA 98101 |
After
| # | name | street | city | state | zip |
|---|---|---|---|---|---|
| 1 | John Smith | 742 Evergreen Terrace | Springfield | IL | 62701 |
| 2 | Jane Doe | 123 Main St | Austin | TX | 78701 |
| 3 | Bob Wilson | 456 Oak Ave | Seattle | WA | 98101 |
Why use Magic CSV for this?
- Split any address format into clean, separate columns
- Works with US, international, and messy address formats
- No formulas or regex required
Related guides
- Split Full Name into First and Last
Automatically separate first, middle, and last names
Ready to transform your data?
Upload your CSV, describe what you want, get clean data back.