How to find and correct typos and partial duplicates in Excel

Fuzzy Duplicate Finder for Microsoft Excel 2016, 2013-2003

Task

You have a large Excel table updated by several people, which results in numerous typos, misspelled words or partial duplicates. You have always cared about the details and done your best to make your databases perfect. When you are manually checking your spreadsheets for typos, you can't help thinking about a special tool which would automatically find and correct all those inaccuracies.

Solution

Fuzzy Duplicate Finder for Microsoft Excel will easily find partial duplicates in your worksheets. The add-in locates and displays them in groups on the add-in pane. All you need to do is select the correct value; the plug-in will automatically replace other values of the group with the right one.

Find partial duplicates, typos, misspelled words and omitted symbols in Excel.

Fuzzy Duplicate Finder key features

Fuzzy matches in Excel are grouped by duplicate nodes.
  • Find partial dupes, typos and misprints that differ in 1 to 10 characters
  • Search for words/cells with fewer than a specified number of characters (from 1 to 50 symbols)
  • Split cell data into words and specify the delimiters that separate them
  • Look for excess, mistyped and omitted symbols
  • Have the results on the add-in pane and correct all dupes of the group at once
  • Search for typos in an entire Excel workbook, selected range (block of cells), or column(s)
  • Export the found entries to a separate worksheet
  • Undo the latest alteration

Tip

You can get this add-in as a part of Ultimate Suite for Excel - 40+ tools destined to cut your time and clicks on the most frequent spreadsheet tasks.

How Fuzzy Duplicate Finder works

Correct all duplicates of the group in a click and apply the changes to your Excel table.

The more information we add to our Excel sheets, the more likely we are to come across typos, misspellings, the same words written in different ways and other fuzzy dupes. Fuzzy Duplicate Finder for Microsoft Excel is a really helpful tool that will let you forget about wasting your time on checking the spreadsheets for imperfections as well as on correcting them.

Its flexible mechanism allows customizing the search parameters to pinpoint only the relevant entries. Thus you can choose to avoid short entries, split the cell values into words and select delimiters before you press the Search for typos button.

All the found entries will appear in front of your eyes on the add-in pane. The add-in enables you to easily manage found dupes. So you can correct, delete, or export them to a new spreadsheet to ensure that your Excel data are flawless.

Find similar entries that differ in 1 to 10 characters

You can adjust the search options by specifying the number of characters the found values can differ in. It is possible to select from 1 to 10 dissimilar characters. So the bigger is the number, the more values you are likely to get.

Search for values with the specified number of symbols

This helps to narrow the search range by excluding short values. For example, if you choose to exclude cells or words with fewer than 5 characters, the plug-in will find only those that contain 6 or more symbols.

Split cell data into words and select various delimiters

This feature is irreplaceable if your table has cells with several words or sentences like addresses, names, product descriptions. With Fuzzy Duplicate Finder you can search for entire cells or look at separate words within these cells. The add-in even reads values separated by different delimiters. All you need is to enter these delimiters.

Correct all typos of the group at once

All the found fuzzy dupes are shown on the add-in pane in a tree list. You can instantly correct the typos of a group by double-clicking on the right one. The other entries of will be accurately replaced in your spreadsheet.


Keep case of the same values in the node

Fuzzy Duplicate Finder has one tricky but helpful option Keep case of the same values in the node. You can see it active after the dupes are found and the results are organized into nodes on the add-in's pane. The idea is when the plug-in searches for typos, it finds all similar entries disregarding their case. The add-in also shows items which are the same, but look different because of the case. For example, Washington, washington, WasHIngtOn. With this option it's up to you to decide whether to keep case as it is or to change it according to the item you select as correct.

Export the found entries to a separate worksheet

Sometimes you may need to look closer at the found values or correct them manually. No problem, just click the Export button and all found duplicates will appear on a separate worksheet for you to review them further.

19.95
Buy now

Fuzzy Duplicate Finder for Microsoft Excel system requirements

Microsoft Excel

  • Microsoft Excel 2016 (32 and 64-bit)
  • Microsoft Excel 2013 (32 and 64-bit)
  • Microsoft Excel 2010 (32 and 64-bit)
  • Microsoft Excel 2007

Operating System

  • Windows 10 (32 and 64-bit)
  • Windows 8 (32 and 64-bit)
  • Windows 7 (32 and 64-bit)
  • Windows Vista (32 and 64-bit)
  • Windows XP (32-bit)
  • Windows Server 2003, 2008, 2012
  • .NET Framework 4.0 must be installed.

Fuzzy Duplicate Finder for Excel version

Current add-in version: 5.0.27
published on: Feb 02, 2016

Order Fuzzy Duplicate Finder for Excel

19.95
Buy now
 
Contact us