About the Join Text Lines
A list with one item per line is easy to read but awkward to paste into a query, a formula or a form that wants one line. This tool joins the lines using the separator you pick: a comma, a space, a semicolon, a bar, a tab or any text of your own. Items can be wrapped in single or double quotes, trimmed, stripped of empty lines and cleaned of repeats. It is the quick way to build a list for an SQL IN clause, a tag field or a spreadsheet formula. It runs in your browser and nothing is uploaded.
Updated October 2026
How to use the Join Text Lines
- 1Paste your lines into the left box.
- 2Choose the separator, or choose My own text and type it.
- 3Choose whether to wrap each item in quotes.
- 4Tick the options to trim, skip empty lines or remove repeats.
- 5Copy the single line or download it.
Lists on one line
Many tools want a single line: a query with a list of IDs, a tags box, a search field that takes comma-separated words, a command with several arguments. Copying a column from a spreadsheet gives you one item per line, which is exactly the input here.
Joining by hand is slow and invites missed commas; the tool never forgets one.
Options explained
Trimming removes spaces around each item, which keeps the separator tidy. Skipping empty lines avoids double separators. Quoting wraps each item, so a list of words becomes a list of strings. Removing repeats gives each item once, in the order it first appeared.
- Trim: no stray spaces
- Skip empty: no doubled commas
- Quote: ready for code
- Unique: no repeats
Going the other way
To split a single line back into one item per line, use the Text Splitter on this site.
Example
The lines apple, banana and cherry joined with a comma and a space and wrapped in single quotes become 'apple', 'banana', 'cherry'. Joined with the custom text and, they become apple and banana and cherry. With a tab as the separator, they paste into one row of a spreadsheet.
A blank line in the middle is skipped when the skip option is on, so you never get two separators in a row.
Phone and computer
On a phone, paste into the box, adjust the separator and quote options, and tap Copy to carry the result into another app. On a computer you can also download it as a file. The two boxes sit side by side on a wide screen and one above the other on a narrow one, so you can compare input and result without zooming. Nothing you paste is uploaded or stored.
Good to know
The joined line has no separator after the last item. If a list contains the separator itself, for example a comma inside an item, consider wrapping items in quotes. The trim option removes spaces and tabs from both ends of each item before it is joined. To undo the join later, Text Splitter cuts text at any separator you choose, and Remove Duplicate Lines clears repeats first. To remove repeated lines after joining, use Remove Duplicate Lines, and Merge Text Lists puts two lists together.
Features
- Comma, space, tab, bar or custom separator
- Optional quotes around each item
- Trim and skip empty lines
- Optional removal of repeats
- Shows the item count
- Private: nothing is uploaded
Frequently asked questions
How do I turn a list into a comma separated line?
Paste the list, keep the comma and space separator and copy the line.
How do I build an SQL list with quotes?
Choose single quotes for wrapping and a comma separator. A list of three names becomes 'a', 'b', 'c' ready for an IN clause.
Can I use my own separator?
Yes. Choose My own text and type it, such as ' and ' or ' OR '.
What happens to empty lines?
With the skip option on they disappear. Turn it off to keep them as empty items.
Can it remove duplicate items?
Yes. Tick Remove repeated items and each item appears once.
Is my list uploaded?
No. The lines are joined in your browser.