Comma separated list: column to comma converter

Paste a column, one item per line, and get a comma separated list, or split a list back into a column for your spreadsheet.

More options

“Trim spaces” and “Skip empty lines” are on by default. In “List → column” mode, pick the delimiter your list actually uses, or it won't split. It all runs in your browser: your text is never uploaded.

Example input and result

Apples
Bananas
Cherries
Grapes
Oranges

Result

Apples, Bananas, Cherries, Grapes, Oranges

How to make a comma separated list from a column

Paste a column with one item per line, like a column copied from Excel or Google Sheets, and the tool joins it into one line with a comma and a space between items. Five lines with Apples, Bananas, Cherries, Grapes, and Oranges become “Apples, Bananas, Cherries, Grapes, Oranges”. The item count tells you how many items your list has.

“Trim spaces” and “Skip empty lines” are on by default, so stray spaces at the start or end of a line and blank rows from a spreadsheet don't turn into empty items. Turn on “Remove duplicates” to keep each item once, or “Sort A–Z” to put the list in alphabetical order. Then use “Copy result” or “Download TXT”. Everything runs in your browser, nothing is uploaded, and the box takes up to 500,000 characters.

Comma separated list delimiters, quotes, and parentheses

Choose the delimiter that the place you're pasting into expects. If you're not sure, comma and space is the easiest to read:

  • Comma and space: easy to read, good for emails, notes, and tags
  • Comma: CSV fields and most programming languages
  • Semicolon: CSV files where the comma is the decimal mark
  • Pipe (|): data where some items contain commas
  • Tab: values you want to paste across a row of spreadsheet cells
  • Space: command lines and simple word lists

Comma separated list for a SQL IN clause

Quotes go around each item: 'single' quotes for text values in SQL, "double" quotes for JSON or CSV fields that contain commas. The parentheses option wraps the whole list. To filter a query by a list of values, paste the column, pick comma and space, and turn on single quotes and parentheses. With “Remove duplicates” on, repeated IDs show up once, which keeps the query short. The list is ready to go right after WHERE country IN:

  • Text values: ('Spain', 'Mexico', 'Chile')
  • Numbers, with no quotes: (1024, 1031, 1047)

Comma separated list to column for Excel and Sheets

Switch the mode to “List → column” to go the other way. The tool splits your text at the delimiter you choose and puts each item on its own line, ready to paste into a single column in Excel or Google Sheets. Pick the delimiter your list actually uses: a list separated by semicolons won't split if the delimiter is set to comma.

With “Trim spaces” on, the comma delimiter handles “a,b” and “a, b” alike, because the spaces left around each item are removed. The item count lets you check that nothing got lost on the way, and “Remove duplicates” cleans up a list where the same email or tag shows up twice.

Frequently asked questions

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

Paste the column with one item per line, keep “Column → list” as the mode, and choose a delimiter, such as comma and space. The list appears on one line, ready to copy. Turn on quotes or parentheses if you're pasting it into code or a SQL query.

How do I add quotes around each item?

Pick 'single' or "double" quotes in the options. Each item gets its own pair, so Apples and Bananas become 'Apples', 'Bananas'. Single quotes suit text values in SQL, and double quotes suit JSON and CSV fields.

Can I turn a comma separated list into a column?

Yes. Choose “List → column”, set the delimiter your list uses, and paste it. Each item lands on its own line, so you can paste the result into one column in Excel or Google Sheets. With “Trim spaces” on, the spaces after each comma are removed.

How do I remove duplicates from my list?

Turn on “Remove duplicates” and each item appears only once in the result. Combine it with “Sort A–Z” to get a clean, ordered list. The item count updates too, so you can see how many unique items you have left.

Which delimiter should I use for Excel?

To paste into a column, use “List → column”, which puts one item per line. To fill a row instead, use the tab delimiter, because Excel and Google Sheets put each tab separated value in its own cell. For a CSV file, use a comma, or a semicolon if your region writes decimals with a comma.

Languages
Copied text!