← All text tools

CSV Column Splitter and Merger

Split one CSV column into several by a delimiter or by fixed widths, or merge several columns into one with a joiner, keeping or dropping the originals.

  • Free
  • No sign-up
  • Works on any device

About CSV Column Splitter and Merger

Pull one column apart or glue several together without opening a spreadsheet. Splitting works on a delimiter such as a space, dash or slash (for example turning Full name into First name and Last name), or on fixed character widths for codes like 2026-03-A. Merging joins the chosen columns with a joiner you type and can skip empty values. The CSV is read with RFC 4180 rules, so quoted commas and line breaks stay inside their cells. You can keep the original columns or drop them, name the new ones, and see the first rows in a table before you download.

How to use CSV Column Splitter and Merger

  1. Paste your CSV, tick whether the first row holds names, and choose Split by delimiter, Split by widths or Merge.
  2. Pick the column, then type the delimiter, the widths or the columns to merge and the text that goes between them.
  3. Check the preview table, then copy the CSV or download it as a file.

Why use this tool?

Also known as

Frequently asked questions

What happens to names with three parts when I split on a space?

Set the largest number of parts to 2 and the last part keeps the rest, so Alan Mathison Turing becomes Alan and Mathison Turing. Set it to 0 to get a separate column for every part.

Does it break cells that contain commas in quotes?

No. Quoted cells are read as one value, and when they are written back they are quoted again only where a comma, quote or line break requires it.

Where does the merged column appear?

It takes the place of the first column you merged. If you keep the originals it is added at the end of each row instead, so nothing shifts.

Is CSV Column Splitter and Merger free?

Yes. CSV Column Splitter and Merger on Toolipedia is free to use, with no sign-up and no watermark.

Is it safe to use?

Yes. Everything is worked out in your browser, and nothing you enter is sent to our server.

Does it work on my phone?

Yes. It works in any modern browser on Android and iPhone, as well as on tablets and computers. There's nothing to install.

Do I need an account?

No. Just open the page and use the tool. There's no sign-up and no email needed.

Can I put CSV Column Splitter and Merger on my own website?

Yes. Use the Embed on your site button under the tool to copy a short piece of code and paste it into your page. It is free, needs no account, and the tool keeps working inside your page.

Related tools