Comma-separated list to column
Convert comma-separated text into a column with one item per line. Trim surrounding spaces, ignore empty items or use a custom separator.
Split a list into separate lines
Paste your comma-separated list. Every literal comma starts a new item, and surrounding spaces are trimmed by default. Quoted commas are also split: this tool is not a CSV parser. Choose a different separator for lists divided by another character.
Example
Original text
apple, pear, orange
Result
apple pear orange
Text is processed in your browser. Pasted text is not uploaded or saved automatically.
Guide: Convert an Excel Column into a Comma-Separated List