Turn a column of values into a comma-separated list or back: quotes, SQL IN and JSON formats, sorting and duplicate removal
Paste the column (from Excel, Google Sheets or a text file) into Comma Separator: the comma-separated list appears as you type, ready to copy. Choose quotes, brackets, sorting or duplicate removal, or switch direction to turn a list back into a column.
Values written on one line with a comma between them, such as apple, banana, cherry. It is how lists are pasted into SQL queries, code, forms and search filters.
Related terms
Turn a column of values into a comma-separated list in your browser.
Paste your column
Copy a column from Excel, Google Sheets or a text file and paste it into the left box.
Pick a format
Plain list, SQL IN, JSON array or CSV row, or set the separator and quotes yourself.
Clean it up
Sort, remove duplicates, trim spaces or drop empty items if you need to.
Copy the result
Click Copy, or download it as a .txt file.
Result: A comma-separated list
Select the cells in Excel or Google Sheets, copy, and paste into the left box. Each cell becomes one item and the comma list appears on the right; click Copy.
Click SQL IN: each item is put in single quotes, quotes inside items are doubled (O'Brien becomes 'O''Brien'), and the list is wrapped in brackets.
Turn on Remove duplicates; with Ignore case, Apple and apple count as the same. The number removed is shown.
Comma, comma and space, semicolon, pipe, tab, space, new line, or anything you type. You can also put a set number of items on each line.
Switch to 'Comma list → column'. The separator is detected, and items in quotes stay whole even when they contain a comma, like "Smith, John".
The list is built in your browser as you type; nothing is uploaded.
SQL IN gives ('a', 'b') with quotes inside items doubled; JSON gives ["a", "b"] with JSON escaping; CSV row gives "a","b". You can also choose any separator, quotes, brackets, a text before and after each item, and items per line.
Items can be trimmed, empty items dropped, duplicates removed (optionally ignoring case) and the list sorted A→Z, Z→A or naturally (item2 before item10). Counts of items, duplicates and empty lines are shown.
In the other direction the separator (comma, semicolon, tab, pipe or new line) is detected from the text, wrapping brackets are removed, and quoted items stay whole, CSV-style.
Everything runs in the browser as you type; nothing is uploaded.
| Format | Result |
|---|---|
| Plain list | O'Brien, Smith |
| SQL IN | ('O''Brien', 'Smith') |
| JSON array | ["O'Brien", "Smith"] |
| CSV row | "O'Brien","Smith" |
| One per line | O'Brien⏎Smith |
Quotes inside items are doubled for SQL and CSV and escaped with a backslash for JSON and JavaScript.
