How to find duplicates in a list with Maplesheet

If you have a list of names, emails, SKUs, or URLs and you want the duplicates out, opening Excel and writing formulas is overkill. You need a textbox, a button, and a clean list to copy back.

Maplesheet's list deduplicator gives you that. Paste your list, choose how strict the match should be, and copy the cleaned result. It also catches fuzzy duplicates, the kind Excel's Remove Duplicates misses, like john@x.com vs John@x.com or Acme Inc vs Acme, Inc..

How to use it

1. Open the tool

Go to maplesheet.com/find-duplicates-list. Nothing to install, no file to upload.

2. Paste your list

Drop your values into the textbox, one per line. Empty lines and surrounding spaces are ignored, so messy copy-paste from emails or PDFs is fine.

3. Choose how strict the match should be

The Similarity threshold slider runs from Fuzzy (0%) to Exact (100%):

• 100%: only identical values match. Same as a plain text comparison.
• 90–99%: catches trailing spaces, capitalization, and small typos (acme inc vs Acme Inc.).
• 70–89%: catches looser variations (John Smith vs Jon Smyth). Useful for customer names, addresses, free-text entries.

Start at 100% and lower it if you suspect inconsistent data.

4. Click Find

Two panels appear side by side:

• Left — every duplicate group, with the first value marked (kept) and the rest pre-checked for removal.
• Right — the cleaned list, ready to copy.

5. Review and adjust

Uncheck any value you'd rather keep. As soon as you do, it pops back into the deduped list on the right. The counter at the top of the right panel always shows how many items were removed.

6. Copy the cleaned list

Click Copy under the deduped list. Paste it wherever you need it: back into Excel, a form, a CRM, an email.

Tips

• Order is preserved. The deduped list comes out in the same order you pasted it in, with the first occurrence of each value kept.
• Case-sensitive matching? Set the slider to 100% — case differences will show up as separate values.
• Don't trust the default removals. Always glance at the left panel before copying. At lower thresholds, the tool may group values you want to treat as distinct.
• Large lists. Tens of thousands of lines work fine.

FAQ

What counts as a duplicate? At 100%, only exact text matches. Below 100%, the tool uses similarity scoring so close-but-not-identical values get grouped together. The lower the threshold, the looser the matching.

Can I get the duplicates instead of the deduped list? The duplicates panel on the left shows every group, with the kept value and the removed values clearly labeled. You can read or copy from that panel directly.

Will it keep the original order? Yes. The first occurrence of each value stays where it was; only the later repeats are removed.

What if I paste comma-separated values on one line? Split them onto separate lines first (find-and-replace , → newline). The tool treats each line as one value.