loot.tools

List Converter

Paste a column of values and convert it into whatever shape you need - a comma-separated line, a quoted SQL IN-list, a JSON or JavaScript array, or a CSV row. Split on new lines, commas, spaces, tabs, or a custom delimiter, then trim, de-duplicate, sort, wrap each item with a prefix and suffix, and join with the separator of your choice. Everything runs in your browser.
Text

Paste a column or list, then turn it into a comma-separated line, a quoted SQL IN-list, a JSON array, or any shape you need. Split, clean, sort, wrap each item, and join - all in your browser.

Input list
Output (0 items)
What this tool does
It takes a list of values and reshapes it. First it splits your input into items - by line, comma, space, tab, or a delimiter you type. Then it cleans them up: trim surrounding whitespace, drop blank entries, and remove duplicates. You can sort the items, wrap each one with a prefix and suffix (handy for quotes or brackets), and finally join them with any separator. The classic use is pasting a spreadsheet column and getting back 'a', 'b', 'c' for a SQL query.
How to use it
Paste your values into the input box. Pick how to split them with 'Split input by' - new line is the default for a pasted column. Toggle 'Trim items', 'Remove empty', and 'Remove duplicates' to clean the list, and 'Case sensitive' to control whether 'Apple' and 'apple' count as the same. Set a prefix and suffix (the quote and bracket buttons fill these in fast), choose what to 'Join with', and copy the result. The item count updates as you go.
Common use cases
  • Turning a spreadsheet column into a SQL IN-list with quoted values
  • Building a JSON or JavaScript array from a plain list
  • Converting a comma-separated line back into one item per line
  • De-duplicating and sorting a list before pasting it somewhere
  • Wrapping every line in quotes or brackets for code