App Icon
This helpful add-on scans your sheet for typos and lets you correct them in seconds.
Works with:
33,572
Overview
This add-on is a great assistant for correcting all fuzzy matches and removing partial duplicates from your sheet.

Your table may have similar entries for company names, surnames, or cities; you can deal with all misprints in one go.
 • Use three simple settings to narrow your search results
 • Get all typos grouped by record
 • Pick or enter the correct values and apply changes

-    Besides comparing entire cells, you can look at every word within the cells separately. Set the number of different characters your values may have and exclude short words from the search. 
-    Once you get your results, export them to a new sheet or work with them right in the pane. Tick off the right value to change all similar records in the group; you can select any misspelling to see where it is in the sheet if you have any doubts. If all entries are inaccurate, you can type in the valid one.

This tool will help you quickly unify your data.

If you have any questions about the add-on, please post them here:
https://www.ablebits.com/docs/google-sheets-find-fuzzy-matches/
We'll be happy to assist!

Find Fuzzy Matches is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
Additional information
PricingNot available
Privacy policy
Terms of service
Find Fuzzy Matches will ask for the permissions shown below. Learn more
Find Fuzzy Matches will need access to your Google account
This will allow Find Fuzzy Matches to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
A User of Find Fuzzy Matches
June 13, 2014
Didn't work... ran it, and the popup window was blank.
Is this review helpful?
Yes
No
Profile Picture
A User of Find Fuzzy Matches
March 6, 2015
Added it, selected entire sheet, searched. Found suspicious "almost duplicates". I verified all was well and I am assured I have no duplicates. Awesome!
Is this review helpful?
Yes
No
1-2 of 2
Search
Clear search
Close search
Google apps
Main menu