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.
| Use | Settings | Result |
|---|---|---|
| Plain list | Comma + space | London, Paris, Berlin |
| SQL IN clause | Comma, single quotes, ( … ) | ('London','Paris','Berlin') |
| JSON / JavaScript array | Comma, double quotes, [ … ] | ["London","Paris","Berlin"] |
| Search query | Custom “ OR ” | London OR Paris OR Berlin |
| Back to a column | Delimited list → column | one item per line |
In Excel you can do the same with =TEXTJOIN(", ", TRUE, A1:A100); in Google Sheets use =JOIN(", ", A1:A100).
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.
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.