List Converter Online (Sort, Dedupe, Format) — Free
Runs 100% in your browser — your files never leave your device.
Turning a raw dump of lines into a JSON array, an HTML list, or a comma-separated field comes up constantly. Paste your list, toggle the transforms you need — dedupe, trim, sort, reverse, lowercase — set prefixes, suffixes, and separators, and copy the result. Great for building arrays, SQL IN clauses, and markup lists.
How it works
- 1
Paste your list
One item per line.
- 2
Pick transforms
Sort, dedupe, trim, reverse, lowercase — all optional and live.
- 3
Shape the output
Set separator and item/list wrappers, then copy the result.
About this tool
One list, every notation
The tool converts your lines between list notations — plain lines, JSON arrays, YAML lists, SQL IN clauses, HTML lists, comma-separated, bulleted Markdown — taking text from one context to the next without retyping a single entry.
The bridge between tools
A column from a spreadsheet becomes a JSON array for a script; a JSON array becomes an SQL IN clause for a query; a bulleted list becomes comma-separated for a form field. The entries never change — only the wrapper around them does.
Clean entries convert cleanly
Whitespace and empty lines become noise in the output notation. Run whitespace removal and deduplication before converting, and the resulting arrays and clauses are clean on the first pass.
Frequently asked questions
Which notations does it produce?
The set covers JSON arrays, YAML lists, SQL IN clauses, HTML lists, Markdown bullets, comma-separated values, and plain lines — the formats lists actually travel between.
Are string entries quoted in JSON and SQL output?
Yes — entries are quoted per the target syntax, with internal quotes escaped, so the output is valid as-is in its destination language.
Can I convert in the reverse direction?
Yes — paste any of the notations and convert back to plain lines or into another notation. The converter reads the wrapped forms too.