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
- Drop your CSV onto the upload area.
- Click the columns you want to combine. The order you click is the order they are joined.
- Choose the separator. A space suits names, a comma suits addresses.
- 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.
Related tools
Other tools people use alongside the Merge Columns.
- DEV-004CSV MergerCombine several CSV files into one, with a clear rule for mismatched columns.Open
- DEV-006CSV Email List CleanerRemove duplicates, catch provider typos, flag disposable and role addresses, review every change, and download a clean CSV with all your columns intact.Open
- DEV-001JSON FormatterFormat, minify and validate JSON with clear error messages.Open
Browse all developer tools or see every tool.