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 CSV

Want 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
#namestreetcitystatezip
1John Smith742 Evergreen TerraceSpringfieldIL62701
2Jane Doe123 Main StAustinTX78701
3Bob Wilson456 Oak AveSeattleWA98101
After
#namefull_address
1John Smith742 Evergreen Terrace, Springfield, IL 62701
2Jane Doe123 Main St, Austin, TX 78701
3Bob Wilson456 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

Continue in the spreadsheet editor.

Use the spreadsheet editor, AI columns, and cleanup tools within the same Magic CSV account.

How to merge multiple columns into one in a CSV | Magic CSV