About this tool
Split / Combine Columns is a free, in-browser tool that reshapes CSV columns without a spreadsheet. In Split mode it takes one column — chosen by header name or zero-based index — and breaks each value on a delimiter into several new columns, so 'Paris/France' becomes two fields; an optional limit caps how many pieces are produced. In Combine mode it joins several columns into a single new column using a separator you choose, optionally keeping or dropping the originals.
Everything runs locally in your browser using JavaScript — your data is never uploaded or stored. The CSV parser handles quoted fields and escaped quotes, new columns are named from the source header where possible, and the output updates live so you can copy or download the reshaped CSV.
Frequently asked questions
How do I choose which column to split or combine?
Refer to a column either by its header name (when 'first row is a header' is on) or by its zero-based index, so 0 is the first column. Combine mode takes a comma-separated list of columns; they are joined in the order you list them.
What does the split limit do?
A limit of 0 means split on every occurrence of the delimiter into as many columns as needed. A positive limit caps the number of resulting columns; extra delimiters beyond the limit stay inside the last piece, and shorter values are padded with empty cells so all rows line up.
Can I keep the original columns when combining?
Yes. Tick 'keep original columns' to append the combined column while leaving the sources in place; untick it to remove the source columns and add only the combined result at the end.
What CSV conventions are assumed?
Fields use the selected delimiter (comma, semicolon, tab or pipe), quoted fields and doubled quotes are respected on input, and any output field containing the delimiter, a quote or a newline is re-quoted. New split columns are named header_1, header_2, … from the source header.
More tools