Text Separator and Joiner
Split text by comma, space, tab or any custom delimiter, or join a list of lines back into one delimited string. Free, instant, in-browser.
Input
Result
The result appears here as you type.
What this tool is for
Two jobs that always come in pairs: turn a comma separated string into a list you can read, and turn a list back into a comma separated string you can paste into a query. Add quoting for SQL or a trailing separator when you need one.
How to use it
- Paste your text or list.
- Pick the direction: split into lines, or join lines together.
- Set the delimiter, and optionally wrap each item in quotes.
- Copy the result.
Frequently asked questions
Can I use tabs as a delimiter?
Yes. Choose Tab from the delimiter list, which is what you need for data copied out of a spreadsheet.
Can it build a SQL IN list?
Yes. Join with a comma, turn on quoting, and you get 'a', 'b', 'c' ready to paste between the parentheses.