Papiral
PixelForge
Tabular
TabularMerge CSV Columns into One
Combine two or more columns into a single column with a separator. Great for building full names, addresses, or IDs.
What this tool does
Merging columns is a common data prep step — combining first and last name, joining city and state, or building a composite key from multiple fields. Tabular lets you select any columns, define a separator (space, comma, dash, or anything else), name the new merged column, and optionally remove the originals — all without writing formulas or code.
Problems it solves
- Combining First Name and Last Name into a Full Name column
- Joining City, State, and ZIP into a single Address field
- Building a composite key from Order ID and Product ID
- Concatenating tags or categories separated by a pipe
- Creating a slug from multiple text fields
Example
First Name and Last Name merged into Full Name with a space separator.
Before
| First Name | Last Name | Plan |
| Alice | Smith | Pro |
| Bob | Jones | Free |
After
| Full Name | Plan |
| Alice Smith | Pro |
| Bob Jones | Free |
Frequently asked questions
Can I use any separator?
Yes. Type any string as the separator — space, dash, comma, underscore, or even a multi-character string like ' - '.
Can I keep the original columns as well?
Yes. Uncheck 'Remove original columns' to keep both the originals and the new merged column.
Can I merge more than two columns?
Yes. Select as many columns as you need. They'll be joined in the order you selected them.
Is this available on the free plan?
Yes. Merge Columns is a free tool available to all users.
Related tools
Split Column
Split one column into multiple columns by a delimiter. Separate full names, addresses, or compound values into distinct fields.
Rename Columns
ProRename any column header in your CSV or XLSX file. Map old names to new ones before importing to another system.
Reorder Columns
ProChoose which columns to keep and in what order. Drop unwanted fields and reorder the rest before your import.