App Icon
Search in values, formulas, notes, hyperlinks in all sheets at once. Get the list with the found entries and replace them in a click.
Listing updated:December 13, 2022
Works with:
277,242
Overview
Use this simple add-on for advanced search in your Google spreadsheet. Find and replace text within a formula, check links hidden behind the displayed text, search within notes, and look for values at the same time. You can search and replace within a column by selecting the necessary range of data, or scanning any selected sheets. The add-on will display the list of all found records organized by sheet and take you to any found cell in a click. 

It's easy to use and it offers all you need to discover the necessary data:
	- Look at values, formulas, notes, errors and links simultaneously 
	- Find and replace in a single column or search everywhere in the spreadsheet 
	- Get all matches listed in the sidebar, navigate to any entry in a click  
	- Replace all or only the selected records
	- Export the found values or the entire rows that contain them

30 DAYS OF FREE USE
Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

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

Advanced Find & Replace 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
–––––––––––––––––––––––––––––––––––––
WHAT'S NEW:

*****V1.10 (28 Jul 2022) *****
Improved:
- The limit for total cells in a spreadsheet is expanded to 10 million cells.
- Further performance improvements made it possible to export more found records than before.
- Minor UX and UI improvements.

Fixed:
- Couldn't display results for more than 8k found records.
- Couldn't replace data in cells with duplicate records formatted as rich text.
- Didn't show the list of all sheets if at least one sheet name ended with 2 underscores (__).

***** V1.9 (5 May 2021) *****
★ New features ★
- Preserve text formatting. If there are multiple text strings in a cell formatted in different ways, this option will let you keep all formatting upon replacing values.

Improved:
- Significant performance improvements in processing large amounts of data.
- Minor UI improvements.

Fixed:
- Didn't search in hyperlinks if they weren't created by the corresponding function.
- Didn't export cells and rows with found errors.
- The list of sheets didn't update in the tree view if sheets were added/deleted from a file with the add-on opened.
- The addresses of found records didn't update after deleting rows with found entries.
- Couldn't find anything if the chart sheet was selected to search in as well.
- Minor UX issues.

***** V1.8 *****
★ New features ★
- Delete rows with all found entries or delete rows only with those found values that you select in the add-on.

Improved:
- The add-on remembers the sheets you search in: the same sheets will be selected the next time you run the tool.

Fixed:
- The add-on didn't look for notes in empty cells.
- There were problems with locating all Booleans (TRUE/FALSE).
- Treated cells containing a question mark as cells with errors.
- Minor UX issues.

***** V1.7 *****
★ New features ★
- New type to look in - Errors. Now you can perform a search in errors.

Improved:
- UI; we increased space for the "Search in" area which is useful for the documents with numerous sheets.
- Minor UX improvements.

Fixed:
- The add-on didn't find links in the range.
- If you were looking for hyperlinks only, the add-on showed cells with formulas too.

***** V1.6 *****
- Improved UI
- Fixed export issue 
- Minor bugs fixed
- We introduced yearly subscriptions, you can still enjoy a fully functional trial version of the add-on for 30 days.
Additional information
PricingFree of charge trial
Developer
Privacy policy
Terms of service
Advanced Find and Replace will ask for the permissions shown below. Learn more
Advanced Find and Replace will need access to your Google account
This will allow Advanced Find and Replace 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:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Paul Salcedo
November 7, 2022
While the tool is pretty handy, it removes the cell formatting after it has done replacing text. This basically does not work for me.
Is this review helpful?
Yes
No
Profile Picture
Jill
February 13, 2023
I use this every week, it is really handy for searching documents! I recommend this to anyone who needs a search function! The customer service is really fast and helpful too!
Is this review helpful?
Yes
No
Profile Picture
Cody Coblentz
July 29, 2021
First of all, searchable notes should be a built-in functionality of Google sheets. But since it is not, it should not cost money for a simple add-on. This program was also advertised as free and then sets you up for a 'trail" with a few free searches, after which you must pay an annual subscription of $30. No thanks.
Is this review helpful?
Yes
No
Profile Picture
Gretchen Leslie
January 25, 2021
This just saved me HOURS of work. Fantastic tool!
Is this review helpful?
Yes
No
Profile Picture
Pierre Beneby
October 22, 2020
Worth the price. I work in Google Sheets daily from home now and I have access to 2k+ files that I must manage daily. This search add on is a must. Not perfect but definitely worth the cost.
Is this review helpful?
Yes
No
Profile Picture
Kevin Ta
February 13, 2021
Was able to search and replace numbers in formulas -- saved hours of work!
Is this review helpful?
Yes
No
Profile Picture
Jennifer Smith
September 16, 2020
Saved me countless hours and headaches in just a couple of weeks of use. Intuitive, reliable. Highly recommend.
Is this review helpful?
Yes
No
Profile Picture
Amanda Vigilante
September 14, 2020
Instead of exporting the data found, can you remove those rows/data found completely from the sheet?
Is this review helpful?
Yes
No
Profile Picture
Hari Neupane
October 29, 2020
Good add on but search is bit slow.
Is this review helpful?
Yes
No
Profile Picture
Taylor Thompson
July 26, 2020
Built a sheet for traders and auto updates all links to whichever stock ticker you're researching. Just what i needed. Thank you. How do you buy or is it free?
Is this review helpful?
Yes
No
1-10 of 54
Search
Clear search
Close search
Google apps
Main menu