Find duplicate rows in Excel — without uploading the file

Drop in a spreadsheet and see every duplicated row — or every duplicated value in one column, like an invoice number or email address. Then download the duplicates, or the file with them removed. Works with .xlsx, .xlsm and .csv.

✓ 100% in your browser — your file never leaves your computer

Your spreadsheet
Drop a spreadsheet here
or click to browse — .xlsx, .xlsm or .csv

How it works

  1. Drop in the file. Only the first sheet of a workbook is checked.
  2. Choose what counts as a duplicate. "Entire row" flags rows where every column matches — double-pasted data, repeated imports. Or pick one column, like Invoice Number or Email, to catch rows that differ elsewhere but share the value that should be unique. We suggest the most identifier-like column automatically.
  3. Review the groups, then export. Each group shows the duplicated value, how many copies exist, and which row numbers they're on. Download all duplicates as a CSV to investigate, or download the file with every extra copy removed (the first occurrence is kept).

Duplicates Excel's own tool misses

Excel's Remove Duplicates button compares text exactly — so ACME Ltd, acme ltd and  Acme Ltd  count as three different customers, and it deletes rows immediately rather than showing you what it found. This tool ignores capitalisation and stray spaces by default (you can turn that off), and always shows you every group before anything is removed. Rows with a blank value in the chosen column are never treated as duplicates of each other.

Is anything uploaded?

No. The file is read with your browser's own file APIs and checked by JavaScript running on your machine. There is no server to upload to — this page ships with a Content-Security-Policy that makes your browser block outbound requests. Here's how to verify that yourself, including with your Wi-Fi off.

How big can the file be?

Tested to 500,000 rows / 38 MB on an ordinary laptop — see the published benchmark. Parsing runs on a background thread, so the page stays responsive while big files load.

Comparing two versions instead?

If the question is "what changed between these two files" rather than "what's repeated inside this one", use the free compare two Excel files tool — added, removed and changed rows, matched by ID.

← Prism — the review step before you trust the file