Free Online CSV Column Merger and Splitter
Join several columns of a CSV into one, or split one column into several, in your browser. Empty values do not leave double separators behind, which is the usual fault when joining a middle name. Splitting can break on a character or at a fixed position, and the last piece can keep everything that is left over.
| Nothing to show yet. |
| Nothing to show yet. |
Enjoying WizTools123? Help keep our server infrastructure 100% free and open for everyone.
How to Use Bulk CSV Column Merger and Splitter
Step by step, start to finish.
One or many. The chips show the columns of the current file so you can build the list by clicking.
They are opposite jobs and the options change to match. Merging asks which columns; splitting asks which column and where to cut.
For merging, what goes between. For splitting, a character, the first or last space, a fixed width, or a pattern.
A merged column gets one name; split columns get a list of names, or are numbered if you leave it empty.
Key Features
What this tool does, and what it does not do.
Join any number of columns into one, or split one column into as many as you need.
Empty values are skipped when joining, so a missing middle name leaves no extra space behind.
A value with more pieces than you asked for can keep the remainder in the last column.
A character, the first space, the last space, a fixed width, or a regular expression.
Name the new columns, and choose whether a merged column sits in place, at the end or at the start.
The same reshaping across every file, matched by column name, out as one zip.
About Bulk CSV Column Merger and Splitter
Two systems almost never agree on how finely to divide a piece of data. One holds a full name, the next wants first and last separately. One holds a single address field, the next wants street, town and postcode in their own columns. Getting from one shape to the other is the most routine data job there is, and the one most likely to be done by hand in a spreadsheet with a formula nobody can read a month later.
The failures are small and consistent. Joining columns with a separator leaves a double separator wherever a value was empty, so a list of names quietly acquires double spaces, and a later exact match fails. Splitting into a fixed number of columns throws away anything past the last one, so the one address with an extra comma loses its postcode and nobody notices because the other nine hundred are fine.
Both are easy to avoid once stated plainly, which is why they are the defaults here rather than options buried at the bottom. The harder truth, which no tool can fix, is that splitting a human name on spaces is guesswork. It is offered because people need it, with the first space and last space variants that work more often, and with the plain warning that a list of real names will contain people it gets wrong.
Frequently Asked Questions
Common questions about this tool.