Remove Duplicates from CSV & Excel

Clean a spreadsheet by removing repeated rows, and see exactly what was removed.

What counts as a duplicate

First row is a header
Ignore upper and lower case
Ignore extra spaces
Done in your browser. Your file is not uploaded.
Guide

How to remove duplicate rows

1

Add your file

Drop a CSV or Excel file and choose the sheet.

2

Choose what counts as a duplicate

Compare the whole row, or only columns such as Email.

3

Download the clean file

Get it as CSV or Excel, and the removed duplicates as a separate file.

Frequently asked questions

Is my file uploaded?

No. It is cleaned in your browser.

Is the header row ever removed?

No. With First row is a header on, the header is kept and never counted as a duplicate.

How do I remove duplicate emails only?

Choose Chosen columns and tick the Email column. Rows that share an email are treated as duplicates, even if their other columns differ.

What do the ignore options do?

Ignore upper and lower case treats Ali and ALI as the same. Ignore extra spaces treats ' Ali ' and 'Ali' as the same.

Which row is kept?

The first one by default, so the original order is kept. You can keep the last one instead.

Can I check what was removed?

Yes. Switch to Removed duplicates to look, or download them as their own file.

Related tools

See all documents →