Duplicate Finder: How to Find and Remove Duplicate Rows in Excel, Google Sheets, and CSVs

Duplicate rows are one of the most common data-quality problems: the same customer appears twice in a CRM export, the same SKU shows up three times in an inventory spreadsheet, or a merged mailing list has hundreds of people on it twice. Every duplicate wastes time, skews reports, and can cost real money in mis-sent campaigns or double orders. This guide covers the fastest ways to find and remove duplicates in Excel, Google Sheets, and raw CSV files — no coding required.

If you’re working with a CSV or a pasted table right now, you can paste your data into our free Duplicate Finder tool and get a cleaned list in seconds.

Why Duplicates Are So Common

• Merged exports: combining this month’s and last month’s customer lists without a unique ID.
• Manual entry: “John Smith” vs “John A. Smith” vs “[email protected]” entered on different days.
• Appended downloads: re-downloading a report and appending it to the old file.
• Case and spacing differences: “Acme Corp” vs “acme corp” are duplicates to a human but different strings to a computer.

Fastest Ways to Remove Duplicates

Tool	Method	Best For
Excel	Data → Remove Duplicates (select columns to check)	One-off cleanup in a workbook
Excel	Conditional Formatting → Highlight Duplicate Values	Reviewing before deleting
Google Sheets	Data → Data cleanup → Remove duplicates	Collaborative sheets
Google Sheets	=UNIQUE(range) formula	Creating a cleaned copy without touching the original
CSV / any data	Paste into an online Duplicate Finder	Quick cleanup with no app installed

Excel: Step by Step

1. Select the range or the entire table that may contain duplicates.
2. Go to Data → Remove Duplicates.
3. Choose which columns to check: checking only “email” removes rows with the same email, while checking all columns removes rows that are identical everywhere.
4. Click OK — Excel keeps the first occurrence and reports how many duplicates it removed.

If you’re unsure whether two rows are truly the same person, check only the unique identifier column (email, order number, customer ID) instead of all columns — that’s usually the safest definition of a duplicate.

Google Sheets: Step by Step

1. Select your data range (including headers).
2. Open Data → Data cleanup → Remove duplicates.
3. Check “Data has header row” if your sheet has one.
4. Choose the columns to compare, then click Remove duplicates.

To keep the original data untouched, use the =UNIQUE(A2:C500) formula in a new sheet instead — it returns only the first occurrence of each unique row and updates automatically as you edit the source.

Near-Duplicates: When “Same” Isn’t Exact

Exact-match deduplication misses “John Smith” vs “John A. Smith” or “Acme Corp” vs “Acme Corporation.” If your data has this problem, normalize it before deduplicating:

• Trim leading and trailing spaces and collapse double spaces.
• Convert everything to one case (lowercase is standard).
• For names, standardize on a format (first + last, or add a separate unique ID column).
• For addresses, remove punctuation like periods in “St.” vs “St”.

There’s no built-in fuzzy matching in Excel or Google Sheets, so for messy real-world data, the practical approach is to sort by the suspect column and eyeball the remaining candidates after exact deduplication — usually a handful of rows rather than thousands.

Before You Delete: 3 Checks

• Back up the file first. Keep the original so a bad cleanup is reversible.
• Decide which record wins. If one row has a filled-in field the other lacks, keep the more complete one.
• Normalize text first. Trim spaces and standardize case before deduplicating, or “Acme Corp” and “Acme Corp ” will slip through.

Clean data makes every downstream task easier — reporting, mail merges, and customer segmentation. Paste your next messy export into our Duplicate Finder and it’s done in one pass.