List to Comma Separated Converter
Turn a list with one item on each line into a comma-separated list, with optional quotes, or turn a separated list back into lines.
How to turn a list into a comma separated list
Paste your list
Paste or type it into the box, or press Try an example. One item on each line.
Choose the direction and separator
Turn lines into one list, or a list back into lines, using a comma, semicolon, pipe, tab or space.
Copy or download
Paste the line into a query, a spreadsheet cell or your code.
Worked example
This is what List to Comma Separated Converter gives for its own sample values. Open the tool above and change anything to try your own.
Your list
apples oranges bananas
- Convert
- Lines into one separated list
- Separator
- Comma
- Add a space after each separator
- Yes
- Wrap each item in
- Nothing
Separated list
apples, oranges, bananas
About List to Comma Separated Converter
Turn a column copied from a spreadsheet into one comma-separated line, ready for SQL, code or an email field. You can also go the other way and turn a separated list back into lines. Blank lines are skipped and spaces are trimmed.
FAQs
Can I wrap the items in quotes?
Yes. Choose single or double quotes, which is useful for SQL IN lists.
Can I go from a comma list to lines?
Yes. Choose that direction in the options.
What happens to blank lines?
They are skipped.