About
The step before every other tool on this site. Paste a column that came out of a spreadsheet, a chat message, or an export, and get back something without repeats, blank lines, or stray whitespace.
How to use
Paste the text and press the operation you want: deduplicate, drop blanks, sort, reverse, change case, or extract the emails or numbers. Operations stack, so run several in sequence.
The operations, and the order to run them
Drop blanks first, since they distort everything after. Normalise case next if the list came from more than one source. Deduplicate third, once identical entries actually look identical. Sort last, because it makes the result readable and makes a leftover duplicate obvious. Running them in another order is not wrong, it just produces more passes.
Pulling structure out of noise
Extraction is for the case where the useful data is buried in text you did not choose: a log fragment, a pasted email thread, a support ticket. Rather than editing it by hand, pull out the addresses or the numbers and work with what comes back. Check the result before using it, because pattern matching over messy text will occasionally grab something that merely looks like an address.
Why this is the first stop
The checkers on this site are metered by the hour, so a duplicated list spends the budget twice on the same account. Blank lines and full URLs pasted where a username belongs both produce failed rows that look like dead accounts. Cleaning the column first turns a confusing run into a clean one, and it costs nothing because it never leaves your browser.
FAQ
Does deduplicating respect case?
Two lines differing only in case may survive as separate entries. Normalise the case first if you want them treated as one.
Is my list uploaded?
No. Every operation runs in the page, which is why it is safe to paste a list of customer addresses.
Will extracting emails catch every one?
It catches ordinary addresses reliably. Obfuscated forms such as name at example dot com are text rather than addresses, and it will not reconstruct them.
How large a list can it take?
Tens of thousands of lines are fine. Beyond that the tab slows down, because the whole thing sits in browser memory.
Related tools
- Developer and text tools
- JSON Formatter
Format, minify and check JSON in the browser.
- URL Encoder and Decoder
Percent encode or decode text, locally.
- Unix Timestamp Converter
Convert between epoch timestamps and dates.
- User Agent Parser
Break a UA string into browser, OS and device.
- CSV to Table
Split delimited text into a table, copy as CSV or TSV.
- Online Notepad
A scratch note kept in your own browser.