Comma Separator (List to Comma Separated Values)

Paste a column from a spreadsheet or a list with one item per line and get it back as a single comma-separated line, ready for an email, a search box, a CSV row, an SQL IN (…) clause or a JSON array. You can choose any separator, quote each item safely, remove duplicates and sort. It also works the other way: split a comma-, semicolon- or tab-separated line back into one item per line.

How to use this tool

1. Paste your list, one item per line.
2. Choose the separator, and quotes if the items are text values for SQL, CSV or JSON.
3. Pick a wrapper such as ( … ) for an SQL IN list or [ … ] for an array.
4. Copy the result, or a ready-made format from the table. To go back, choose “Delimited line → one item per line”.

Formula

Output = wrapper start + quote(item₁) + separator + quote(item₂) + … + wrapper end

Quoting escapes properly for each format: SQL single quotes double an inner apostrophe (O’Brien → 'O''Brien'), CSV double quotes double an inner quote mark as RFC 4180 requires, and JSON quoting uses backslash escapes so the result parses as JSON. When splitting, separators inside quotes are not treated as separators, surrounding ( ), [ ] or { } are removed, and “Detect” picks tab, semicolon, comma or pipe, in that order, from what it finds.

Example

The sample list (apple, banana, cherry, O’Brien, banana) becomes apple, banana, cherry, O'Brien, banana. With single quotes, ( … ) and “Remove duplicates” it becomes the SQL list ('apple', 'banana', 'cherry', 'O''Brien'), and the JSON array in the table is ["apple", "banana", "cherry", "O'Brien", "banana"].