Column Merger
Combine multiple columns into one new column using a template — like merging first and last name into a single full-name field.
Use {ColumnName} to reference a column. Example: {First} {Last}
How to use Column Merger
- Start by providing the required input: Drop a CSV file.
- Set the inputs and options shown here: Columns available, New column name, Template, Remove source columns after merging.
- Follow the format note: Use {ColumnName} to reference a column. Example: {First} {Last}
- Run the tool with Merge & Preview.
- Review the results, then choose an output control: Download CSV.
Combining first and last name without a spreadsheet formula
Merging two or more columns into one — first and last name into a full name, city and state into one address line — normally means writing a CONCATENATE formula and dragging it down every row. Defining a simple template with column placeholders does the same thing across an entire file in one step.
Writing a template that reads naturally
A template like {First} {Last} inserts a literal space between the two column values; any plain text in the template (spaces, commas, dashes) is kept exactly as written, so you control the exact formatting of the merged result.
Can I merge more than two columns?
Yes — reference as many columns as you want in the template, in any order, with any separators between them.
What happens to the original columns after merging?
They're kept by default; check "Remove source columns" if you want the output to contain only the new merged column instead.
What if a referenced column is empty for some rows?
It's simply treated as blank text in that position — the rest of the template still applies normally around it.