Install DoPDFNow on this device. It opens like an app, free.
DoPDFNowFiles never leave your devicePremiumSign in

Remove duplicates in Excel finds repeated rows and keeps only the first one. Compare every column, or only the columns you choose, like a phone number or email, and ignore differences in capital letters and spaces.

When to use Remove duplicates in Excel

How to use Remove duplicates in Excel

  1. Add an Excel or CSV file and pick the sheet.
  2. Choose which columns must match.
  3. Click Remove duplicates.

Questions about Remove duplicates in Excel

Are my files uploaded?

No. The file is opened and changed inside your browser, on your phone or computer. Nothing is sent to our servers.

Can I see what was removed?

Yes. Tick "Put the removed rows on a separate sheet".

Is the formatting kept?

Values, formulas, dates and sheet names are kept. Colours, borders, merged-cell styles and charts may not carry over, because the file is rebuilt in your browser.

Is it safe?

Yes. Remove duplicates in Excel works inside your browser. Your files are not uploaded anywhere, so nobody else can see them, and there are no waiting queues.

Related tools

Excel viewer and editorCSV to ExcelExcel to CSVJSON to ExcelExcel to JSONXLS to XLSX