Conversions
Column Data Here……
Output as
or
Delimited Data Here……
0 items

Convert Commas to New Lines

Turn a, b, c into one item per line. This is the shape every other text tool expects.

Already set up: split mode is comma, join is newline. Paste the delimited string and press convert to break it apart.

Examples

InputOutput
Simple apple, banana, cherry apple ⏎ banana ⏎ cherry
Realistic [email protected], [email protected], [email protected] [email protected][email protected][email protected]

Why convert this way

One item per line is the universal working format. Sorting, deduplicating and counting all operate line by line, so a single comma-separated string is one item to every one of them. Splitting first unlocks the rest of the toolbox.

When you will need it

Watch out: Watch the spaces. a, b splits into a and  b with a leading space unless trim is on. Leave Trim whitespace enabled and it is handled.

What the settings do here

  • Split on comma — the tool reads apple, banana, cherry as 3 separate items.
  • Join with a line break — producing apple⏎banana⏎cherry.

Where this comes up

This is the first step of almost every list job. A support ticket arrives with forty order numbers on one line; nothing useful can happen until they are forty separate lines.

Related conversions

Now that every item is on its own line you can sort the list, strip duplicates or count the rows before joining it back up.

Frequently Asked Questions

Why split a comma-separated list into lines?

Sorting, deduplicating and counting all work line by line. A single comma-separated string counts as one item to every one of those tools, so splitting first is what makes them usable.

What happens to the spaces after each comma?

With trimming enabled, which is the default, leading spaces are removed so you get clean values. Without it, every item after the first keeps a leading space.