Merge Columns

Merge two or more columns of a CSV or Excel table into one. Choose columns by number, letter or name, join with any separator or build values with a template.

  • Free, no sign-up
  • Runs in your browser
  • Your data stays private

How to use the Merge Columns

  1. Paste your table with a header row.
  2. Choose the columns, a separator, or a template like {First} {Last}.
  3. Copy the merged table.

Why use this Merge Columns

  • Template modeWrite {First} {Last} ({City}) and each row is filled in.
  • Flexible column picksUse numbers, letters, ranges such as 1-3, or header names.
  • Keep or replaceReplace the originals, keep them, or output only the merged column.
  • Skips blanksEmpty cells are skipped so you do not get double spaces.

Frequently asked questions

How do I combine first name and last name columns?

Enter 1,2 or First,Last in "Columns to merge" and use a space as the separator.

Can I merge with custom text between values?

Yes. Use a template such as "{City}, {Country}".

Can I output Excel-friendly text?

Choose Tab as the output format and paste the result into Excel.

Related tools

More Spreadsheet & CSV tools

User Reviews

–
No ratings yet
Write a review
Your rating *

Your email is never published. Reviews are moderated, and links aren't allowed.

What users are saying

No reviews yet

Be the first to share your experience with this tool — your feedback helps others.