Turn a column of lines into a comma-separated list — or split a delimited list back into a column.
About Column to Comma-Separated List
This free tool converts between a column (one value per line) and a comma-separated list (all values on one line) — both ways. Paste a column and get apple, banana, cherry in one click; paste a delimited list and get it back as one value per line.
It's built for real jobs: wrap each item in quotes ('apple','banana') to drop straight into a SQL IN (…) clause, choose any delimiter (comma, semicolon, pipe, space, tab or your own), and trim items and skip blanks as it goes. Everything runs in your browser — nothing is uploaded.
What you can do with it
- Convert a column to a comma-separated list for a config, CSV or message
- Build a SQL IN clause — wrap each value in single or double quotes
- Split a comma-separated list back into one value per line
- Change the delimiter — comma, semicolon, pipe, space, tab or custom
- Clean as you convert — trim each item and drop blank lines
Features
- Two-way — column → delimited list, and delimited list → column
- Quote wrapping — none, single '...' or double "..." for SQL and code
- Any delimiter — comma, comma+space, semicolon, pipe, space, tab or custom
- Trim items and ignore blank ones
- Live item count and one-tap copy — 100% in your browser
How to use it
- Paste your column — one item per line (or a delimited list to split)
- Pick the direction — column → list, or list → column
- Choose a delimiter, and for a list, optionally wrap items in quotes
- Copy the result with the copy button
