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
- Paste the CSV with a header.
- List the columns to join, in order.
- Set the separator and the new column name.
- 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.