This helpful add-on scans your sheet for typos and lets you correct them in seconds.
Listingan diperbarui:19 Desember 2024
Berfungsi dengan:
63 rb+
Ringkasan
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
Informasi tambahan
HargaTanpa biaya
Developer
Status pedagang belum ditentukan
Find Fuzzy Matches akan meminta agar izin ditampilkan di bawah ini. Pelajari lebih lanjut
Find Fuzzy Matches akan memerlukan akses ke Akun Google Anda
Hal ini akan mengizinkan Find Fuzzy Matches untuk:
Melihat dan mengelola spreadsheet tempat aplikasi ini dipasang
Menampilkan dan menjalankan konten web pihak ketiga pada perintah dan sidebar di dalam aplikasi Google
Menghubungkan ke layanan eksternal
Melihat alamat email Akun Google primer Anda
Melihat info pribadi Anda, termasuk info pribadi Anda yang tersedia untuk publik
Ulasan
Bahasa:
Urutkan menurut:
Google tidak memverifikasi ulasan atau rating. Pelajari ulasan lebih lanjut
Tidak ada komentar
Telusuri
Hapus penelusuran
Tutup penelusuran
Aplikasi Google
Menu utama