# Comma Separator Online: Column to Comma Separated List

> Comma separator online: turn a column into a comma separated list, with single quotes for SQL if you need them, or split a comma list back into lines.

URL: https://clipten.com/tools/comma-separator
Updated: 2026-10-01
About ClipTen: https://clipten.com/llms.txt

ClipTen (https://clipten.com/) Free tools (https://clipten.com/tools) Comma separator

## Comma separator

Paste a column from Excel or a list with one item per line, and get a, b, c back: with quotes for SQL, with semicolons for email, or the other way round.

Made by ClipTen

### Stop going back to copy it again.

Moving lists from a sheet into SQL, then into an email? ClipTen keeps ten copies on your number keys, so each version stays one shortcut away.

Download forMac (https://clipten.com/mac#install)
Get it fromMicrosoft

Slots 1 to 5 free, no daily limit. All 10 for $15, once. See how it works (https://clipten.com/how-it-works)

### How to use it

- Paste your column or list.
- Choose a separator and quotes. For an SQL IN (…) list, pick single quotes.
- Copy the result. Choose List to lines to go back from a comma list to a column.

### Column to comma separated list

Copy a column in Excel or Google Sheets and each cell arrives on its own line. Paste it here and it comes out as one line, separated however you like. That is the quick way to make:

- An SQL filter: WHERE id IN ('1001', '1002', '1003'), with single quotes.

- A list of email addresses for the To field, with semicolons for Outlook or commas for Gmail.

- Tags or keywords for a CMS or a YouTube upload, separated by commas.

### Comma separated list with single quotes

Choose 'single' under Quotes and every item is wrapped: '1001', '1002', '1003'. A quote inside an item is doubled, as SQL expects, so O'Brien becomes 'O''Brien'. Pick "double" for JSON arrays and most programming languages.

### And back again

Choose List to lines and paste something like red, green, blue. It splits on commas, semicolons, pipes and tabs, takes off surrounding quotes, and puts each item on its own line, ready to paste into a column.

### Doing it with a formula

Excel 2019 and later, and Google Sheets, can join a column with =TEXTJOIN(", ", TRUE, A1:A100). Quotes need more work: =TEXTJOIN(", ", TRUE, "'"&A1:A100&"'"). Pasting here skips the formula.

Last checked October 2026.

### Questions

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

Copy the column, paste it into the box and copy the result. Choose quotes if the list is for SQL.

How do I separate a comma list into rows?

Choose List to lines and paste the comma list. Each item goes on its own line, ready to paste into a column.

How do I make a comma separated list with single quotes?

Paste the column, choose 'single' under Quotes and copy: '1001', '1002', '1003'. A single quote inside an item is doubled, the way SQL expects.

Can Excel do this?

Yes, with =TEXTJOIN(", ", TRUE, A1:A100) in Excel 2019 and later and in Google Sheets.

### More free tools

All free tools → (https://clipten.com/tools)

- Remove duplicate lines Keep each line once, in order (https://clipten.com/tools/remove-duplicate-lines)
- Sort lines A to Z, Z to A, by length or shuffled (https://clipten.com/tools/sort-lines-alphabetically)
- Email extractor Pull every email address out of text (https://clipten.com/tools/email-extractor)
- Find and replace Replace words in any text, regex too (https://clipten.com/tools/find-and-replace-text)
- Remove line breaks Join broken lines from PDFs and emails (https://clipten.com/tools/remove-line-breaks)
- Million to crore Million, lakh, crore and billion, side by side (https://clipten.com/tools/million-to-crore)

Download forMac (https://clipten.com/mac#install)
Get it fromMicrosoft

- Slots 1 to 5 free, no daily limit
- No card, no subscription
- All 10 slots for $15, once

On a Mac, it installs in about a minute with one line in Terminal (https://clipten.com/mac#install).