Split text into rows

Turn one line like a,b,c into one value per row. Free, and your data never leaves your browser.

Input
Result
Ad space: paste your AdSense code here

How to use it

  1. Paste a single line of values into the input box.
  2. Choose what separates the values: comma, space, semicolon, pipe, tab or your own text.
  3. Copy the rows into Excel or a query.

Frequently asked questions

Can I split by something other than commas?

Yes. Pick space, semicolon, pipe, tab, or enter any custom text.

Can it remove quotes around values?

Yes. Tick Remove quotes to strip single or double quotes from each value.

More SQL tools

📋 List to IN clausePaste a column from Excel and get a quoted, comma-separated list for WHERE ... IN (...).🔄 Rows ↔ columnsSwap pasted data so vertical becomes horizontal, and the other way round.📥 Excel to INSERTPaste rows copied from Excel and get one INSERT statement per row.⚖️ Compare two listsFind what is in one list but not the other, what both share, or all unique values.🧹 Clean & sort linesTrim spaces, remove duplicates, sort, change case, and add text to every line.✨ SQL formatterPut each major clause on its own line and uppercase keywords.