Comma Separator
Convert a column list to comma-separated values — or split a comma-separated list back into lines. With options for custom delimiters, quoting, and removing duplicates.
Direction
Options
Frequently Asked Questions
- How do I turn a column list into a comma-separated list?
- Choose the "Lines to comma-separated" direction, paste one item per line, and click Convert. Every line is joined into a single comma-separated string you can copy.
- Can I use a delimiter other than a comma?
- Yes. The delimiter field accepts any characters — a semicolon, a pipe, " | ", or anything else. The same delimiter is used when splitting a separated list back into lines.
- What does the "wrap items in quotes" option do?
- It wraps every item in double quotes, producing output like "apple", "banana", "cherry" — handy for SQL IN clauses, JSON arrays, and code.
- Can I remove duplicate items while converting?
- Yes. Tick the "remove duplicates" checkbox and repeated items are dropped, keeping only the first occurrence of each.
- How do I convert a comma-separated list back into lines?
- Choose the "Comma-separated to lines" direction. The tool splits your text on the delimiter, trims the whitespace around each item, and puts each one on its own line.