List → Comma-Separated
Convert a list of lines into a single comma-separated string. Customizable separator and optional quoting.
About List → Comma-Separated
This tool joins the lines of your input into a single string separated by commas (or any separator you choose). Useful when you need a single-line CSV cell, a comma-separated config value, or an SQL IN list.
When to use it
- Producing an SQL IN clause from a list of IDs
- Building a single-line CSV header from a list of column names
- Creating a comma-separated tags string from a tag list
- Joining multiple values into one cell for spreadsheet paste
How it works
Lines are split on LF/CRLF and empty lines are removed. The remaining lines are joined with the configured separator. Optional quoting wraps each value in double quotes (with internal quotes doubled) for safe CSV consumption.
Examples
Default separator: ', '
apple banana cherry
apple, banana, cherry
Frequently asked questions
- What's the default separator?
- ', ' (comma followed by space). Common alternatives: ',' (no space), ';', '|', '\t' (tab).
- Are values automatically quoted?
- Only if 'Quote values' is enabled. By default, raw values are joined with the separator. Enable quoting for proper RFC 4180 CSV output.
- Are blank lines included?
- No — blank lines are dropped before joining. Otherwise the output would have empty entries like 'a,,b'.