🔗Join Text Lines
Join multi-line text into a single line, or connect with commas, semicolons, or any other separator. Useful for turning a spreadsheet column into a SQL IN clause ('A','B','C'), CSV cleanup, flattening name lists, and building OR keyword queries.
How to use
- 1Paste line-separated text.
- 2Pick a separator and options (quotes, brackets).
- 3Copy the result to use in SQL, code, or search.
FAQ
How do I build a SQL IN clause?+
Use comma separator and enable the quote option to get 'A','B','C' — drop it straight into WHERE name IN ('A','B','C').
Are empty lines joined too?+
There's an option to auto-skip empty lines, which usually looks cleaner.
Can the separator include a newline?+
Yes — special separators (tab, newline) are supported via escapes (\n, \t).
Does Excel data work?+
Yes — copying a column from Excel gives newline-separated text. Paste it in directly.
The result is huge. Should it really be one line?+
Depends on use. SQL IN clauses fit on one line; JSON arrays look better wrapped for long items.
How do I reverse this (one line back to many)?+
Use a line splitter / dedupe tool, or replace commas with newlines via regex.