Comma to Column

Convert comma-separated text into clean column output with one item per line. This comma to column converter is useful for Excel, Sheets, and quick list cleanup.

Whether you call it comma to column or comma to rows, this free tool handles it instantly in your browser.

Comma-separated text

21 chars3 words

Options

Trim items

Column outputLive preview

apple banana orange

Ctrl+Enter to copy | Ctrl+Z to undo

Example usage

Example input

apple, banana, orange

Example output

apple banana orange

Batch Processing

Enter multiple inputs, one per line. Each line will be processed separately.

Input (one per line)

Results

Why this tool?

Everything runs right in your browser — no uploads, no sign-up, no waiting. Your text never leaves your device.

Quick tips

•Outputs update live as you type.
•Use the sticky copy button to grab results quickly.
•Bookmark this page for fast access.

How it works

Paste a comma-separated list into the input field.
The tool splits items on commas and places each item on a new line.
Optional trimming removes leftover spaces around each item.

Use cases

Prepare comma-separated values for spreadsheet columns.

Turn inline lists into vertical text quickly.

Clean copied tags, keywords, or names before sorting.

Convert list text for easier editing and review.

Why comma lists and column lists both exist

A comma-separated list is compact and machine-friendly — it fits in one cell, one field, one line of a config file. A column (one item per line) is human-friendly and form-friendly — you can scan it, edit one entry without counting commas, and paste it into the bulk-input boxes that email tools, ad platforms, and admin panels expect. Most real work involves bouncing between the two shapes.

Converting comma to column is usually the first step of list processing, because nearly every other operation — sorting, deduplicating, counting — works on lines. Once your list is vertical, our Alphabetical Order, Remove Duplicate Lines, and Line Counter tools all apply directly.

The spacing trap, and the CSV caveat

Human-written lists put a space after each comma ("apple, banana, cherry"). Split naively and every item after the first carries a leading space, which then breaks matching, sorting, and imports in ways that are invisible on screen. That is what the trim option exists for, and leaving it on is almost always right.

One important limitation: this is a simple splitter, not a CSV parser. Real CSV allows commas inside quoted fields — the line `"Smith, John",42` is two fields, not three. If your data contains quoted values with commas inside them, splitting on every comma will break those records apart. For plain lists of tags, keywords, emails, or SKUs, which is the overwhelming majority of cases, splitting on the comma is exactly right.

Cleanup