Text to Speech
Read any text aloud using the voices on your device.
Join Text
Join a list of lines into one line with any separator.
Quick Tool Overview
Join Text turns a column of lines into a single line with any separator, plus the details that make the result usable: quoting for SQL, brackets around the whole thing, and a different separator before the last item so a list reads as a sentence.
- What it does
- Joins lines into one line with a separator
- You give it
- A list, one item per line
- You get back
- A single joined line, optionally quoted and wrapped
- Best for
- SQL IN clauses, CSV rows and readable lists
About the Join Text
Turning a column into a comma-separated list is one of those jobs that arrives weekly and has no obvious home. You have a list of IDs in a spreadsheet and you need them as an SQL IN clause. You have a list of tags one per line and you need them comma-separated. You have a list of names and you need a sentence.
This joins them with whatever separator you choose, and adds the details that make the result usable rather than nearly usable. Each item can be wrapped in single or double quotes for SQL. The whole result can be wrapped in brackets. A different separator can be used before the last item, which is how you get "Alice, Ben and Chidi" instead of a list that ends abruptly.
Key features of the Join Text
Quoting with escaping
Wrap each item in single or double quotes, with quotes inside the item doubled the way SQL and CSV require.
Wrap the whole result
Brackets, parentheses or braces around the joined list, so an IN clause or an array is finished.
Final separator
Use " and " before the last item to produce prose rather than a bare data list.
Blank lines dropped
No empty item appears between two separators, and each line is trimmed before joining.
Item count shown
How many items were joined, which is the quickest check that nothing was lost.
How to use the Join Text
-
1
Paste your list
One item per line, straight from a spreadsheet column if you like.
-
2
Choose the separator
A comma and space, a comma, a pipe, a space or anything you type.
-
3
Add quotes and brackets
Wrap each item in quotes for SQL, and wrap the whole result in brackets or parentheses.
-
4
Set the final separator
Use "and" before the last item to produce a readable sentence rather than a bare list.
Frequently asked questions
Choose a comma separator, switch on single quotes around each item, and wrap the result in parentheses. That gives you ('a', 'b', 'c') ready to paste straight into the query.
Readable lists. Setting it to " and " turns three items into "Alice, Ben and Chidi" rather than "Alice, Ben, Chidi", which is what prose needs and a data format does not.
No, they are dropped before joining, so you do not get an empty item between two separators. Trailing whitespace on each line is trimmed for the same reason.
Yes. When quoting is on, any quote character already inside an item is escaped by doubling it, which is the convention both SQL and CSV use.
Reviews of the Join Text
What people who use the Join Text think of it. Reviews come from visitors and are posted as written.
No ratings yet
Yours would be the first.
- 5 0 reviews rated 5 stars
- 4 0 reviews rated 4 stars
- 3 0 reviews rated 3 stars
- 2 0 reviews rated 2 stars
- 1 0 reviews rated 1 star
0 reviews
Newest first
No reviews yet
Be the first to rate the Join Text. It takes half a minute and no account.
Write the first reviewMore text tools
Text Randomizer
Pick random items, draw samples and randomise in one place.
Remove Line Breaks
Strip hard line breaks from pasted text without losing paragraphs.
Shuffle Lines
Randomise the order of a list, fairly and repeatably.
Shuffle Words
Randomise word order, across the text or within each line.
Underline Text Generator
Underline text with combining marks that survive pasting.
Remove Empty Lines
Delete blank lines, or collapse runs of them down to one.
Sentence Case Converter
Rewrite text so only sentence starts and proper nouns are capitalised.