Searching, finding & deleting fuzzy duplicates and typos in Excel

Excel Fuzzy Duplicate Finder - find and delete duplicates, similar entries

Fuzzy Duplicate Finder for Microsoft® Excel®

For Microsoft Excel 2010 32-bit, Excel 2007, Excel 2003, Excel XP (2002), Excel 2000.

• Finding fuzzy duplicates
• Correcting fuzzy duplicates
• Removing duplicates

Back to Fuzzy Duplicates Finder homepage

Finding fuzzy duplicates

Open the Fuzzy Duplicate Finder pane by doing one of the following:

• Click on its icon
• In Excel 2000 – 2003 go to Excel menu, click Ablebits.com menu item, select Fuzzy Duplicate Finder from the drop-down list;
• In Excel 2007, 2010 go to Ablebits.com tab and select Fuzzy Duplicate Finder.

1. If you search for fuzzy duplicates in a single column, just place a cursor on any cell of that column. To search within several columns or any block of cells, just select them.
2. On the Fuzzy Duplicates Finder pane, set the maximum number of characters the entries may differ in (from one to six characters) on the Max number of different characters slide bar.
3. If you want to exclude one or several topmost rows from the search range (if the search range has column headers/names), check the Exclude header rows checkbox. You can specify the number of the excluded rows in the Header rows count field.
4. Click on the Find Typos button.
5. All the found items will be displayed in a list grouped by duplicates (nodes). In the lower right corner of the add-in pane you can see the total number of the found duplicates.

Correcting fuzzy duplicates

• Setting the right value to all items of the duplicate group (node).
• Setting the right value to some items of the node.
• Correcting one item of the node.

Setting the right value to all items of the duplicate group (node).

1. Check the right entry in a node (or right-click on the entry and select "Check item" from the pop-up menu). This value will be automatically assigned to all items of the node.
   
   
2. If the node doesn't contain the right entry, double-click on the header row of the node (Typo #). Type the right value in the Right value column. To finish up press Enter.
   
   
3. Click the Apply changes button on the Fuzzy Duplicate Finder toolbar to apply your changes to the Excel worksheet.

Setting the right value to some items of the node.

1. Check the right entry in a node and this value will be automatically assigned to all items of the node. Then uncheck the entries that you want to leave unchanged.
   
2. Click the Apply changes button on the Fuzzy Duplicate Finder toolbar to apply your changes to the Excel worksheet.

Correcting one item of the node

1. Double-click on the entry you want to correct. Type the right value in the Right value column. To finish up press Enter.
   
2. Click the Apply changes button on the Fuzzy Duplicate Finder toolbar to apply your changes to the Excel worksheet.

Removing duplicates

1. If you want to remove an entry from the list of the found duplicates, just select it and press the Delete key. Note! The entry will not be removed from the worksheet.
2. If you want to remove an entry from your Excel worksheet, select this item in the list of the found items. The cursor will be automatically placed on the corresponding cell of the worksheet. Right-click on the cell and select "Delete..." or "Clear content" from the pop-up menu.

Fuzzy Duplicate Finder for Excel is compatible with

• Operating System: Microsoft Windows 7 (x86, x64), Windows Vista (x86, x64), Windows 2003, Windows XP.
• Microsoft Office Excel 2010 32-bit, Excel 2007, Excel 2003, Excel XP (2002), Excel 2000.

Try before you buy

Download a fully-functional 15-day evaluation version of Fuzzy Duplicate Finder for Excel and try for yourself.