Collapses multiple lines into a single line using the separator you choose. The inverse of the Word Splitter tool. Useful for building comma-separated lists, SQL IN clauses, or single-line data from multi-line exports. Runs entirely in your browser.
Paste a multi-line list, type the separator you want between values (comma, pipe, semicolon, ' OR ', anything), and the tool concatenates the lines into a single string. Toggle 'trim' to strip leading and trailing whitespace from each line first, and 'skip empty' to drop blank lines so you don't end up with consecutive separators.
Common uses: turning a column of IDs into a SQL IN-clause, building a comma-separated email list from a copy-pasted directory, or composing a pipe-delimited tag string. Optional quoting wraps each value in single or double quotes — useful for SQL string lists where you'd otherwise have to add the quotes by hand.
Set the separator to , (comma), enable 'wrap with quotes' if your IDs are strings, and the result is ready to paste between the parentheses of IN(...).
Only if you enable 'skip empty lines'. Otherwise each blank line becomes an empty value between two consecutive separators.
Yes — the separator is taken literally. ' | ', ', ', ' OR ', or even multi-character strings like '||' all work.
No — quoting only adds the wrapping character, it doesn't escape inner quotes. For RFC 4180-compliant CSV escaping use the dedicated CSV tool.
Explore the full suite of TEXT tools and 290+ other free utilities at Chunky Munster.