How to merge multiple columns into one in a CSV
You need to combine data from multiple columns into a single column, like creating a full address from separate fields or combining codes.
This guide uses the spreadsheet editor. Jev adds decision columns instead.
Open Magic CSVWant to do this with no tokens?
Use this Magic CSV tool - no signup, nothing uploaded.
Open Merge Columns tool →spreadsheet editor example
Prompt
"Merge street, city, state, zip into a single address column"
Before
| # | 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 |
After
| # | name | full_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 |
Why use the spreadsheet editor for this?
- Combine any columns with custom separators
- Create composite fields for reports
- Simplify data structure for imports
Related guides
- Merge First and Last Name
Combine first, middle, and last names
Continue in the spreadsheet editor.
Use the spreadsheet editor, AI columns, and cleanup tools within the same Magic CSV account.