Convert Comma Separated List to Column
Convert comma separated list to column: paste a comma separated list and get one item per line, or flip a column back to commas. Trims, de-dupes and sorts on request.
Runs entirely on your device - nothing is ever uploaded.
More tools
- Online Notepad Private autosaving notes, Arial/Times. Get started
- Script Length Estimate the read time of scripts and speeches. Get started
- Text Compare Highlight exactly what changed between two texts. Get started
- Word Counter Live word, character, sentence and paragraph counts. Get started
- JSON Formatter Pretty print, validate and minify JSON instantly. Get started
- Base64 Encode/Decode Encode text to Base64 and decode it back. Get started
- URL Encoder Percent-encode text for safe links and queries. Get started
- UUID Generator Generate random UUID v4 identifiers in bulk. Get started
How to use the converter
- Paste your comma-separated list (or a column, with the direction flipped).
- Pick the delimiter and any cleanup: trim, drop empties, de-dupe, sort.
- Copy the result or download it as a text file.
What it is for
Turning spreadsheet rows into mailing lists, tag sets, SQL IN (...) clauses, or one-per-line checklists - and back again. For shuffling or picking from lines, use the list randomizer; for counting words, the word counter.
Cleaning messy lists
Real-world pastes arrive messy: trailing commas, blank lines, quoted cells, extra spaces. This converter trims each entry, drops empties, and can wrap every item in quotes for SQL or strip them back off for plain checklists. Going the other way, one-per-line text collapses into a comma-separated row sized for spreadsheet import. Pair it with the word counter to sanity-check long pastes before you transform them.