Column to Comma Separated List

Turn a column of values into a comma separated list, and back

Free, no signup. Runs entirely in your browser — files stay on this device.

Column to comma separated at a glance

InputValues one per line, such as a column copied from Excel or Google Sheets
SeparatorsComma + space (default), comma, semicolon, pipe, tab or space
QuotesNone, double ("a") or single ('a'); a quote inside a value is doubled, as SQL and CSV expect
WrapNone, ( … ) for a SQL IN list, or [ … ] for an array
Clean-upTrim spaces and skip blanks on by default; remove duplicates (first copy kept) optional
ReverseList → column splits on a detected or chosen separator and keeps commas inside double quotes

Paste a column of values, one per line, and get them back as one comma separated line. Copy a column straight from Excel or Google Sheets, or paste any list.

Choose comma, comma and space, semicolon, pipe, tab or space between values; wrap each value in double or single quotes for SQL IN clauses and code; and put the whole list in parentheses or brackets. Blank lines are skipped and spaces trimmed, and duplicates can be removed. Switch the direction to split a comma separated list back into a column.

The conversion happens as you type, in your browser. Nothing is uploaded.

How to Convert Column to Comma Separated List

  1. Copy a column from Excel or Google Sheets, or any list with one value per line
  2. Paste it into the left box
  3. Pick the separator, quotes and wrap you need
  4. Copy the comma separated list from the right box, or download it as .txt

Features

  • Column to comma separated list, and list back to column
  • Six separators, including comma with or without a space
  • Optional double or single quotes, with quotes inside values escaped
  • Wrap the list in ( ) for SQL IN or [ ] for arrays
  • Trim spaces, skip blanks and remove duplicates
  • Live result with copy and .txt download
  • Runs entirely in your browser, no upload or signup

Use Cases

  • Build a SQL WHERE id IN (…) list from a spreadsheet column
  • Paste a list of emails into the To field of an email
  • Turn a column of tags or keywords into one comma separated line
  • Split a comma separated list from a form or export into a column for Excel

Frequently Asked Questions

How do I convert a column to a comma separated list?

Copy the column from Excel or Google Sheets, paste it into the left box, and the comma separated list appears on the right. Click Copy to put it on your clipboard.

How do I make a list for a SQL IN clause?

Set Quotes to Single and Wrap to ( … ). A column of 101, 102 and O'Neil becomes ('101', '102', 'O''Neil'), with the apostrophe doubled as SQL requires.

Can I do this in Excel instead?

Yes: in Excel 2019 and Microsoft 365, =TEXTJOIN(", ", TRUE, A1:A100) joins a range with comma and space and skips blanks. This page is quicker for a one-off list, and it can add quotes and remove duplicates at the same time.

How do I turn a comma separated list back into a column?

Switch Direction to List → column and paste the list. Each value goes on its own line, ready to paste into a spreadsheet column. Values in double quotes may contain commas.

Is my data uploaded?

No. The list is built in your browser as you type. Nothing is sent to a server.