List to Text Converter

Q: How do I make a SQL IN list?

Choose **Comma and space** and **Single quotes '…'**, then type IN ( before and ) after the result.

Join a list (one item per line) into comma-separated or custom-separated text. Wrap items in quotes, strip bullets and add "and" before the last item.

Input

Join with

Wrap items in

Before last item (e.g. " and ")

Strip list bullets and numbersTrim spaces around itemsRemove empty lines

Output

Runs entirely in your browser. Your data is never uploaded.

What is List to Text?

Joins the lines of a list into a single line of text, separated by commas, semicolons, spaces, pipes, tabs or any custom text. Items can be wrapped in quotes or backticks, list bullets and numbers can be stripped, and a different separator such as " and " can be placed before the last item.

How to use List to Text

Paste your list, one item per line, into the Input box.
Choose a separator in Join with, or Custom text.
Optionally choose Wrap items in quotes and fill Before last item (for example " and ").
Copy the joined text from Output.

Example

Input

- a
- b
- c

Output

"a", "b" and "c"

Comma and space, double quotes, before last item: " and "

When to use List to Text

Use it to build SQL IN (...) lists, JavaScript or Python arrays, tag strings, or a readable sentence from a list. Quotes inside items are not escaped, so check values that contain the quote character before using the output in code.

How List to Text works

The input is split into lines. If "Strip list bullets and numbers" is on, leading markers such as -, *, • or 1. are removed. Items are trimmed and empty lines dropped (both on by default), each item is wrapped in the chosen quote character, and the items are joined with the separator. If a last separator is given and there are at least two items, it replaces the separator before the final item.