How to remove duplicate rows in Excel

Excel users frequently want to remove rows that have duplicate values. For example to remove the rows with duplicate emails in:

To give:

This is trivially easy to do in Easy Data Transform:

1. Install Easy Data Transform on your PC or Mac, if you haven’t done so already. It will only take a minute. There is a fully fuctional free trial and you don’t have to give us your email or sign up to anything.
2. Start Easy Data Transform.
3. Drag the Excel spreadsheet you wish to remove duplicates from onto Easy Data Transform. If there are multiple sheets, you will be asked which ones to import. A pink input item will be added for each sheet.
4. Ensuring the pink input item for the sheet is selected, click the Unique button in the left pane. A blue transform item is added and selected.

In the right pane set what you want to do with each column. You should set at least 1 column to Keep unique.

For example:

• To keep only the first row with a particular email address and keep the first and last name from the first occurrence, set the Email column to Keep unique and the other columns to Keep first.
• To keep only the first row with a particular email address AND first name AND last name value, set First, Last and Email to Keep unique.

Note that duplicate checking is sensitive to case and whitespace. You can use Case and Whitespace transforms before the Unique to modify case and whitespace, e.g. to set all the emails to lower case. You can also use the Sort transform to change the row order before the Unique.

The Unique transform is very powerful. For example, you can do the following:

For more information see the Windows or Mac documentation.

When you are happy with the results output the result into a new Excel spreadsheet or CSV file.

Easy Data Transform allows you to combine 50 different transforms to quickly and easily manipulate your data. You can also use it to show duplicates in Excel.