Unstructured Text
Comma Separated to List
Split comma separated text into a tidy list with one item per line.
When to use it
Typical uses: Turning a tag field into a list; Splitting email recipient lists; Pasting CSV values into a spreadsheet column.
In a pipeline
Text InputComma Separated to ListText Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Text column | select | — | Text |
| Delimiter | text | — | , |
| Results | select | — | lines |
| Generate New Column | checkbox | — | false |
| New Column Name | text | — | Default: <column> Result |
| Insert After | select | — | After the column |
Example
Comma Separated to List: an example
| Text |
|---|
| apples, "pears, green", bananas,, "a ""quoted"" word" |
| Text |
|---|
| apples pears, green bananas a "quoted" word |
Worth knowing
- Can I split by semicolons or pipes? Yes. Enter the delimiter you need.
- How are quoted values handled? Text inside double quotes is kept together, and doubled quotes inside it become a single quote character.
- Can I sort the list afterwards? Yes. Use Sort Lines A–Z.
- Works on any text column, not only Text Input's: pick it under Text column. Tick Generate New Column to keep the original next to the result.