Convert Column to Comma
Turn one-per-line into a comma list instantly.
Options
Type \t for a tab, \n for a new line and \\ for a backslash. Leave it empty to join with nothing in between.
Comma list
How to convert a column to a comma list
Paste your column with one item per line into Your column, or press
Load example. The comma-separated list appears next to it and updates as you type.
Pick a separator, optional single or double quotes, and clean-up options, then copy the result or
download it as a .txt file. Everything runs in your browser, so nothing you paste is uploaded.
Examples
| Input | Output |
|---|---|
| apples bananas cherries | apples, bananas, cherries |
| apples bananas O'Brien special | 'apples', 'bananas', 'O''Brien special' |
| apples bananas cherries | "apples", "bananas", "cherries" |
Limits and edge cases
- Single-quote mode wraps each item in '...' and doubles inner quotes the SQL way (O'Brien becomes 'O''Brien').
- Double-quote mode wraps each item in "..." and puts a backslash before inner " and \ characters.
- Remove duplicates is exact and case-sensitive: "Apple" and "apple" count as different items.
- A single trailing line break does not create an extra empty item, so "a\nb\n" is two items.
- For presets, JSON arrays, backticks, custom wrappers or joining every N lines, use Join Lines instead.
Frequently asked questions
How do I convert a column to a comma list?
Paste your column with one item per line into the input box. The comma-separated list appears instantly in the result box. Copy it or download it as a .txt file.
Can I use a different separator?
Yes. Type any separator into the separator field. You can use \t for a tab, \n for a new line and \\ for a backslash, or leave it empty to join with nothing in between.
How do quotes work?
Choose single quotes to wrap every item in '...' with inner quotes doubled the SQL way, or double quotes to wrap in "..." with inner quotes and backslashes escaped with a backslash.
What do trim, skip-empty and dedupe do?
Trim removes spaces at both ends of each line. Skip empty drops blank and whitespace-only lines. Remove duplicates keeps the first copy of each exact line and drops later repeats.
Does a trailing line break add an empty item?
No. A single trailing line break is ignored, so pasting a column that ends with Enter does not add an extra empty item.
Is my text uploaded anywhere?
No. Conversion runs in your browser with JavaScript and nothing is sent to a server. Inputs under 200 KB are kept in your browser's local storage so they are still there when you come back.