Remove Duplicates from a List
Paste a list below — one item per line — and this tool returns only the unique values, in their original order. It also tells you how many duplicates it removed. Great for cleaning email lists, IDs, SKUs, or any column copied from Excel or Google Sheets.
Everything happens in your browser. Nothing is uploaded.
apple banana Apple cherry
How to remove duplicates in Excel and Google Sheets
In Excel: select your range, then Data → Remove Duplicates. Excel deletes duplicate rows in place and reports how many it removed.
In Google Sheets: use Data → Data cleanup → Remove duplicates, or the formula =UNIQUE(A2:A100) to output a deduplicated list in a new column without touching the original.
This tool is handy when you just need a quick, private dedupe without opening a spreadsheet.
Case sensitivity and whitespace
By default, 'Apple' and 'apple' are treated as different values and leading/trailing spaces matter. Toggle the options to ignore case or trim whitespace so near-identical entries collapse into one.
Frequently asked questions
How do I remove duplicates without deleting the original data?
In Google Sheets use =UNIQUE(range) to output a clean list in a new column. In Excel, copy the column first, then run Data → Remove Duplicates on the copy. This tool never changes your source — it just shows the unique result.
Does this keep the original order?
Yes. The first occurrence of each value is kept in its original position; later duplicates are removed.
Is my list uploaded anywhere?
No. Deduplication runs entirely in your browser using JavaScript.
Keep exploring
Analyze a whole spreadsheet with AI
Upload an Excel or CSV file and get pivots, outlier detection, and Smart BI dashboards in seconds. Free to start — no credit card.
Open the App Free