CSV Column Merger (Join Columns into One with a Separator)

Adds a column built from several others, such as street, postcode and city joined into an address.

Use the tool

Why this tool exists

The reverse of text to columns. List the columns in order, choose the separator and name the new column. Empty values are skipped so you do not get double commas.

You can keep the original columns or drop them. The new column is added at the end. Useful for building labels, full names, search keys and mailing lines.

How to use it

  1. Paste the CSV with a header.
  2. List the columns to join, in order.
  3. Set the separator and the new column name.
  4. Copy or download the result.

Frequently asked questions

Are empty values joined?

No, they are skipped.

Can I use column numbers?

Yes, 1-based numbers or names.

Where does the new column go?

At the end.

Can I join with a new line?

Not through the separator field; use a visible separator and replace afterwards.