Skip to content
Allin
Sign up · Sign in

Remove duplicate rows

Delete rows that repeat an earlier row exactly, keeping the header and the first occurrence. Works with Excel (XLSX, XLS, XLSM, XLSB), OpenDocument (ODS), Apple Numbers, CSV and TSV.

10 / 10 free files today

Related tools

All Spreadsheets tools →
Remove empty rowsStrip every row whose cells are all blank, closing the gaps left by an export. Works with Excel (XLSX, XLS, XLSM, XLSB), OpenDocument (ODS), Apple Numbers, CSV and TSV.Remove empty columnsDrop columns that hold no value in any row — the trailing columns exports leave behind. Works with Excel (XLSX, XLS, XLSM, XLSB), OpenDocument (ODS), Apple Numbers, CSV and TSV.Remove duplicate linesDelete repeated lines while keeping the original order of the first occurrences.Remove duplicate wordsKeep only the first occurrence of each word in your text.CSV to ExcelConvert a CSV file (or pasted CSV) into a real .xlsx spreadsheet.Extract Excel formulasList every formula in a workbook with its sheet and cell, to audit or document it. Reads Excel (XLSX, XLSM), OpenDocument (ODS) and Apple Numbers, in any language — a French SI() or a German WENN() comes out as written. XLS and XLSB carry formulas that this reader cannot always surface, and CSV or TSV hold none by design: they store results, never formulas.Excel to CSVConvert an .xlsx or .xls sheet to CSV, pick which sheet.Convert formulas to valuesReplaces every formula by the result Excel last saved with it, so the sheet keeps its numbers but no longer shows how they were obtained — useful before sending a file out. Nothing is recalculated: a workbook saved without cached results comes back empty. Works with Excel (XLSX, XLS, XLSM, XLSB), OpenDocument (ODS), Apple Numbers, CSV and TSV — though CSV and TSV never hold formulas to begin with.

Remove duplicate rows is free to use as often as you like, directly from this page. It covers XLSX, XLS, XLSM, XLSB — adjust any of them and the result follows immediately.

How to use it

  1. Open the tool — no signup or install needed.
  2. Enter your input or adjust the available options.
  3. Get your result instantly, then copy or download it.

Frequently asked questions

What is Remove duplicate rows?

Delete rows that repeat an earlier row exactly, keeping the header and the first occurrence. Works with Excel (XLSX, XLS, XLSM, XLSB), OpenDocument (ODS), Apple Numbers, CSV and TSV.

What does it take into account?

It factors in XLSX, XLS, XLSM, XLSB. Change any of them and the output follows immediately.

When would I actually use this?

Getting a table out of a workbook and into something else — JSON for an API, CSV for an import, HTML for a page — opening a file whose software you do not have, and cleaning a sheet before you hand it on.

What is the most common mistake?

Expecting the formula to survive the trip. A converted file carries the last value the spreadsheet computed, not the calculation behind it — and a workbook written by a program can carry the formula with no cached value at all, which most readers discard along with the cell.

How is Remove duplicate rows different from Remove empty rows?

They sit next to each other but answer different questions: Remove empty rows is the one to open when you need it to strip every row whose cells are all blank, closing the gaps left by an export. Works with Excel (XLSX, XLS, XLSM, XLSB), OpenDocument (ODS), Apple Numbers, CSV and TSV. Pick whichever matches what you're starting from — both are free.

Is there a tool for the next step?

Remove empty columns is the closest one after this: Drop columns that hold no value in any row — the trailing columns exports leave behind. Works with Excel (XLSX, XLS, XLSM, XLSB), OpenDocument (ODS), Apple Numbers, CSV and TSV.

Where do the figures come from?

Nothing leaves the browser. An .xlsx and an .ods are both zipped XML, read here against their published specifications. Dates are the fragile part — a spreadsheet date is a number counted from an epoch the workbook itself declares, so the same 45000 is two different days depending on a flag most files never show you.

Further reading

All guides →
ExplainerThe Number 1 and the Text "1" Are Not DuplicatesDeduplication compares whole rows exactly, cell type included. Five identical-looking rows came out as three, because one held a number, one a string and one a string with a leading space.ExplainerConverting Formulas to Values Keeps the Cached Answer, Not the CalculationA spreadsheet file stores both the formula and the last answer Excel computed. Stripping the formula leaves the stored answer — and leaves a blank wherever the file never carried one.ExplainerWhy Your CSV Breaks Accents and Dates in ExcelThree completely different faults hide behind the same sentence. One is the encoding, one is the separator, one is Excel guessing at types while it opens the file — and the fix for each is different. Here is how to tell them apart in five seconds.ComparisonXLS, XLSX, XLSM and XLSB: Which Is Which, and Which You WantFour extensions, three of them the same box with different lids. Rename an XLSX to .zip and it opens — that single fact explains the whole family, and explains why XLS, which does not, is the one still causing trouble.ExplainerFinding Duplicates in a List Without a SpreadsheetTwo lines that look identical are often not identical. Case, a trailing space, a no-break space and two different encodings of the same accented letter were each run through the duplicate finder, and it reported no duplicates for three of the four.ExplainerSemicolon, Tab, Pipe: Choosing a Delimiter That Survives the TripWhy the reader's language decides the delimiter, what the converter does to the quoting when you switch, what the sep= first line really is, and the count of quoted cells on the same export written five ways.