This helpful add-on scans your sheet for typos and lets you correct them in seconds.
Fortegnelse opdateret:19. december 2024
Fungerer sammen med:
63 t+
Oversigt
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-add-ons/index.php
Yderligere oplysninger
PrisUden beregning
Udvikler
Forhandlerstatus er ikke angivet
Find Fuzzy Matches anmoder om de tilladelser, der er angivet nedenfor. Få flere oplysninger
Find Fuzzy Matches har brug for adgang til din Google-konto
Dette giver Find Fuzzy Matches tilladelse til følgende:
Se og administrer regneark, som denne applikation er blevet installeret i
Vis og kør tredjepartswebindhold i meddelelser og sidebjælker i Google-apps
Opret forbindelse til en ekstern tjeneste
Se den primære mailadresse på din Google-konto
Se dine personlige oplysninger, heriblandt personlige oplysninger, som du har gjort offentligt tilgængelige
Anmeldelser
Sprog:
Sorter efter:
Google verificerer ikke anmeldelser eller bedømmelser.Få flere oplysninger om anmeldelser
Ingen kommentarer
Søgning
Ryd søgning
Luk søgning
Google-apps
Hovedmenu