Split 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.