Skip to main content
OfficeFreeTools

Free. Private. No signup. Files are processed locally in your browser.

Remove Excel Duplicates

Remove duplicate rows from a spreadsheet, in the browser.

Add an Excel (.xlsx) or CSV file to clean

Up to 20 MB. For workbooks, you choose which sheet to clean — the rest of the workbook is preserved. Processed locally — never uploaded.

or drag & drop files here

Private by design: this tool runs in your browser. Your files are processed locally on your device and are never uploaded to a server.

How to use Remove Excel Duplicates

  1. Add your .xlsx or .csv file using the drop area or the Browse button (for workbooks, pick the sheet to clean — the rest of the workbook is preserved).
  2. Leave “First row is a header” ticked if your file has column titles — the header is always kept.
  3. Choose how rows are compared: “All columns match” removes only identical rows; “The chosen columns match” lets you tick key columns such as Email.
  4. Read the kept/removed counts, then download the cleaned file — it comes back in the same format you uploaded.

Frequently asked questions

Which row is kept when duplicates are found?

The first occurrence is kept and later duplicates are removed, so the order of your data never changes.

Is the comparison exact?

Yes. Values must match exactly — letter case and spaces count, so “Alice ” and “Alice” are treated as different. A number and its text form (42 and “42”) count as the same value, and a formula cell compares by its last calculated result, not by its formula text. A formula cell with no stored result is never treated as a blank — workbooks containing one are blocked from in-place cleaning by the preflight.

What happens to the rest of my workbook?

For plain-data .xlsx files the chosen sheet is cleaned inside your original workbook: other sheets are untouched, and kept rows keep their formatting, formulas, hyperlinks, dates and column widths. Before cleaning, a preflight checks the workbook for anything row removal could silently damage (see the next question); if it finds a risk, in-place cleaning is blocked instead. CSV files contain values only, so a cleaned CSV is values-only by nature.

Why was in-place cleaning blocked for my workbook?

The preflight found something that removing rows could silently change or damage: formulas in the sheet you picked or in other sheets (their references are not adjusted when rows move), formula cells with no stored calculated value or with an error result, merged cells, or structures such as tables, images, conditional formatting, data validation or an auto-filter on the sheet. The warning on the page lists exactly what was found. You can still download a values-only copy of the cleaned sheet: a new workbook with only that sheet as plain values — formulas become their last calculated values, a formula with no stored value becomes a blank cell, and other sheets and formatting are not carried over.

Is my spreadsheet uploaded?

No. The file is read, cleaned and rebuilt in your browser; nothing is sent to a server.

What format do I get back?

The same format you uploaded: an .xlsx file comes back as a cleaned .xlsx, and a .csv comes back as a cleaned .csv.

Why do some cells start with an apostrophe in the cleaned CSV?

Formula-injection protection, on by default for CSV downloads: text starting with =, +, − or @ (even after spaces or tabs) is prefixed with ' so Excel and Google Sheets display it as text rather than running it as a formula. Genuine numbers are never changed. The value itself is changed — it gains a leading apostrophe — and apps treat that prefix differently (some hide it, LibreOffice keeps it visible), and an app that hides it can drop it when re-saving the file as CSV, so the protection may not survive a re-save. You can untick the protection for a raw export, but that file is unsafe to open in a spreadsheet app.