Mixed-delimiter split with a whitespace toggle
Comma, semicolon, and pipe always split. The `Split on whitespace too` toggle (on by default) adds whitespace runs to the split set - so `a, b; c|d e f` splits into six items. Turn the toggle off and `Apple Pie, Banana Bread` comes out as two items instead of four, preserving the space inside each name.
Consecutive delimiters collapse cleanly: `a,,b` yields two items (`a`, `b`), not three. Empty tokens are filtered out regardless of which delimiter created them. Leading or trailing delimiters also produce no empty rows.
This is the fast-path tool for the common case: paste a comma-separated line, get a list. For a user-supplied separator (any string, any regex), use Split a list - that is the power-user version with a Split-on field. For the reverse direction (one-per-line into a single row), use Convert to columns with N=1 or Join with your chosen separator.
How to use convert list items into rows
- 1Paste delimited input into the input panel
- 2Leave `Split on whitespace too` on for the classic "any delimiter" split
- 3Turn it off if your items contain internal spaces you want to keep (e.g. `Apple Pie`)
- 4Output updates live - one item per line, empty tokens dropped
- 5Copy or download the result
Keyboard shortcuts
Drive ListShift without touching the mouse.
What this tool actually does
Multi-delimiter split with one toggle. Fast path for common mixed-delimiter input.
Always splits on `,`, `;`, and `|`
Any run of one or more of these three punctuation delimiters is a split boundary. Good for the common mixed-delimiter case: `a, b; c|d` splits into four items regardless of the whitespace toggle.
Whitespace toggle controls the footgun
On (default) adds whitespace runs to the delimiter set - spaces, tabs, and newlines all split. That is the behaviour most people expect when pasting mixed text like `a b, c d`. Turn off when your items are multi-word (`Apple Pie`, `City of Industry`) and only the punctuation should split them.
Empty tokens dropped
Consecutive delimiters do not produce blank rows. `a,,b` yields `a` + `b`. Leading and trailing delimiters produce no empty rows either.
How this differs from Split a list
This tool = one toggle, four fixed delimiters, zero regex. Split a list takes a user-supplied separator string or regex and gives you full control. Use this page when the classic "split by anything" behaviour matches your input; use Split a list when you need to target a specific delimiter or pattern.
Inverse: convert to columns
Convert to columns takes one-per-line input and regroups into N-column tab-separated rows - the opposite direction of this tool.
Worked example
Default `Split on whitespace too: on`. Every comma AND every space inside an item counts as a delimiter, so `Apple Pie` becomes two separate rows. Turn the toggle off and the output would be three rows instead: `Apple Pie` / `Banana Bread` / `Cherry Tart`.
Apple Pie, Banana Bread, Cherry Tart
Apple Pie Banana Bread Cherry Tart
Settings reference
One toggle. The three punctuation delimiters (`,`, `;`, `|`) always split.
| Setting or input shape | What happens | Example |
|---|---|---|
| Split on whitespace too: on (default) | Whitespace runs split in addition to the three punctuation delimiters | `Apple Pie, Banana Bread` → `Apple` / `Pie` / `Banana` / `Bread` |
| Split on whitespace too: off | Only `,`, `;`, `|` split; whitespace inside items is preserved | `Apple Pie, Banana Bread` → `Apple Pie` / `Banana Bread` |
| Comma-separated: `a, b, c` | Splits on the comma (toggle-independent) | `a` / `b` / `c` |
| Semicolon or pipe: `a;b|c` | Splits on any punctuation delimiter in the set | `a` / `b` / `c` |
| Consecutive delimiters: `a,,b` | Empty tokens dropped - no blank rows | `a` / `b` |