Remove Excel duplicates

Keep the first matching row and remove later duplicates from an XLSX worksheet.

Processing settings

How to use Remove Excel duplicates

  1. 01

    Select one XLSX workbook and choose all columns or a specific column.

  2. 02

    Run deduplication; later rows with the same comparison value are removed.

  3. 03

    Download the result and review the remaining row count and key records.

Frequently asked questions

Which duplicate row is kept?

The first matching data row is kept in its original position. Later matching rows are removed.

How does the column option work?

Choose 0 to compare entire rows, or use 1 for column A, 2 for column B, and so on.

You may also need

Excel to CSV

Convert the first worksheet of an XLSX file to a UTF-8 CSV for data import.

CSV to Excel

Turn a UTF-8 CSV into an XLSX worksheet while keeping entries as text.

Merge Excel files

Append rows from XLSX files with matching headers into one worksheet.

Remove Excel duplicates - Free online tool | fileoar