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.
0 values
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.
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.