How to use the text joiner
- 1 Type or paste your text into the left box, open a .txt file, or press Try an example.
- 2 Choose what to join with, how to wrap each item, and what goes before the last item.
- 3 The result appears on the right straight away and updates as you type.
- 4 Press Copy result or Download .txt, or Use as input to keep editing.
Joining lists for code and documents
Quotes and commas turn a column into a list for code or SQL; and before the last item turns it into a sentence. To go back to one item per line, use the Text Splitter. Remove repeats first with Remove Duplicate Lines.
- Skip empty lines to avoid empty items.
- Use semicolons for email recipient lists.
- Use the Oxford comma option for formal writing.
Features
Any separator
Commas, spaces, semicolons, tabs, bars or custom text.
Quotes and brackets
Wrap items for code, SQL and spreadsheets.
Natural lists
Add and, or, or an Oxford comma before the last item.
When to use it
Spreadsheet columns
Paste a column from Excel or Google Sheets and turn it into a comma separated list. To go the other way, use the Text Splitter.
Code and SQL
Wrap IDs or names in quotes for an IN list or an array.
Email recipients
Join a list of email addresses with semicolons or commas. Clean duplicates first with Remove Duplicate Lines.
Writing
Turn a bullet list into a readable sentence, such as apples, pears and plums.
Related Text tasks
Frequently asked questions
How do I turn a column into a comma separated list?
Paste the column, choose Comma and space as the separator, and copy the result. Each line becomes one item in the list.
How do I make a list for SQL or code?
Choose single or double quotes as the wrap and Comma as the separator. For example, 'a','b','c' is ready for an IN clause or an array.
What is the Oxford comma option?
It adds a comma before and in a list of three or more items, such as red, white, and blue. With only two items, it uses and without a comma.
Are empty lines included?
Not by default. Skip empty lines is on, so blank lines do not create empty items. Untick it to keep them.
Can I remove duplicates while joining?
Yes. Tick Remove duplicate items and each value appears only once, in its first position.
Can I join with a line break and text?
Use the custom separator for any text, such as a dash with spaces. For more complex changes, use Find and Replace afterwards.
Is there a limit on lines?
No practical limit. Thousands of lines are joined instantly.
How do I join lines in Excel without formulas?
Copy the column from Excel, paste it here, choose the separator and copy the joined result back into a single cell. This is faster than writing a TEXTJOIN formula for one-off jobs.
Can I join lines with a new line between groups?
The joiner creates one line. To keep groups apart, join each group separately, or split the result again with the Text Splitter at a separator you choose.
Is my data uploaded?
No. Joining happens in your browser, so lists of emails or IDs stay on your device.
How this tool works. These text tools run entirely in your browser with plain JavaScript, so the text you paste never leaves your device and results update as you type. Each tool is tested with real text such as copied PDFs, emails, code, lists, emojis and non-English scripts before it goes live.
Built and reviewed by Hamza Farooq, founder and lead developer
· Last updated
· How we check our tools
· Report a problem