Google Sheets column to comma separated list

Copy a column in Google Sheets, paste it here, and copy the list back. The default here is a comma followed by a space, which reads well in a cell or an email.

Column to list List to column

Quick:

Your column

Options

Separator

Custom text

Quotes

Wrap list

Sort

Letter case

Before each item

After each item

Before the list

After the list

Your list

Your text never leaves your browser. Read how we handle data.

Example

This input:

Anna Lee
Ben Ortiz

Cara Singh
Anna Lee

gives this output with the settings on this page:

Anna Lee, Ben Ortiz, Cara Singh, Anna Lee

Copy a column from Sheets

Click the column letter to select the whole column, or drag over the cells you need, then press Ctrl+C (Cmd+C on a Mac). Paste into the left box. Empty cells are dropped, so a long column with gaps still gives a clean list.

Press Copy and paste the list into a cell, a document or a form field.

The formula way, and why people skip it

In Sheets, =TEXTJOIN(", ", TRUE, A2:A) joins a column with commas and spaces. It works, but the result sits in a cell that you must copy again. If the range grows, you must edit the formula, and it cannot add quotes around each value.

=ARRAYFORMULA(TEXTJOIN(", ", TRUE, UNIQUE(A2:A))) removes duplicates, but it is hard to remember. Here, you tick Remove duplicates.

Good uses

Paste a list of emails into the To field of a mail tool.
Fill a tag or keyword field that wants one line.
Build a filter for a report that accepts a comma separated list of IDs.

Questions about this page

Does the tool connect to my Google account?

No. You copy and paste. The tool never sees your sheet, only the text you paste, and that text stays in your browser.

How do I get a list without spaces after the commas?

Open the Separator menu and choose Comma. Comma + space is the default on this page.

Can it handle a column with thousands of rows?

Yes. Copy the whole column and paste it. Large pastes finish in a fraction of a second.