List Converter
Convert a list between formats — newline, comma, semicolon, tab, pipe or space separated, JSON array, HTML/Markdown/numbered lists, or a SQL IN clause. Optionally trim, drop empty lines, remove duplicates and sort.
Input
Output
Guides
Paste a list in one format and instantly convert it to another. The List Converter splits your input on the separator you choose, applies optional cleanup (trim, remove empty lines, remove duplicates, sort), and re-serializes the result in whichever format you need — from a plain comma-separated string to a JSON array, an HTML or Markdown list, a numbered list, or a ready-to-paste SQL IN clause.
How to use it
- Paste or type your list into the Input List box.
- Choose the Input Format that matches how your list is separated — newline, comma, semicolon, tab, pipe, or space.
- Choose an Output Format.
- Toggle the cleanup options as needed.
- Copy or download the converted result.
The conversion runs automatically as you type or change any option.
Input formats
- Newline-separated — one item per line (the default).
- Comma / Semicolon / Tab / Pipe / Space-separated — items separated by that character. Space mode collapses any run of whitespace.
Output formats
- Newline / Comma / Semicolon / Tab / Pipe / Space-separated — join items with that separator.
- JSON Array — a pretty-printed JSON array of strings, correctly quoting and escaping each item.
- HTML Unordered List — a
<ul>with one<li>per item; special characters are HTML-escaped. - HTML Ordered List — the same as above using
<ol>. - Markdown List — a
-bullet per item. - Numbered List —
1.,2.,3.… one per item. - SQL IN Clause — a parenthesized, single-quoted list like
('a', 'b'), with embedded single quotes doubled so it is safe to drop into a query.
Cleanup options
- Trim whitespace — strip leading and trailing spaces from every item.
- Remove empty items — drop blank entries (useful after splitting text with trailing separators).
- Remove duplicate items — keep only the first occurrence of each value.
- Sort items alphabetically — order items A→Z.
Cleanup is applied in that order (trim, then remove empty, then dedupe, then sort) before the output is built.
Does the SQL output prevent injection?
It doubles single quotes so a value like O'Brien becomes 'O''Brien', which keeps the generated clause syntactically valid. It is a convenience for building queries by hand, not a substitute for parameterized queries — always use bound parameters for untrusted data.
Privacy
Everything runs entirely in your browser. Your list is never uploaded to a server.