Comma-Separated → List
Split a comma-separated string into one value per line. Trims whitespace by default.
About Comma-Separated → List
This tool splits a single-line (or multi-line) input on a chosen separator and emits one value per line. It's the inverse of list-to-csv. The default separator is a comma; common alternatives are semicolon, pipe, or tab.
When to use it
- Turning an SQL IN clause back into a workable list
- Splitting comma-separated tags into per-line entries
- Converting CSV values into a numbered list
- Extracting items from a single-line config value
How it works
The input is split on the configured separator. Each resulting value can optionally be trimmed of leading/trailing whitespace. Empty values are skipped by default.
Examples
apple, banana, cherry
apple banana cherry
Frequently asked questions
- Does it handle RFC 4180 quoted CSV?
- No — this tool does a simple split on the separator. For quoted CSV with embedded commas, use the JSON ↔ CSV tool or the CSV ↔ TSV tool, both of which handle quoting.
- Are leading/trailing spaces removed?
- Yes by default. Disable the trim option to preserve them.
- Are empty values kept?
- No — consecutive separators (',,') don't produce empty lines. Disable the skip-empty option to preserve them.