List converter

This tool can process column-based data and apply various changes (transpose, add prefix and suffix, reverse list, sort list, lowercase values, truncate values) to each row.

About List converter

Reshapes a list of lines into the format you need: trim, deduplicate, lowercase, sort or reverse the items, add a prefix and suffix to each one, join them with a separator and wrap the whole list. Typical output is a comma-separated or SQL-ready list.

When you would use it

How to use it

  1. Paste the items, one per line.
  2. Toggle the transformations: trim, remove duplicates, lowercase, sort, reverse, keep line breaks.
  3. Set the item prefix and suffix, the separator and the list prefix and suffix, then copy the result.

Things worth knowing

Frequently asked questions

How do I make an SQL IN list?
Set the item prefix and suffix to a single quote each, the separator to a comma and a space, and the list prefix and suffix to ( and ). Lines like a, b, c become ('a', 'b', 'c').
Why is a duplicate not removed?
Items are compared exactly after lowercasing but before trimming, so a trailing space or an invisible character makes two items differ. Trim first (run the tool once with only trimming on), then deduplicate in a second pass.

All the tools