What does this tool do?
This tool takes a single line of delimited values — separated by commas, semicolons, pipes, or tabs — and converts it into a vertical list with one item per line. It is the reverse of the List to Comma Separated tool.
Use it to clean up CSV data, split configuration values, convert API responses, or prepare data for further processing.
Supported separators
| Separator | Example input | Common in |
|---|---|---|
| Comma | a, b, c | CSV, most APIs, config values |
| Semicolon | a; b; c | European CSV, SQL query lists |
| Pipe | a|b|c | Log files, Unix tools, PSQL |
| Tab | a\tb\tc | TSV exports, spreadsheet paste |
| Newline | a\nb\nc | Already a list — use to clean/dedup |
Options explained
- Trim — Removes leading and trailing whitespace from each item. Recommended: keeps
apple, bananafrom producingbananawith a leading space. - Remove empty — Drops blank items that result from trailing delimiters or double separators (e.g.
a,,b→ two items, not three). - Remove dupes — Keeps only the first occurrence of each value, removing duplicates from the output list.