Comma to Newline
Paste a comma-separated string like “apple, banana, cherry” and the tool returns each item on its own line. Handy when you have a CSV row, a spreadsheet cell, or a quick list copied from somewhere and need to reshape it into a proper column. Use the options to pick the direction, comma to newline or the reverse, and to trim whitespace around each item.
How to split commas into newlines
-
1
Paste your text
Comma-separated text or newline-separated lines. Single-line strings and multi-line blocks both work.
-
2
Pick the direction
Choose "Comma → Newline" to split on commas, or "Newline → Comma" to join lines with commas.
-
3
Choose processing options
Turn on "Trim each item" to strip surrounding whitespace from every value.
-
4
Copy the result
One item per line, or one comma-separated line. Paste into a spreadsheet column, a bullet list, or a config file.
Example transformations
Input: red, blue, green, red, yellow, blue
Basic split (comma to newline):
red
blue
green
red
yellow
blue
Reverse direction (newline to comma):
red, blue, green, red, yellow, blue
Items that contain commas
The split happens on every comma, so an item that itself contains a comma, such as Smith, John, is split into two lines. The converter does not parse quoted CSV values. If your data uses quoted values, remove or replace the inner commas first, or use a dedicated CSV tool.
Common use cases
- Spreadsheet reshaping: a cell with “A, B, C, D” becomes four rows for further processing.
- CSV row → vertical list: paste a CSV row, get items one per line for form fields or bullet points.
- Config lists: environment variables often use comma-separated lists; tooling sometimes wants them one per line.
- Email recipient clean-up: “alice@co.com, bob@co.com, carol@co.com” → column of recipients.
- SQL IN-clause prep: build
IN ('a', 'b', 'c')by pasting a plain list and getting one item per line to quote.
Encoding and special chars
- Unicode preserved: accented letters, CJK, emoji all come through untouched.
- Line endings normalised: output uses
\n(Unix). Copy-paste into Windows apps handles conversion automatically.
Privacy
The text you paste is sent to our server so the conversion can run, and it is not stored afterwards. In the step-by-step mode your text is also kept in your browser’s session storage to carry it between steps.
Frequently Asked Questions
The split happens on every comma, so a value that contains a comma, such as “Smith, John”, is split into two items. The converter does not parse quoted CSV values, so remove or replace inner commas in the source first, or use a dedicated CSV tool for quoted data.
No. The tool converts comma-separated text into lines, and the other direction joins lines back into a comma-separated string. If you need a different separator, replace it first with a search-and-replace or use a dedicated CSV tool.
No. Only commas are used as separators. For text that mixes delimiters, normalise it to commas first (for example with a search-and-replace) and then convert.
There is no fixed limit, but very large inputs slow the page down. For very large CSV files, use a spreadsheet or a dedicated CSV tool instead.
Related Tools
Business Name Generator
Generate business name ideas from industry keywords and style choices, then use the checklist to verify domains, registries and trademarks.
Word Counter
Count words, characters, sentences and paragraphs with reading time, speaking time, keyword density and a Flesch readability score for essays, posts, captions and meta descriptions.
Emoji Kitchen
Try verified Google Emoji Kitchen sticker pairs, download PNGs, and get supported suggestions when a pair is not in the curated set.
Character Counter
Count characters, words, lines, sentences and paragraphs in any text. See totals with and without spaces plus a character breakdown.
Password Generator
Generate strong random passwords with adjustable length, symbols, numbers and mixed case using cryptographic randomness.
Username Generator
Generate username ideas from a seed word with optional numbers and separators. Handy for new accounts, gamer tags and alternate profiles.