Text · listsList processing
Turn a column into a comma-separated line and back, remove duplicates, sort, wrap every line in quotes or tags, compare two lists. Recalculated as you type, all in your browser.
The list is processed in your browser and never sent to a server
01
Process a list
the result updates as you type — no button to pressSource listone item per line
Result
Иванов Иван, Петрова Анна, Сидоров file10, Сидоров file2
In: 6 · out: 4 · duplicates removed: 2 · unique: 4
Separators
Input
Output
Cleanup
Order
Case
Wrapping
Filter and extract
02
Compare lists
union, intersection and difference of two listsWhat A has and B does not — the most common question: «which of these are missing from that list».
Result
anna@example.com
petr@example.com
In A: 4 · in B: 3 · common: 2 · only in A: 2 · only in B: 1 · result: 2
03
About working with lists
Changing separators
Formatcolumn ↔ a, b, c
Pick how the source list is separated and how the result should be: a column turns into a comma-separated line and back. Space and tab split on any run of them, so a double space never produces empty items.
Duplicates and frequency
Cleanup42 → 38 · apple ×3
Duplicates are removed with or without case sensitivity, keeping the first or the last occurrence. The frequency mode answers a different question — how often a value occurs — and orders the list by count.
Natural sorting
Orderfile2 → file10
Plain string comparison puts «file10» before «file2», because the character «1» is smaller than «2». Natural sorting reads the number as a whole and gives the order people expect from file names, versions and numbered items.
Wrapping and escaping
WrapperIN ('a', 'b')
Quotes, tags, Markdown and CSV wrap every line; SQL and JSON wrap the whole list. Values are escaped on the way: an apostrophe inside a value will not break the statement, and a quote will not break the JSON array.
Comparing two lists
SetsA ∩ B · A − B
Intersection shows what both lists share, the difference shows what one list is missing, and the union merges them without duplicates. The result keeps the order of first appearance: people check it against their own list by eye.
Privacy
Localno server
The list is processed in your browser and never sent anywhere. That matters more than it sounds: lists routinely carry email addresses, phone numbers and order ids — data that has no business reaching someone else's server for a separator change.
04
Frequently asked questions
Updated