Comma to List Converter
Convert comma separated values into a list, one item per line. Handles quoted items, semicolons, pipes and tabs, with sorting, de-duplication and optional numbering.
This tool needs JavaScript. Please enable it to use the Comma to List Converter.
How to use the Comma to List Converter
Paste comma-separated (or semicolon, pipe, tab) text.
Choose the separator, or leave it on automatic.
Copy the list, sorted or numbered if you like.
Why use this Comma to List Converter
Quote aware Items such as "cherry, dark" stay together instead of splitting at the inner comma.Any separator Comma, semicolon, pipe, tab, space or line break, or all of the first four at once.Clean up Trim spaces, drop empty items, remove duplicates and sort A-Z or Z-A.Numbering Add 1. 2. 3. to the result in one tick.
Frequently asked questions
How do I convert a comma separated list to lines? Paste the values and keep "Comma, semicolon, pipe or tab" selected. Each item moves to its own line.
What about commas inside quotes? With "Respect quoted items" on, anything inside double quotes stays as one item.
Can I sort and remove duplicates at the same time? Yes. Tick "Remove duplicates" and choose A-Z or Z-A.
More Lists & Naming tools