Skip to main content
WizTools123
Free Online Tools

Tool Categories


CSV Tools New Tool

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.

Free Forever Nothing Uploaded Both directions Many files at once
Free Online CSV Column Merger and Splitter
Share this tool
Advertisement Slot (Top Banner) Google AdSense Unit • Responsive Banner
Bulk CSV Column Merger and Splitter Your file is read inside this tab. Nothing is uploaded anywhere.
Drop the CSV files you want changed Columns are matched by name, so several files can be reshaped the same way. Choose files Up to 25 MB per file. Nothing is uploaded.
0%
Or paste it
Reading the file
What to do
Columns to join
How to join
The new column
Column to split
Split it characters
Into columns
New names
Writing the result

0 files 0 columns in 0 columns out 0 values with leftovers

Before
Nothing to show yet.
After
Nothing to show yet.
Buy Us A Coffee

Enjoying WizTools123? Help keep our server infrastructure 100% free and open for everyone.

Buy Us A Coffee
Sponsored Content (Below Tool) Google AdSense Placement

How to Use Bulk CSV Column Merger and Splitter

Step by step, start to finish.

1
Drop the files in

One or many. The chips show the columns of the current file so you can build the list by clicking.

2
Choose merging or splitting

They are opposite jobs and the options change to match. Merging asks which columns; splitting asks which column and where to cut.

3
Set the separator or the cut

For merging, what goes between. For splitting, a character, the first or last space, a fixed width, or a pattern.

4
Name the result and download

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.

Both directions

Join any number of columns into one, or split one column into as many as you need.

No double separators

Empty values are skipped when joining, so a missing middle name leaves no extra space behind.

Nothing lost off the end

A value with more pieces than you asked for can keep the remainder in the last column.

Five ways to split

A character, the first space, the last space, a fixed width, or a regular expression.

Names and placement

Name the new columns, and choose whether a merged column sits in place, at the end or at the start.

A folder at a time

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.

Because a middle name is empty and the separator goes in anyway. Switch on "skip empty values", which is the default, and the extra separator disappears.

By default the last column keeps everything that is left over, so nothing is lost. The alternative is to drop the remainder, which is occasionally what you want but should be a decision.

Yes, usually with "split on the last space", which handles "Ann van der Berg" better than splitting on the first. It is still a guess, though, and a list of real names will contain some it gets wrong.

Type the names separated by commas, in order. Leave the box empty and they are numbered after the original column instead, such as address_1 and address_2.

Your choice. Merging can keep the joined columns or replace them; splitting can keep or remove the column it split. Keeping them is safer while you are checking the result.

Yes. Columns are matched by name, so the same merge or split applies to every file, and they come back as a single zip.
Advertisement Slot (Bottom Banner) Google AdSense Unit • Responsive Banner