Usage and specifications
This guide is currently available in English.
How to use this tool
Enter a delimited list and choose comma, space, tab, semicolon or pipe. The result updates when input or settings change. Use the direction arrow to switch from lines back to a delimited list.
Understanding the result
Choose whether to preserve, remove or convert quotes. Leading and trailing item spaces and surrounding square brackets may be removed; inspect the output before copying.
When to use it
Turn a short ID list into one item per line, or turn a copied spreadsheet column into a comma-separated list.
Practical tips
Test a few items first and check that your chosen separator is not part of the values themselves. Keep the original when empty fields or whitespace must be preserved exactly.
Worked examples
Comma-separated to lines
| Input / settings | Result |
|---|---|
red,green,blue | red green blue |
Lines to comma-separated
| Input / settings | Result |
|---|---|
red green blue | red,green,blue |
Specifications and limitations
- This is not a full CSV parser. Use CSV-aware software for quoted delimiters, escaped quotes or multiline fields.
- Lines-to-list conversion removes empty lines and trims each item.