CoreGPT
Data · Free

Comma Separator

Turn a column of values into a comma separated list, or split a list back into a column. Works with commas, semicolons, tabs and your own separator.

Separator
Wrap each value in

0 values

Take it further

Do this inside Excel and Google Sheets with AI.

CoreGPT writes formulas, cleans columns and compares data right in your spreadsheet. Ask in plain English.

Get CoreGPT for Excel

Spreadsheets keep values in a column; many other places want them on one line with commas between them: an email To field, a SQL IN (...) list, a formula argument, a tag box. This tool converts between the two. Paste a column from Excel or Google Sheets and get a clean comma separated list, with optional quotes around each value. Switch direction to split a list back into one value per line, ready to paste into a column.

  • Pasting a column of email addresses into the To field (use semicolons for Outlook, commas for Gmail)
  • Building a quoted list for a SQL IN clause or a script
  • Turning a comma separated list into spreadsheet rows
  • Creating a keyword or tag list from a column
  • Removing duplicate values while converting
  • Use semicolon for Outlook recipients and comma for Gmail
  • Choose single quotes for SQL text values
  • Turn off the space after the separator when a system needs an exact format such as a,b,c
  • In Excel 365 the TEXTJOIN function builds the same list in a formula, and TEXTSPLIT splits it
  • Blank lines and extra spaces around values are removed automatically

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

Copy the column from your spreadsheet, paste it into the box and keep the Column → list direction. Copy the result.

How do I turn a comma separated list into a column in Excel?

Choose List → column, paste the list, copy the result and paste it into a cell. Each value lands in its own row.

Can I use another separator?

Yes. Pick semicolon, pipe, tab or space, or choose Custom and type your own.

Is my data uploaded?

No. The conversion happens in your browser.