@PullEmails
Guide

How to remove duplicate emails in Excel, Sheets, Gmail & Outlook

Last updated 3 July 2026

Duplicates inflate your counts, waste sends and can hurt deliverability. Here's how to strip them out — the one-paste method, plus the native steps for every common app.

Quick answer: To remove duplicate emails fast, paste your list into a browser-based deduplicator — it removes every repeat instantly and case-insensitively. In Excel, use Data → Remove Duplicates (or =UNIQUE()); in Google Sheets, use =UNIQUE(); in Gmail/Outlook, merge duplicate contacts from the address book.

Method 1 — Paste it in (fastest, case-insensitive)

Spreadsheet tools treat Sam@Acme.io and sam@acme.ioinconsistently, and they can't clean a list that's spread across commas or semicolons. A dedicated deduplicator handles all of it:

  1. Copy your addresses from wherever they are.
  2. Paste them into the remove duplicate emails tool.
  3. Every repeat is removed instantly — case-insensitively — with a count of how many were dropped.
  4. Copy the clean list or download it as TXT or CSV.

It works on line-, comma- or semicolon-separated lists, and nothing is uploaded.

Method 2 — Remove duplicate emails in Excel

Option A: Remove Duplicates (any version)

  1. Select the column of email addresses.
  2. Go to the Data tab and click Remove Duplicates.
  3. Confirm the column, click OK. Excel deletes the repeats in place and reports how many it removed.

Option B: the UNIQUE function (Excel 365 / 2021)

Leave your original data untouched and return a clean list in a new column with: =UNIQUE(A2:A1000). It updates automatically as the source changes. Both approaches treat different letter cases as the same value.

Method 3 — Remove duplicate emails in Google Sheets

Two easy options:

  • UNIQUE function: put =UNIQUE(A2:A) in an empty column to list every address once.
  • Menu: select the range, then Data → Data cleanup → Remove duplicates.

Method 4 — Merge duplicate contacts in Gmail & Outlook

If your duplicates are contacts rather than a plain list, dedupe them in the address book:

  • Gmail / Google Contacts: open Google Contacts, then choose Merge & fix in the left menu — it groups and combines duplicate people for you.
  • Outlook: duplicates are usually handled at import time (you're asked whether to allow or skip them). To clean existing ones, switch to People view and remove repeats, or re-import with "do not import duplicates" selected.

Then validate and clean

De-duplication is one step. For a genuinely import-ready list, alsovalidate the addresses to catch typos, or run everything through theemail list cleaner, which removes duplicates, invalid addresses and role accounts (info@,noreply@) in a single pass. Need to pull the addresses out of a spreadsheet first? Seehow to extract emails in Excel & Google Sheets.

Frequently asked questions

How do I remove duplicate emails from a list quickly?

Paste the list into a browser-based deduplicator like PullEmails and it removes every repeat instantly, case-insensitively, then lets you copy or download the clean list. It's faster than spreadsheet steps and nothing is uploaded.

How do I remove duplicate emails in Excel?

Select the column, go to the Data tab, and click Remove Duplicates. Or, in Excel 365, use =UNIQUE(A2:A1000) to return a de-duplicated list in a new column. Note that Excel treats different letter cases as the same value here.

How do I remove duplicate emails in Google Sheets?

Use the UNIQUE function: put =UNIQUE(A2:A) in an empty column to get every address once. Alternatively, select the range and choose Data → Data cleanup → Remove duplicates.

Are Sam@acme.io and sam@acme.io duplicates?

For email delivery, yes — the mailbox is the same regardless of case. A good deduplicator treats them as one. PullEmails removes case-insensitive duplicates by default, so mixed-case repeats are caught.

How do I merge duplicate contacts in Gmail or Outlook?

In Google Contacts, open the left menu and choose 'Merge & fix' to combine duplicate people automatically. In Outlook, duplicate handling happens on import (choose whether to allow or skip duplicates), or use People view to delete repeats manually.

More guides

How to extract email addresses in Excel & Google SheetsThree ways to pull email addresses out of a spreadsheet — the fastest paste-in method, plus native Excel and Google Sheets formulas.What makes an email address valid? Email format rules explainedThe anatomy of a valid email address, the rules for the name and domain, the typos that break addresses, and why format checks differ from mailbox verification.How to extract email addresses from a PDFThe one-minute copy-paste method that works with any PDF reader, how to handle scanned PDFs with free OCR, and why multi-column layouts don't break extraction.How to clean an email list before importingCut bounces and protect your sender reputation: what to remove from an email list — invalid addresses, duplicates and role accounts — and the fastest way to do it.