List Converter
Convert a list between lines, commas, semicolons, tabs and more. Add quotes, remove duplicates and sort at the same time. Handy for spreadsheets, SQL and code.
Common conversions
| Task | Input | Output | Wrap |
|---|---|---|---|
| Excel column to CSV line | New line | Comma | Nothing |
| IDs for a SQL IN clause | New line | Comma and space | Single quotes |
| Email addresses for a To field | New line | Semicolon | Nothing |
| CSV line back to rows | Comma | New line | Nothing |
Frequently asked questions
How do I turn a column into a comma-separated list?
Paste the column from Excel or Google Sheets, keep the input as “New line” and the output as “Comma and space”, then press Convert.
How do I add quotes around each item?
Choose single or double quotes under “Wrap each item”. This is useful for SQL IN clauses and code arrays.
Can I convert a comma-separated list back to lines?
Yes. Set the input to “Comma” and the output to “New line”. Spaces around each item are removed when “Trim spaces” is on.
Does it work with data from a spreadsheet?
Yes. Copied spreadsheet rows are separated by new lines and copied columns by tabs, and both are available as input separators.
Is my list uploaded?
No. The conversion runs in your browser and nothing is sent to a server.