List converter
Transform a list — split, prefix, suffix, sort, dedupe, reverse and join.
Loading tool…
About the list converter
Reshapes a list in one pass: split on any delimiter, trim, drop blanks, remove duplicates, sort, reverse, lowercase, then wrap each item with a prefix and suffix and join with whatever separator you need. Turning a column pasted from a spreadsheet into a SQL IN clause takes one step.
Frequently asked questions
How do I build a SQL IN clause?
Split on new line, set the prefix and suffix to a single quote, and join with a comma and space. Paste the result between the parentheses.
In what order are the operations applied?
Trim, then lowercase, then remove blanks, then deduplicate, then sort, then reverse, and the prefix and suffix are added last. That order stops decoration from interfering with matching.