Column to Comma

How to turn a column into a comma separated list

Copy the cells and paste them on the left. The comma list appears on the right as you type.

Nothing to choose. If the text has more than one line it is a column, so it gets joined. If it is one line with commas in it, it is a list, so it gets split. Convert back does the return trip on the result.

Why this is a tool and not a formula

Because the formula is annoying enough that people search for this instead.

In a spreadsheet you need TEXTJOIN(", ", TRUE, A1:A200) in a spare cell, then you copy that cell, and then you find it has come across with quotes around it because the result contains commas. In a text editor you need a find and replace on the newline, which most editors will not do without regex mode.

Neither is hard. Both are three steps and a lookup, for something you want a hundred times a year.

What gets cleaned up on the way

Blank rows go. A pasted column almost always has empty cells in it, from a filtered range or a gap in the data, and an empty entry in a list is either noise or an error further down.

Padding goes. Cells arrive with uneven leading and trailing spaces, especially from an export. A list with bob@acme.com in it fails a lookup that bob@acme.com would have passed, and the difference is invisible.

A trailing comma goes. Splitting red, green, blue, gives three items, not four with an empty one at the end.

When both directions look possible

Line breaks win.

Text with several lines that also contain commas is treated as a column and joined into a single list. The alternative is guessing at a ratio of commas to newlines, which is less predictable and fails in exactly the confusing way.

If what you actually have is a CSV with rows and columns, this is the wrong tool: it will flatten the whole thing into one line.

What usually comes next

A list assembled from several columns tends to repeat itself. The duplicate line remover strips those and tells you which entries appeared more than once, which is easier to read in column form, so do it before converting.

If the column came out of a document rather than a spreadsheet, it may still have bullets on it. The list cleaner takes those off.

Everything runs in your browser. Nothing is uploaded.