Find Fuzzy Matches for Google Sheets

Identify and correct misprints in your spreadsheet

If the task of unifying your data ever crops up in your sheet, get this add-on to handle it easily. The tool compares all words from the sheet for similarities and differences and prepares a list of all fuzzy duplicates grouped by record for you. Mark a correct word and change all similar misspelled words in a click or export search results to a new sheet.

Get it for free
Free add-on
Find Fuzzy Matches for Google Sheets

With Find Fuzzy Matches you will

  • Scan the selected range for typing mistakes Find fuzzy duplicates that differ in 1 to 50 characters.
  • Correct all fuzzy matches at once Pick the correct value or enter a new one to apply changes to all similar records.
  • Navigate between the sets of misprints quickly Get all typos conveniently grouped by record.
  • Export search results Get a better view of all found mistakes and related proper values on a new sheet.

How to smart-search for typos in Google Sheets

Adjust search settings to find all necessary typos
Adjust search settings to find all necessary typos
See the misprints grouped in the tree view
See the misprints grouped in the tree view
Pick the correct record from the list…
Pick the correct record from the list…
…or enter a new proper variant
…or enter a new proper variant
One click and all the misprints are fixed on the sheet
One click and all the misprints are fixed on the sheet
Copy found groups of misspellings to another sheet to review
Copy found groups of misspellings to another sheet to review

Frequently asked questions

What is Find Fuzzy Matches and what do I need it for?

This tool is designed as a quick spell checker for Google Sheets. It will help you make sure all records in your table are spelt correctly. Instead of thoroughly looking at every word, have the add-on search for all typos for you. You can remove any irrelevant values from the list of found records and deal with the rest in a couple of clicks.

Doesn't Google offer similar feature?

If you know how to handle Google Apps Script, you can make it look for fuzzy matches for you.

Otherwise, our add-on can become your best assistant for the task.

How can I find fuzzy matches with your add-on?

  1. Start the tool.
  2. Specify how many chars may differ in your words.
  3. Identify the minimum number of total chars in a word/cell.
  4. If cells contain separate words, turn the corresponding setting on and specify the delimiter.
  5. Hit Search for typos.

See a more detailed description here.

How do I work with the found typos?

  1. To correct the mistakes, review the list of all misprints, pick and click the proper value, and press Apply.
  2. To export the misspellings, click Export right away.

See a more detailed description here.

What if all found words are misspelled? Can I change them all to something else?

Yes. Once the add-on returns the results, look through the records. If the table doesn't happen to have the right word, enter your own value next to the needed group of typos.

Will the add-on work if there is more than one word in some cells?

Yes. Tick off a special option and enter all delimiters that may separate your words, and you're good to go.

System requirements

Operating Systems

  • Microsoft: Windows 7 and up
  • Mac: Yosemite 10.10 and up
  • Chrome OS™

Browsers

  • Chrome™
  • Firefox
  • Safari (Mac only)
Get it for free
Free add-on

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close