Comma Separator

Paste a column of items (from Excel, Google Sheets or a text file) to turn it into one comma-separated line – or split a comma list back into lines.

How to convert a column to a comma-separated list

  1. Copy a column from Excel or Google Sheets and paste it here.
  2. Choose the delimiter and, for SQL, single quotes with brackets.
  3. Copy the one-line result.
UseSettingsResult
Plain listComma + spaceLondon, Paris, Berlin
SQL IN clauseComma, single quotes, ( … )('London','Paris','Berlin')
JSON / JavaScript arrayComma, double quotes, [ … ]["London","Paris","Berlin"]
Search queryCustom “ OR ”London OR Paris OR Berlin
Back to a columnDelimited list → columnone item per line

In Excel you can do the same with =TEXTJOIN(", ", TRUE, A1:A100); in Google Sheets use =JOIN(", ", A1:A100).

Frequently asked questions

How do I convert a comma-separated list to rows in Excel?

Choose “Delimited list → column” here, copy the result and paste it into a column. In Excel you can also use Data → Text to Columns, then transpose.

Does it handle values that contain commas?

Values wrapped in quotes are unwrapped, but commas inside them are still treated as separators. Use a different delimiter such as a tab or pipe for such data.