Data Tools Platform

CSV Column Merger

Merge two CSV columns into a new one.

What this tool helps you do

This tool merges two CSV columns into a new single column. It is useful when you want to combine separate fields like first name and last name into one value before exporting or importing data.

Common use cases

Combine first name and last name into a full name column.
Prepare CSV files for systems that require a single field instead of two separate ones.
Simplify exported datasets before sharing them.
Standardize file structure before importing into another platform.

Part of these categories

CSV Tools

Related guide

How to Merge CSV Columns

Learn how to merge multiple CSV columns into a single column for formatting, reporting, or exporting structured data.

Read the guide

What this tool does

This tool merges two CSV columns into a new single column. It is useful when you want to combine separate fields like first name and last name into one value before exporting or importing data.

How to use it

  1. Upload your CSV file.
  2. Enter the merge instruction using this format: column1,column2=newColumn.
  3. Click the "Run tool" button.
  4. Download the merged CSV file.

Example

Input:

first_name,last_name,age
Maca,Soto,30
Ana,Perez,25
Jose,Rojas,28

Output:

full_name,age
Maca Soto,30
Ana Perez,25
Jose Rojas,28

Common use cases

  • Combine first name and last name into a full name column.
  • Prepare CSV files for systems that require a single field instead of two separate ones.
  • Simplify exported datasets before sharing them.
  • Standardize file structure before importing into another platform.

Important notes

  • This version merges exactly two columns.
  • The two original columns are removed after merging.
  • The new merged column is inserted where the first selected column was located.
  • Values are joined with a space.

FAQ

What format should I use?

Use this format: column1,column2=newColumn. For example: first_name,last_name=full_name.

Does the tool keep the original columns?

No. This version removes the two original columns and replaces them with the new merged column.

Can I merge more than two columns?

Not in this first version. This tool currently supports merging exactly two columns.

Related tools