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.

Processed on your device. Files are not uploaded

How to turn a list into a comma separated list

  1. Paste your list

    Paste or type it into the box, or press Try an example. One item on each line.

  2. Choose the direction and separator

    Turn lines into one list, or a list back into lines, using a comma, semicolon, pipe, tab or space.

  3. 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.

Related tools