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:April 17, 2023
Works with:
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

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:
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:
*****V1.11 (17 Apr 2023) *****
- Minor UX and UI improvements.

- 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) *****
- 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.

- 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.

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

- 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.

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

- 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.

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

- 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
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
Clear search
Close search
Google apps
Main menu