Convert a Column to a Comma Separated List
Paste a list of values, one per line, and join them into a single comma separated list. Optionally wrap each value in quotes or switch to any delimiter you need.
How to convert a column to a comma separated list
- Paste your values into the box, one per line.
- Pick a delimiter and decide whether to wrap each value in quotes.
- Copy or download the comma separated result.
Examples
Join names into a list
Ada Bob Cleo
Ada, Bob, Cleo
Quote values for SQL or code
red green blue
"red", "green", "blue"
Frequently asked questions
How does this turn a column into a comma separated list?
It splits your text on each line break, trims and drops blank lines by default, optionally wraps each value in quotes, then joins them with your chosen delimiter.
Can I use a different separator instead of a comma?
Yes. Pick comma, semicolon, pipe, space, or tab. The output updates live as you change the delimiter.
Can I wrap each value in quotes?
Yes. Turn on quotes to wrap every value, which is handy for SQL IN clauses, arrays, or other code. You can choose double or single quotes.
Can I go the other way and split a list back into a column?
Yes. Use the swap button to reverse the direction. The tool splits your comma separated list back into one value per line.
Are blank lines and extra spaces removed?
By default the tool trims spaces around each value and skips empty lines, so the list stays clean. You can keep them if you prefer.
Is my data private?
Yes. Everything runs in your browser and nothing is uploaded to a server.
Related tools
Remove Line Breaks
Remove line breaks and paragraph breaks from text online. Flatten copied text into one line, keep spaces tidy, then copy the result. Free and private.
Sort Lines
Sort lines of text alphabetically or numerically online. Reverse the order, ignore case, and remove duplicate lines, then copy the result. Free and private.
Remove Duplicate Lines
Remove duplicate lines from text online and keep the first of each. Options for case sensitivity and trimming whitespace. Free, instant, and private.
Find and Replace
Find and replace text online with literal or regex search, case sensitivity, and replace first or all. See a live count of changes. Free and private.
Add Line Numbers
Add line numbers to any text online. Set the start value, step, and separator, pad numbers to align, and copy or download the result. Free and private.
Bullet List Maker
Turn lines of text into a bullet or numbered list online. Pick dash, asterisk, dot, arrow or numbers, add indent, then copy. Free and private.