Productivity

4 Ways to Remove Duplicates in Excel and CSV Files

Duplicate rows break reports and mailing lists. Learn four quick ways to find and remove duplicates in Excel, Google Sheets and large CSV files.

Illustration: 4 Ways to Remove Duplicates in Excel and CSV Files

Duplicates creep in when lists are merged, exported twice or typed by hand. Before you remove them, decide what “duplicate” means for your data: every column identical, or the same value in a key column such as email or order ID.

1. Excel's Remove Duplicates

Select the data, go to Data → Remove Duplicates, tick the columns that define a duplicate and click OK. Excel keeps the first occurrence and deletes the rest. Make a copy first — this cannot be undone after you save.

2. Google Sheets

Select the range and choose Data → Data cleanup → Remove duplicates. As in Excel, you can pick which columns to compare.

3. Find duplicates before deleting them

Sometimes you need to see duplicates rather than delete them — for example, two customers with the same email but different orders. In Excel, add a helper column with =COUNTIF(A:A, A2); any value above 1 is repeated. Or use the Excel Duplicate Finder, which lists each repeated value, how many times it appears and in which rows.

4. Online tools for any file, including huge CSVs

  • Excel Duplicate Remover — works with XLSX, XLS and CSV; compare all columns or chosen key columns.
  • CSV Duplicate Remover — streams large CSV files, so exports with hundreds of thousands of rows don't freeze your browser.

Both run in your browser, so customer data stays on your computer.

Clean before you compare

“john@example.com ” (with a trailing space) and “John@Example.com” look different to a computer. Trim spaces and fix case first with the Excel Data Cleaner, then remove duplicates.

Frequently asked questions

Which row does Excel keep when removing duplicates?

The first occurrence from the top; later matching rows are deleted.

Can I remove duplicates based on one column only?

Yes. In Excel, Google Sheets and the online remover, choose only the key column (for example email).

Keep reading