List to Comma Separated Converter
Turn a column of lines into a comma list and back.
Input
This tool runs entirely in your browser. The data you paste or load is never uploaded.
Result
Enter your input, then run the tool.
About this tool
Joins one item per line into a comma-separated list, or splits a delimited list back into lines, with optional quotes, trimming, de-duplication and sorting. Ideal for SQL IN clauses, tags and spreadsheet columns.
How to use it
- Paste the list.
- Choose the direction, separator and quoting.
- Press Convert and copy the result.
Frequently asked questions
How do I build an SQL IN list?
Choose Lines to list, single quotes and the “, ” separator, then wrap the result in IN ( … ).
Can I use another separator?
Yes. Type any separator, such as “ | ” or “;”. It is used both for joining and for splitting.
Keep going
Related tools
Sort Lines Alphabetically
Sort any list with natural and numeric ordering.
Remove Duplicate Lines
Deduplicate a list while keeping the original order.
CSV to JSON Converter
Convert CSV rows into structured JSON, with type detection.
Word Counter
Count words, lines and paragraphs while you type.
Character Counter
Count characters with and without spaces, plus byte size.
Sentence Counter
Count sentences and average sentence length.