About the Multiline to Single Line
A column of values copied out of a spreadsheet, a query result or a terminal is almost never in the shape the next tool wants. This converter flattens it into a single line and lets you choose what goes between the pieces: a space for prose, a comma for a list, a pipe for a config value, or nothing at all when you are rebuilding a string that was wrapped by an editor.
Two switches decide how tidy the result is. Trimming removes the leading and trailing spaces each line carries after a copy and paste, so you do not end up with doubled separators. Skipping empty lines drops blank rows entirely, which is what you want when the source had spacing between groups. Turn both off and the join is literal, preserving every space and producing an empty slot for each blank line.
The quoting dropdown wraps each value before joining, so a column of identifiers becomes 'a', 'b', 'c' ready for a SQL IN clause or a JavaScript array, with any quote character inside a value escaped with a backslash. The status line reports how many lines were folded into one. If you only want to strip the newlines out of prose without choosing a separator, Remove Line Breaks is the simpler tool, and Remove Empty Lines tidies a column before you flatten it.
How to use
- Paste the multi-line text or the column you copied.
- Pick what to join with: a space, comma, pipe or nothing.
- Optionally wrap each value in quotes for a code or SQL list.
- Copy the single line.
Common questions
- Will Windows line endings be handled?
- Yes. Carriage return plus line feed and a bare carriage return are both treated as line breaks before joining.
- How do I build a SQL IN list?
- Choose single quotes for the wrapping and comma as the separator. The result pastes straight between the parentheses.
- Can I keep the blank lines?
- Untick "Skip empty lines". Each blank line then contributes an empty value, so you will see repeated separators.
- Does it change anything inside a line?
- Only the leading and trailing spaces, and only while trimming is on. Text inside the line is untouched.