UlvixorSplit CSV Columns
Split a column in your CSV into several new columns based on the separator you choose (space, comma, hyphen, or a custom one), filling in empty cells when a row has fewer parts than others. Everything is processed locally in your browser, with no file ever uploaded to a server.
How it works
- Paste your CSV with a header row into the input panel (or use the built-in example).
- Select the column you want to split from the automatically detected list.
- Choose a preset separator or type a custom one.
- The tool creates as many new columns as the longest value has parts, named column_1, column_2, and so on, filling rows with fewer parts with empty cells.
- Decide whether to keep or remove the original column, then copy or download the resulting CSV.
Use cases
- Split a full-name column into separate first-name and last-name columns.
- Break a full address into street, number, and city for analysis or filtering.
- Split combined values with a separator (for example 'tag1;tag2;tag3') into individual columns.
- Break a date-and-time column into separate parts to process them individually.
Use cases
- Split a full-name column into separate first-name and last-name columns.
- Break a full address into street, number, and city for analysis or filtering.
- Split combined values with a separator (for example 'tag1;tag2;tag3') into individual columns.
- Break a date-and-time column into separate parts to process them individually.
Common mistakes
- Choosing a separator that doesn't appear in any row of the column.If no value contains the chosen separator, the tool shows an error indicating that nothing was split, instead of generating empty columns.
- Expecting the same number of new columns in every row.The tool creates as many columns as the maximum number of parts found in any row; rows with fewer parts get empty cells, so the resulting CSV stays rectangular.
- Splitting a column whose resulting name (for example address_1) clashes with an existing column.The tool detects the name conflict and asks you to rename or remove that column before splitting.
Frequently asked questions
No. Splitting columns happens entirely in your browser. Your CSV never leaves your device or gets uploaded anywhere.
The tool creates as many new columns as the maximum number of parts found in any row. Rows with fewer parts get empty cells in the extra columns, so the resulting CSV is always rectangular.
They're automatically named after the original column plus a number — for example, splitting 'address' gives you 'address_1', 'address_2', and so on.
Yes, the custom separator accepts any text, not just a single character. For example, you can use ' - ' (space, hyphen, space) as a separator if your data follows that pattern.
Alternatives
A spreadsheet has a 'Text to columns' feature, and in code split(separator) does the same thing in nearly any language. This tool applies the split to the entire CSV at once, with no need to open Excel or write a script.