How to Turn a List into a Comma-Separated String
You have a column of values - tags, IDs, names - and need them as a single comma-separated line for a spreadsheet formula, a config value, or a report. Joining dozens of lines with commas by hand, and getting the quoting right for any value that itself contains a comma, is fiddly to do manually. Paste the list here and it joins instantly.
Join your list now. Free, no account needed.
Open List Format Converter →How to do it
- Paste your list into the converter. One value per line.
- Select CSV Row from the format dropdown.
- Set the delimiter, if not a comma. Semicolon, pipe, and tab are common alternatives.
- Copy the single-line output.
A list like this:
apple banana cherry
becomes:
apple,banana,cherry
Values that contain the delimiter
If a value already contains a comma - a name written "Smith, John", or a description with commas
inside it - joining naively would break the result into the wrong number of fields when someone
later splits it back apart. The converter handles this by wrapping any such value in double
quotes automatically: Smith, John becomes "Smith, John" in the joined string. Values with no comma, quote, or
line break are left unquoted, keeping the output as compact as possible.
If a value contains a double quote itself, it's escaped by doubling it - the standard CSV convention, the same one Excel and Google Sheets use for their own CSV exports. This means the result can always be split back apart correctly, even with tricky data.
Choosing a different delimiter
A comma is the default, but not always the right choice - if your values themselves regularly
contain commas, a semicolon or pipe (|) delimiter avoids most of the
quoting altogether. A tab delimiter (TSV format) is a good choice when pasting straight into a
spreadsheet, since most spreadsheet apps split pasted tab-separated text into columns
automatically.
Going the other way: string back to a list
Paste a comma-separated (or other delimiter) line into the input and the tool detects it automatically, splitting it back into one value per line - correctly handling any quoted values that contain the delimiter itself.
Need other formats from the same list?
JSON array, SQL IN clause, Markdown, HTML list: 21 formats, same tool.
Frequently Asked Questions
How do I turn a list into a comma-separated string?
Can I use a different delimiter, like a semicolon or pipe?
What happens if one of my values already contains a comma?
Smith, John becomes "Smith, John" in the output. Values without a comma, quote, or line break are left unquoted.What if a value contains a double quote?
He said "hi" becomes "He said ""hi""" in the joined output. This is the same escaping Excel and Google Sheets use, so the result imports cleanly elsewhere.