Help Centre › Building Processes
Split a column into multiple columns by a delimiter.
Runs on: macOS and Windows only.
Add it to a process
In the process designer, open the Add step tab. Find Split column under Excel › Columns, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| File path | Yes | Enter the file path, or use a variable such as {folder::desktop::path}\file.xlsx. |
| Sheet | Yes | Name of the sheet in the Excel file. Supports wildcards: * matches any characters. |
| Column | Yes | The name of the column to split |
| Delimiter | Yes | The character(s) to split on, e.g. comma, dash, space |
| New column names | No | Comma-separated names for the new columns. If omitted, columns are named Column_1, Column_2, etc. |
See all Excel steps.
Example
Splitting a "Full Name" column by space:
| Full Name (before) | First Name | Last Name |
|---|---|---|
| John Smith | John | Smith |
| Jane Doe | Jane | Doe |
Tips
- If cells have varying numbers of delimiters, extra columns will be blank for shorter values
- Common delimiters: space, comma (
,), dash (-), pipe (|), semicolon (;) - Use Text to columns for delimiter-based splitting of cell ranges instead of a named column