Wrong delimiter
Values all end up on one line.
Fix: Double-check the delimiter exactly matches the string you pasted.
Single Line to Multi-line
Split a single-line string on any delimiter to produce one value per line
Split on:
Input
Loading editor...
Output
Output will appear here...
Advertisements
content bottom • up to 300x250
Advertisements
sidebar • 160x600
What is Single Line to Multi-line
Last reviewed:
CSV (Comma-Separated Values) is a simple tabular text format used to exchange spreadsheet-like data between databases, apps, and analytics tools.
Single Line to Multi-line is the inverse of the join tool. Paste a delimited string (CSV, pipe-separated, semicolons, anything) and the tool returns one value per line, with empty tokens removed.
It's widely used to flip comma-separated lists into one-per-line layouts for spreadsheets, config files, and task trackers.
Why use it
- Convert CSV lists into bulleted markdown lines.
- Extract values from copy-pasted SQL IN (...) clauses.
- Prepare input for tools that require one value per line.
- Split environment variables pasted as semicolon-separated strings.
- Refactor quick and dirty lists into proper line-based files.
Features
- Custom delimiter field
- Trims each value
- Skips empty tokens
- Keeps Unicode safe
- Single Line to Multi-line is handled entirely in-browser
How to use Single Line to Multi-line
- Paste delimited line. Drop the single-line string.
- Set delimiter. Pick the character your list uses (comma, pipe, semicolon).
- Run. The output shows one clean value per line.
Example (before/after)
Comma-separated
apple, banana, cherry
One per line
apple banana cherry
Common errors
Unexpected whitespace
Some tokens have trailing spaces.
Fix: The tool trims each token — but check for hidden Unicode whitespace.
FAQ
Does it trim each token?
Yes — leading and trailing whitespace is removed.
Does it skip empty tokens?
Yes — consecutive delimiters produce no output line.
Can I split on tabs?
Yes — paste a tab character into the delimiter field.
What if I want to keep the delimiter?
Use a regex-aware editor or the find-and-replace tool with ',' → ',\n'.
Is my data processed locally?
Yes — everything stays in your browser.
Related tools
Pair with the reverse tool and list utilities for complete workflows. You can also browse the full String Utilities category for more options.
Multi-line to Single Line
Flatten multi-line text into a single line with a configurable separator
List Formatter
Format newline-separated values into comma-separated lists, quoted values, JSON arrays, or SQL IN clauses with trim, dedupe, and sort options.
Find and Replace
Find and replace text patterns
Remove Duplicate Lines
Remove duplicate lines from text
Sort Lines
Sort lines alphabetically or numerically
String Splitter
Split string by delimiter
Line Counter
Count lines in text
Line Shuffler
Randomise the order of lines in any multi-line text
Binary to Text
Convert binary to readable text
Hex to Text
Convert hexadecimal to text
Remove Empty Lines
Remove empty lines from text
Text to Binary
Convert text to binary