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:March 25, 2024
Works with:
290K+
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.11 (17 Apr 2023) *****
Improved:
- Minor UX and UI improvements.

Fixed:
- Couldn't replace and export the data from the sheets with 2 numbers at the beginning of their names.
- Didn't export dates when exporting rows with all found entries.
- Displayed sheet names incorrectly if they had leading spaces.
- Cut zeros and leading spaces from the names of the sheet on the exported sheet.

*****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
James Leakey
November 29, 2023
Superb app - works really well for what it does.
Is this review helpful?
Yes
No
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
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
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
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
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
Tyrand
December 1, 2021
Nice business model
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Find and Replace
January 8, 2020
Wonderfully powerful add-on to Google Sheets! I am always impressed by the consistent innovation and improvements made by Ablebits.
Is this review helpful?
Yes
No
1-10 of 54
Search
Clear search
Close search
Google apps
Main menu