Column to Comma Separator

What this does

So you have copied a column of values out of a spreadsheet, and now you have a list with each item on its own line. You need it on a single line instead, separated by commas. This does exactly that. Paste the column in, hit Convert, and you get a tidy delimited list on the other side, ready to copy.

How to use it

1. Paste your column into the left box, one value per line.
2. Pick a Delimiter and, if you need them, Quotes around each value.
3. Hit Convert, then Copy Output to grab the result.

Change the delimiter or quotes and convert again to get a different format.

How it works

It splits whatever you paste into separate lines, trims the spare spaces off each value, wraps each one in your chosen quotes if you picked any, and then joins them all together with your chosen delimiter. The delimiter can be a comma, semicolon, pipe, space, or new line, and the quotes can be none, single, or double. It all runs in your browser, so nothing you paste is sent anywhere.

What people use it for

It is mostly a developer and data wrangling helper. People use it to turn a spreadsheet column into a comma separated row for a CSV, to build a list for a SQL query, where double quotes or single quotes around each value save a lot of fiddly typing, to make an array or list to drop into code, and to flatten a column of values into a single line for a config file or a search. Anywhere you have a column and need it as a separated list, it saves the manual work.

Questions people ask