Find and remove duplicate rows in Excel
Find and remove duplicate rows in Excel by one column, multiple columns, or entire rows. Keep first, last, or unique records and download kept and excluded rows.
Preparing the tool…
How to find and delete duplicate rows in Excel
- Choose one file and one worksheet. Check duplicates by 1–3 selected columns or by all business values in a row.
- Review duplicate groups, actual Excel row numbers, and differing values. Original business values, including leading and trailing spaces, are compared as they are.
- Keep the first occurrence, the last occurrence, or only records without duplicates. Confirm groups with differing values before downloading data results.
The check report includes duplicate groups, source rows, and issues. Data results include the records kept by your chosen rule and the excluded records. Your source file stays unchanged.
Review a sample with 153 sales-order rows
Download the fictional sales-orders.xlsx file, or choose Try sample files above. Select Order ID as the match column. The sample has 15 duplicate groups containing 45 rows, 105 unique rows, and 3 rows with blank IDs. Seven duplicate groups have differing business values and need confirmation before downloading data results. The original workbook stays unchanged.
| Rule | Kept rows | Excluded rows |
|---|---|---|
| Keep first | 123 | 30 |
| Keep last | 123 | 30 |
| Keep unique only | 108 | 45 |
Find duplicates in one column or an entire row
Choose Selected columns and select the ID column to find records that share that ID, even when their other values differ. Choose Entire rows to compare all business values. Source file, sheet, and row references identify where a record came from. Original values are compared as stored, including spaces and value types.
Remove duplicates based on two columns
For an order with several products, select Order ID and SKU together. Rows with the same order but a different SKU stay separate. You can select 1–3 columns. If the same Order ID and SKU still appear on several legitimate lines, add another identifying field or review the group before removing records.
Keep the first, last, or only unique records
First and last refer to the original sheet row order. Keep last does not select the most recent date automatically. Keep unique only excludes every row in a duplicate group. Rows with blank match values or other check issues remain in the data and appear in the check report; that is why this sample keeps 108 rows with the unique-only rule.
Download the kept and excluded records
Review conflicts before downloading data results. The data workbook includes both kept and excluded rows, so you can trace what was removed. Use the check report for duplicate groups, source rows, and issues. To find changed, added, or missing records across two files, follow the comparison guide.
What this tool supports
Use regular .xlsx and .xls tables with headers in the first row. Hidden rows are included; entirely blank rows are skipped. Saved formula results are used without recalculation. Output files are new workbooks and do not preserve source formulas or formatting.
.xlsx and .xls, with headers in the first row. Up to 10 MiB per file and 30 MiB in total. Up to 10,000 rows and 50 columns per sheet, with 1 million input cells in total. Exports have a separate 1 million cell limit, including source references and issue sheets. Processing time depends on your device.
Text “001”, text “1”, and numeric 1 are different values. Date text is not automatically converted to a date. Integers with an absolute value of at least 10¹⁵ in match columns are flagged for possible precision loss; lost digits cannot be recovered.
Some output cells contain errors or missing formula results. Review the issues and fix the input before downloading data results. The check report is available.
What happens to blank IDs and records that cannot be checked reliably?
Blank match values, cell errors, missing formula results, and risky integers are kept and listed for review rather than automatically removed. Entire-row checking allows ordinary blank cells in comparisons; errors and missing formula results are still flagged.
Are my files uploaded or saved between visits?
Duplicate checking, combining sheets, and adding columns also run locally. Downloads are new files; source files are unchanged. These tools do not save cloud files or task history. Leaving will clear the current files and results. Make sure you have downloaded what you need.
Page visits and fixed tool actions may be collected when analytics is enabled. Spreadsheet contents and results are not attached. A download action means the browser generated the file and triggered a download; it does not confirm that the file was saved to disk.
Read the privacy details