List to Comma Separated Converter

Turn a column of items into a comma-separated list (with optional quotes) or split a list back into lines.

How do I convert a list to comma-separated values?

A list to comma-separated converter joins lines of text into one line with a separator (comma, semicolon, pipe or tab), optionally wrapping each item in quotes — useful for SQL, code and spreadsheets.

Two directions

Lines → comma-separated — paste a column from Excel or a list; choose the separator and quotes.
Comma-separated → lines — split a list on commas, semicolons, pipes or tabs into one item per line.

Examples

SQL: WHERE id IN ('a', 'b', 'c') — choose single quotes.
JavaScript or JSON arrays — choose double quotes.
Hashtags or tags fields — comma + space.

Frequently asked questions

Can I paste a column from Excel?

Yes, each cell becomes one line, which is then joined.

Are quotes inside items escaped?

Yes, matching quotes inside an item are escaped with a backslash.

Can it remove duplicates?

Yes, tick "Remove duplicates".