Comma separated list to column: one value per line

Paste a list such as 'a', 'b', 'c' and get one value per row, ready to paste into a sheet. Quotes and brackets are removed for you.

Column to list List to column

Quick:

Your column

Options

Separator

Custom text

Quotes

Wrap list

Sort

Letter case

Before each item

After each item

Before the list

After the list

Your list

Your text never leaves your browser. Read how we handle data.

Example

This input:

('red', 'green', 'blue', 'green', 'Smith, John')

gives this output with the settings on this page:

red
green
blue
green
Smith, John

How to turn a list into rows

Paste the list into the left box. The column appears on the right. The tool finds the separator on its own: comma, semicolon, pipe or tab. If it guesses wrong, pick the separator in the Split on menu.

Press Copy, click the first cell of a column in Excel or Sheets, and paste. Each value lands in its own cell.

What gets cleaned up

Quotes around values (single, double or backtick) are removed.
Brackets or parentheses around the whole list are removed.
A comma inside a quoted value stays in the value. "Smith, John" stays one row.
Spaces around values are trimmed, and empty items are dropped.

Lists from code and queries

This works well for lists copied from a SQL IN clause, a JSON array or a Python list. Paste the whole thing, brackets included. If you also want to remove duplicates or sort the rows, tick the options below the box.

Questions about this page

How do I split on something other than a comma?

Open the Split on menu and choose semicolon, pipe, tab, space or Custom. With Custom you can type any text, such as " - ".

Will it split a value that has a comma inside quotes?

No. A quoted value stays whole, so "Smith, John" gives one row. If your values are not quoted, a comma always splits.

Can I paste a CSV row?

Yes. A CSV row is a comma separated list, so each field becomes a row. For a whole CSV file with many rows, load the file with Upload file.