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

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.

Or paste it

Reading the file Separator First row is a header Trim spaces around values

What to do

Columns to join

How to join Between them Skip empty values, so there is no double separator Keep the original columns as well

The new column Called Put it

Writing the result Separator Quote every field Windows line endings, for Excel Add a byte order mark, so Excel reads accents

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 Merge or Split CSV Columns

A few steps, and nothing is uploaded.

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

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.

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.

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.

What to Know About Merging and Splitting

Empty values, leftovers, and why splitting a name is risky.

Skipping empty values is the fix nobody remembers to ask for. Joining first, middle and last names with a space gives "Ann Doyle" with two spaces whenever the middle name is empty, because the separator goes in regardless. Skipping empty values removes the extra, which is almost always what you want and why it is on by default.

The last piece keeping the remainder prevents silent data loss. Splitting an address on commas into three columns when one address has four commas means something must happen to the fourth piece. Keeping it in the last column loses nothing; dropping it is sometimes right, but it should be a choice rather than a surprise.

Splitting a person name on a space is a guess, not a rule. It works for "Ann Doyle" and fails for "Ann van der Berg", "Maria de los Santos" and anyone with two given names. Splitting on the last space is usually better for surnames, and either way check the result rather than trusting it on a list of real people.

Fixed width splitting is for codes, not for text. Breaking after three characters suits a reference like ABC12345 where the first three letters mean something. On a sentence it cuts a word in half, which is the point of the option and also its limit.

Merging can keep the originals or replace them. Keeping them is safer while you check the result, and it means the file still has the parts if something downstream needs them. Replacing them is tidier once you are sure.

Nothing is reformatted on the way through. A postcode keeps its spacing, a leading zero stays, and a value that looked like a number is still the same text it was.

Key Features & Capabilities

What this tool does, and what it deliberately does not.

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 the 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

Separators, blanks, limits and new column names.

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.