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
01Process02Compare03About lists04Questions05Related
01

Process a list

the result updates as you type — no button to press
Source 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 lists

What 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

Format
column ↔ 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

Cleanup
42 → 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

Order
file2 → 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

Wrapper
IN ('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

Sets
A ∩ 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

Local
no 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

Paste the list, set the input separator to «line break» and the output separator to «comma». The column becomes a single line with values joined by a comma and a space, which reads well and pastes straight back into text. The reverse task works the same way with the separators swapped: comma in, line break out. Everything recalculates as you type — there is no «convert» button to press.

Updated

«» added to favorites