Text to List Converter
Split text on a delimiter into one item per line — trimmed, de-duplicated, sorted — or join lines with a delimiter, quoted, as a SQL IN, JSON or Python list.
The items one per line (optionally numbered), or the joined line with the quoting and wrapper you chose, plus the counts of items, blanks dropped and duplicates removed.
Example: "apple, banana,cherry , ,apple" becomes three lines (one blank dropped, one duplicate removed, sorted); the lines a, b'c, d become IN ('a', 'b''c', 'd') with the quote doubled the SQL way.
One delimiter,
both directions.
How splitting and joining work, what tidying does, and the quoting rules.
Splitting
Text is split on the delimiter you chose (a comma also swallows the spaces after it; space splits on any whitespace; line on line breaks), then each item is trimmed. Empty items are dropped, exact duplicates removed, and the list sorted alphabetically (natural order, so item2 comes before item10), numerically or by length.
Joining
Lines become one text joined with the delimiter (a space after a comma or semicolon). Items can be quoted; wrapped as SQL IN (…), a JSON array, a Python list or brackets. SQL doubles single quotes inside items, JSON escapes backslashes and double quotes.
Limits
Splitting is on the delimiter only: a quoted CSV field containing a comma is split too — the CSV pages handle that. Nothing leaves the browser; the same four anonymous usage counts as the rest of the site apply.
SOURCES
- Split on the chosen delimiter (whitespace-tolerant), trim, drop blanks, de-duplicate exactly, sort in locale-aware natural order; SQL doubles single quotes, JSON escapes backslashes and quotes
Last reviewed 21 September 2026. How results are checked: How we verify.