Sign up free

Remove Duplicates in Excel

Clean repeated rows out of a customer list or export, comparing all columns or just the ones that matter, with every deleted row kept to check.

More tools
WordMerge WordSplit WordCompress WordCompare WordFind and Replace in WordDelete Blank Pages in WordWatermark WordProtect WordUnlock Word
Excel security & sizeCompress ExcelWatermark ExcelProtect ExcelUnlock Excel
PowerPointMerge PowerPointSplit PowerPointCompress PowerPointWatermark PowerPointProtect PowerPointUnlock PowerPoint
All Office filesOffice ViewerExtract Images from OfficeRemove Document Metadata

or drop files here

Accepts XLSX, XLS, CSV

Encrypted upload. Files are deleted automatically after 1 hour.

About Remove Duplicates in Excel

Remove duplicates in Excel lists that were pasted together from several sources: a mailing list with the same customer three times, an order export with repeated lines, a sign-up sheet where people registered twice. Leave Compare columns empty to match whole rows, or name the columns that decide, such as Email or A, C. Lists spread over several files can be stacked into one sheet first with Merge Excel.

Matching works like Excel's own Remove Duplicates, so capital letters and spaces at the ends don't make two rows different. Tick Loose match and spaces inside a value and full-width characters don't count either, so “John Smith” equals “johnsmith” and “ＡＢＣ” equals “abc”. Keep the first or the last copy, then delete the rest or just highlight them in yellow to check by hand. Deleted rows go to a sheet of their own at the end of the workbook, with their original row numbers, so nothing disappears unseen, and formulas, merged cells and filters adjust the way they do in Excel. The first sheet with data is the one that's checked.

How to use Remove Duplicates in Excel

  1. 1
    Upload your list

    Click Choose file or drop an XLSX, XLS or CSV file.

  2. 2
    Say which columns count

    In Compare columns, type letters like A, C, a range like A:C or header names like Name, Email. Leave it empty to compare entire rows.

  3. 3
    Choose what to keep

    Set Keep to First match or Last match, and Duplicates to Delete them or Highlight them. Tick Loose match for messy data, and leave Keep the removed rows on a separate sheet on to check the deleted rows later.

  4. 4
    Run and download

    Press Remove Duplicates in Excel and download the cleaned file under its original name.

Why use Cubfile for this

  • Match on the columns you pick

    Two orders from the same email count as duplicates when you compare only the Email column, even if their dates differ.

  • Loose match for messy lists

    Capitals and outer spaces never count, and Loose match also ignores inner spaces and full-width characters, so “ＡＢＣ” and “abc” match.

  • Deleted rows kept to check

    Removed rows are copied to a sheet at the end of the workbook, each with its original row number, so you can look them over or copy one back.

  • Review before deleting

    Highlight them fills duplicate rows in yellow and removes nothing. A CSV can't hold colors or extra sheets, so there the duplicates are deleted.

FAQ

Remove Duplicates in Excel: questions and answers

Does Remove Duplicates in Excel ignore upper and lower case?
Yes, just like Excel's built-in command. Spaces at the ends are ignored too, so Smith and smith with a trailing space count as one value, and 5 and 5.0 are treated as equal. Loose match goes further and also ignores spaces inside values and full-width characters. Dates written in different styles are best unified first with Excel & CSV Cleaner.
Can I remove duplicates in Excel based on one column?
Yes. Enter that column's letter or header in Compare columns, for example C or Email. The decision is based only on that column, but whole rows are kept or removed, and a first row of unique text labels is recognized as the header and never removed.
Can I see which rows were deleted?
Yes. Keep the removed rows on a separate sheet is on by default when deleting, so the removed rows are copied to a sheet at the end of the workbook, each with its original row number, and you can look them over or copy one back. A CSV file holds just one sheet and no colors, so there the duplicates are simply deleted; save it as an XLSX first if you want to review them.
Is Remove Duplicates in Excel free?
Yes. Visitors get 2 tasks in total and free accounts 2 a day, with files up to 50 MB, while VIP goes up to 1 GB with no daily limit. If no duplicates are found, the task isn't counted.
Is my customer list kept private?
Yes. It's uploaded over HTTPS, processed in an isolated process and deleted automatically after one hour. We never read, share or sell the data, and it isn't used to train AI.
Share Remove Duplicates in Excel with a friendIt runs in any browser, and they can try it without signing up.

Related tools

DOC Office ViewerOpen Word, Excel and PowerPoint files in the browser, no Office needed.
XLS Compare ExcelFind every changed cell between two spreadsheets.
DOC Compare WordHighlight every insertion, deletion and change between two documents.
XLS Compress ExcelMake workbooks smaller by shrinking images and dropping cached data.
PPT Compress PowerPointShrink presentations full of big photos.
XLS Excel & CSV CleanerTrim spaces, drop empty rows, fix number and date text in one go.
XLS Merge ExcelCombine workbooks into one file: as sheets, or rows appended.
PPT Merge PowerPointCombine presentations into one deck, designs kept.