Comma Separated List to Column

About the Comma Separated List to Column Tool

What does this tool do?

It takes a list of values strung together on one line — apple, banana, cherry — and stacks them into a clean column, one item per line. That's the format you need for pasting into a spreadsheet column, a code array, a checklist, or anything that expects values on separate rows. The conversion happens as you type, and the result is always ready to copy.

It also tidies the list along the way. By default it trims the stray spaces around each value and drops empty entries, and with a couple of switches you can remove duplicates, sort the items alphabetically or numerically, or wrap each one in quotes or brackets. The separator isn't fixed to a comma either — semicolons, tabs, pipes, or any custom character work too. Everything runs in your browser, so even a long or sensitive list never leaves your device.

How to Use This Tool

1. Paste your list. Drop your comma-separated text into the left box, drag in a .txt or .csv file, or hit Sample to see how it works.
2. Pick the separator. Comma is the default; switch to semicolon, tab, pipe, new line, or type your own if your values are split a different way.
3. Clean it up. Leave Trim spaces and Remove empty on for a neat result, then optionally remove duplicates, sort, or wrap each item in quotes.
4. Take the column. The right box fills in live with one value per line — copy it to your clipboard or download it as a text file.

Common Use Cases

Splitting a list onto separate lines is one of those small jobs that comes up constantly:

• Filling a spreadsheet column: Turn a, b, c into a column you can paste straight down a row of cells in Excel or Google Sheets.
• Building a code list: Get one value per line, optionally quoted, to drop into a JavaScript, Python, or SQL array.
• De-duplicating and sorting: Clean a messy list of emails, tags, or SKUs by removing repeats and sorting them in one pass.
• Making a checklist: Convert a sentence of comma-separated tasks into a tidy line-by-line to-do list.
• Reformatting exported data: Reshape a single CSV cell of values into rows for import somewhere else.

Need to go the other way? Our Column to Comma Separated List tool joins a column back into a single line.

Frequently Asked Questions

Can I split by something other than a comma?

Yes. The Split by menu covers commas, semicolons, spaces, tabs, pipes, and new lines, and the Custom option lets you type any character or sequence — for example , (comma plus a space) or - . The separator is matched literally, so special characters like . or | work exactly as typed.

Will it remove the extra spaces after each comma?

Yes, as long as Trim spaces is on (it is by default). A list like apple, banana, cherry comes out as three clean lines with no leading spaces. Turn the switch off if you actually want to keep that surrounding whitespace.

How do duplicates get removed?

With Remove duplicates on, the tool keeps the first time each value appears and drops any later exact match, leaving the rest in their original order. Values are compared after trimming, so cat and cat  are treated as the same once spaces are removed.

Can I wrap each item in quotes for code?

Yes. The Wrap items option puts double quotes, single quotes, backticks, parentheses, or square brackets around every value — handy for pasting a column straight into an array or a SQL IN clause.

Is my list private?

Completely. The whole conversion runs in your browser with JavaScript — nothing you paste is uploaded, stored, or logged, and the tool keeps working offline once the page has loaded.