Skip to content

Remove Duplicates

Remove duplicate rows in Excel

Find repeated records, inspect their rows, and choose what stays before creating a cleaned workbook copy.

Open Remove Duplicates

Choose what counts as a duplicate

Open a supported workbook and select all columns or specific key columns. Exact typed values distinguish numbers, text and blanks. Optional case and surrounding-space analysis does not rewrite source values.

Review the rows to keep

Choose an explicit keep policy and inspect differing non-key fields. Resolve conflict groups before removal; row position alone does not establish which record is newest.

Keep a verified copy

Review removals and supported formula changes before downloading the cleaned copy and removal review. The original is untouched; unsupported structural edits are refused.

Does keep-last mean the newest record?

Keep-last refers to row order, not a timestamp. Inspect date fields and conflicting values before choosing a survivor.

Can it find arbitrary spelling mistakes?

Exact and supported case/space comparisons identify specific repeated values. They do not provide general fuzzy matching for unrelated typos. Automated Excel Cleanup Without Losing Formulas or Formatting.

What does removal cost?

Remove Duplicates uses 5 tokens for a completed local action. A verified account receives 200 starting tokens once; the workflow shows the cost before confirmation.

Related tools