Saved

Press the star next to a tool's name to save it.

All my tools

Excel Remove Duplicates

Upload an Excel or CSV file and choose which columns make a row a duplicate. Excel Remove Duplicates keeps the first (or last) copy, lists the rows it removed and gives you a clean file. Your file never leaves your device.

Blank rows are left in place.

Your file is processed on your device and never uploaded.

Duplicate rows removed

–

Upload a file and click Remove duplicates.

Excel Remove Duplicates cleans duplicate rows out of a spreadsheet. Upload an Excel workbook or a CSV file, choose whether to compare whole rows or only some columns, such as the email column of a mailing list, and download a copy with the duplicates removed. The tool also lists every row it took out and which earlier row it matched, so you can check the result. For example, a contact list of 1,200 rows where 80 people appear twice comes back with 1,120 rows.

How to use Excel Remove Duplicates

  1. Upload your file: XLSX, XLS, XLSM, ODS, CSV or TSV.
  2. Choose the sheet if the workbook has more than one.
  3. Keep “first row is a header” ticked if row 1 holds column names, so it’s never treated as data.
  4. Pick the columns to compare. Tap column names to select them. With none selected, whole rows must match.
  5. Choose the options: ignore case, ignore extra spaces, and keep the first or the last copy.
  6. Click Remove duplicates, review the removed rows and download the clean file.

Whole rows or chosen columns?

Comparing whole rows only removes exact repeats, which is safe when the same record was pasted twice. Comparing chosen columns is more powerful. On a mailing list, comparing just the email column removes people who signed up twice with different names or spelling. On an order list, comparing the order number column removes repeated imports. Think about which columns identify a record before you choose.

RowNameEmailCity
2Annann@example.comAustin
3Bobbob@example.comBoston
4annANN@example.comAustin
5Annann@example.comDallas

With whole rows compared and case ignored, only row 4 is a duplicate of row 2, since row 5 has a different city. Comparing only the Email column removes both rows 4 and 5.

Matching options

  • Ignore case treats “ANN@example.com” and “ann@example.com” as the same, which you usually want for emails and names.
  • Ignore extra spaces trims spaces at the start and end of each cell, a common problem with copied data.
  • Keep first or last decides which copy stays. Keep last if newer entries are added at the bottom and you want the latest details.

Completely blank rows are left as they are, so the layout of your sheet doesn’t change.

What you get back

An Excel file downloads as XLSX with every sheet included; only the sheet you cleaned changes. A CSV file downloads as CSV. Cell values are kept, but formatting such as colors, column widths and formulas on the cleaned sheet isn’t, because the rows are rewritten as values. Keep your original file, and paste the clean data back into it if you need the formatting.

Doing it in Excel itself

Excel has a built-in Remove Duplicates command on the Data tab: select your data, choose the columns to check and click OK. It deletes rows straight away, so Microsoft suggests copying your data first. This tool is useful when you want to see which rows will go before they’re removed, ignore extra spaces, keep the last copy instead of the first, work with a CSV without opening Excel, or clean a file on a computer without Excel installed.

Tips for cleaner data

  • Fix formats first. “(555) 010-1234” and “555-010-1234” won’t match. Make phone numbers and dates consistent before you dedupe.
  • Check near-duplicates by hand, such as “Jon Smith” and “John Smith”, which no exact match will catch.
  • Sort before you share. Sorting by the key column makes it easy to spot anything left over.
  • Keep a backup of the original file before replacing it.

Private by design

The file is read and cleaned in your browser with the SheetJS library. Nothing is uploaded, so you can safely clean customer lists, payroll exports and other private data.

Common uses

  • Mailing lists: remove people who signed up more than once before you send a newsletter, so nobody gets two copies.
  • Merged exports: clean up rows repeated when two reports or systems are combined.
  • Inventory and product lists: find SKUs entered twice.
  • Survey results: drop repeat submissions by matching an email or ID column.
  • Attendance and sign-up sheets: keep one row per person.

Finding duplicates without removing them

If you’d rather review duplicates before deciding, run the tool and look at the removed rows table. It shows the row number of each duplicate and the row it matched, so you can find both in your original file and decide what to keep.

Large files

Files up to 50 MB work, which is usually hundreds of thousands of rows. Very large workbooks can take a few seconds to read on older phones and laptops, because all the work happens on your device. If a file is too large, split it with the CSV splitter, clean each part, then combine them, and run the tool once more on the combined file to catch duplicates across parts.

To compare two versions of a file, use Excel compare two sheets. For a plain list of lines, the line sorter can sort and remove duplicate lines.

What next

Use this often? Add Excel Remove to your Home screen.

Frequently asked questions

How does Excel Remove Duplicates decide what is a duplicate?

A row is a duplicate when the columns you chose match an earlier row. With no columns chosen, every cell in the row must match.

Can I remove duplicates based on one column?

Yes. Tap the column name, such as Email, and only that column is compared.

Will my formatting be kept?

Cell values and other sheets are kept. Formatting and formulas on the cleaned sheet are replaced by values.

Is my file uploaded?

No. The file is read and cleaned in your browser and never leaves your device.

What went wrong?

We only receive the reason you pick, never what you typed into the tool.

Thanks for your feedback.

More Office & Productivity Tools