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:November 19, 2021
Works with:
150,280
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.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
PricingNot available
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:
Profile Picture
A User of Advanced Find and Replace
April 1, 2014
Seriously, why a find/replace add-on can be named as "Advanced F&R" without Regex support? :< Although, I must say it works perfectly besides what I mentioned above.
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Find and Replace
August 17, 2016
It has been error-ing out for a couple weeks. I am going to have to find a new solution for my project.
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Find and Replace
April 1, 2016
I believe there is a bug. It worked great, but about a month ago the Find and Replace by Selection does not work with more than 1 cell selected. For example, I might select a column, search for all instances of string. It then selects only the first cell that found the instance, and I can no longer text replace the original selection. Kind of frustrating that such basic functionality does not work with Google sheets.
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Find and Replace
May 2, 2019
This has been indispensable while doing a silly personal project that involved converting a lot of numbers to point totals. It has been very easy to use while easing my mind as as much as i enjoy trying to compute things in my head, this completely removed personal error.
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Find and Replace
December 13, 2018
I have always liked the time saving aspect of the add on but in the last year it has been hit or miss for accuracy. Seems as though once it was updated and it became a paid subscription, it started flaking out. I am not pleased with the accuracy for the price tag that has been assigned. I keyed in the exact info 30 times back to back and it would give me different responses each time. I searched my name on one sheet and 19 out of 30 times it popped up with No Matching Data Found. Not $30.00 odds when you have to manually do the job that often. I often times get error messages, it times out or locks up. I would love to see more accuracy and less glitchy for the price tag that it currently holds
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Find and Replace
June 3, 2018
Absolute horseshit. This add-on would have been good, in fact it was. But they started forcing people to pay 30$ a year for it, which is absolutely insane. I would not recommend it at all.
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Find and Replace
December 4, 2019
Did not tell me upfront that it was a paid addon and under "free trail". I've wasted time training my employee to use it and now feel pressured and tricked to Pay.
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Find and Replace
February 13, 2018
This is great - Could you please add "Select all matching cells"?
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Find and Replace
August 27, 2018
Not worth a subscription. I'll spend the hour it takes to make my own add-on for searching within formulas, thanks..
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Find and Replace
April 28, 2014
Really helpful, but crashes a lot when working with large amounts of replacements/cells. Some of this I believe to be more of a limitation of google sheets, rather than your add-on. Because of this though I cannot give you 5 stars.
Is this review helpful?
Yes
No
1-10 of 52
Search
Clear search
Close search
Google apps
Main menu