Comma-Line Converter: Switching Between CSV and Line-Separated Lists
Sometimes you have a comma-separated list and you need it as one item per line β or vice versa. This is one of those tiny tasks that comes up surprisingly often when copying data between spreadsheets, code, and form fields.
Spreadsheets, databases, and code all favor different list formats. Excel exports comma-separated, but pasting into a 'one email per line' field needs newlines. SQL IN clauses want comma-quoted strings. JavaScript array literals want quoted commas. Switching between these by hand is tedious and error-prone.
Common conversions
- β’Comma-separated β one item per line (for paste into multiline fields)
- β’Lines β comma-separated (for CSV import or array literal)
- β’With or without quoting each item
- β’Optional whitespace stripping per item
Extended FAQ
What about commas inside the items themselves?
If your data contains commas as part of the values (like 'Smith, John'), use quoted CSV mode β the converter wraps each item in double quotes so embedded commas don't break the parsing.
Are my pasted values stored?
No β runs entirely in your browser.