How to remove duplicate lines from a list (without Excel)
If you have a list — emails, URLs, SKUs, keywords — and you just need the duplicates gone, you don't need a spreadsheet. You can paste the list, get a clean deduplicated version, and copy it back out in a few seconds. And because it runs entirely in your browser, the list never gets uploaded anywhere.
The fastest way: paste, dedupe, copy
Open the Remove duplicate lines tool, paste your list into the input, and the deduplicated result appears instantly. Each unique line is kept once, in its original order, and every repeat is dropped. Copy the output, and you're done.
- Paste your list (one item per line) into the input.
- The tool keeps the first occurrence of each line and removes the rest.
- The tally shows how many duplicates were removed.
- Copy the clean list, or download it as a
.txt.
Why not Excel?
Excel can do it — Data → Remove Duplicates — but it's slower for a quick one-off: you open the app, paste into a column, run the dialog, then copy back out. For a list you found in a log, an export, or a chat message, a browser tool is one paste away. It also handles messy real-world text (blank lines, trailing spaces, mixed case) without you writing a formula.
Case sensitivity and whitespace
By default, Apple and apple are treated as different lines, because they are different strings. If you want a case-insensitive dedupe, normalize the case first with the Case converter, then remove duplicates. Leading and trailing spaces also make otherwise-identical lines look unique — trim them first if your source is inconsistent.
Is it private?
Yes. Every TextArray tool runs locally in your browser — there is no server that receives your text, no upload, and no account. That matters when the "list" is customer emails, internal IDs, or anything you shouldn't paste into a random website. You can confirm it: once the page has loaded, the tool keeps working with your network disconnected.
Counting what's left
After deduping, you often want to know how many items remain. Drop the cleaned list into the Word counter to get an exact line and item count — useful when you're reconciling against an expected total.