Split Columns
The Split Columns tool lets you break apart the values in a single column into two separate columns based on a chosen separator. This is useful for cases like splitting full names into first/last names, or separating values such as "City, Country".
Key Features
- Custom separator – Define the exact character or string to split on (e.g., comma, space, dash).
- Selective row start – Choose the row index to begin splitting from (e.g., skip the header row).
- Column targeting – Specify which column to split into two new columns.
- One split, two results – The value is split only on the first occurrence of the separator: the part before goes into one new column, the remainder into another.
How to Use
- Open the Split Columns dialog.
- Enter the Start Row (usually
1to skip the header row). - Enter the Column Index you want to split.
- Specify the Separator character or string (e.g.,
,or - Click Apply to create two new columns at the end of the dataset, one for each split part.
Examples
Before
| Name |
|--------------|
| Alice Smith |
| Bob Johnson |
Split on space
| Name | First | Last |
|--------------|-------|---------|
| Alice Smith | Alice | Smith |
| Bob Johnson | Bob | Johnson |
Before
| Location |
|-----------------|
| Paris, France |
| Tokyo, Japan |
Split on comma
| Location | City | Country |
|---------------|-------|---------|
| Paris, France | Paris | France |
| Tokyo, Japan | Tokyo | Japan |