When you need a column instead of a list
Data tends to travel as a single line — a comma separated field in a CRM export, a JSON array in an API response, a semicolon separated recipient list in an email header. But spreadsheets, form fields and many scripts want each value on its own row. This tool makes that switch without opening a text editor and doing a find-and-replace.
Paste into a spreadsheet column
Convert the list, copy the result, click a cell in Excel or Google Sheets and paste. Because each item is on its own line, the spreadsheet fills one cell per row automatically.
Read an ID list out of a query
Copy the contents of an IN (…) clause, paste it here, and the parentheses and quotes are stripped so you are left with the raw IDs — ready for a lookup or a VLOOKUP.
Count and de-duplicate
The item counter shows how many values you actually have. Tick Remove duplicates and the counter shows how many were dropped — a quick sanity check on messy exports.
Doing it in a spreadsheet or in code
Excel and Google Sheets
Both applications can split text to columns from the Data menu. To split into rows instead, use a formula:
=TRANSPOSE(SPLIT(A1, ",")) Google Sheets
=TEXTSPLIT(A1, , ",") Excel 365Python
items = [s.strip().strip('"\'') for s in text.split(",") if s.strip()]
print("\n".join(items))Command line
tr ',' '\n' < list.txt # Linux / macOS
(Get-Content list.txt) -split ',' # PowerShell