Skip to content
Really Cool Online Tools logoReally Cool Online Tools

DEV-005

CSV Column Merger

Mailing lists and exports arrive with the name split across two or three columns, and the system you are feeding wants one. This joins any columns you pick, in the order you pick them, with whatever separator you choose, and shows you the first five results before you commit.

  • Free
  • No signup
  • Private · runs locally

The file is read in your browser and never uploaded.

How to combine columns

  1. Drop your CSV onto the upload area.
  2. Click the columns you want to combine. The order you click is the order they are joined.
  3. Choose the separator. A space suits names, a comma suits addresses.
  4. Decide whether the original columns stay or are replaced, then download.

The two settings that matter more than they look

Trim spaces is on by default, and it is the reason merged names come out as "Ana Silva" rather than "Ana Silva". Exported data very often carries trailing spaces that nobody notices until two fields are joined and the gap doubles.

Skip empty values is the other one. Joining a first name, a middle name and a last name when the middle name is blank produces "Ana Silva" with a missing piece in the middle. Skipping empty values closes the gap instead of leaving a stray separator.

Quoting is handled for you

If a value you join contains the separator used by the file, the result is wrapped in quotes so it stays one field. Joining a street and a city with a comma, in a comma separated file, is the usual way to break a CSV, and here it does not.

Frequently asked questions

Is my file uploaded?

No. It is read, changed and saved entirely in your browser.

Can I combine more than two columns?

Yes, as many as you like. They are joined in the order you click them, which the buttons number as you go.

Can I keep the original columns?

Yes, there is a checkbox for it. By default the combined columns are replaced by the new one, which is what most imports want.

What if a column name has a duplicate?

Columns are identified by position here, not by name, so duplicate headings are not a problem. The buttons show the heading and its position.

Read more

Background on when and why to use this.

Other tools people use alongside the Merge Columns.

Browse all developer tools or see every tool.