App Icon
Ablebits
•  97,110
Overview
Search in values, formulas, notes, hyperlinks in all sheets at once. Get the list with the found entries and replace them in a click
Use this simple add-on for advanced search in your google spreadsheet. Find and replace text within a formula, check links hidden behind the display text, search within notes, and look for values at the same time. You can search and replace within a column by simply selecting the necessary range of data, or choose to scan 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

What's new?
Version 1.7
New Features:
- New type to look in - Errors. Now you can perform 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.

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

Advanced Find and Replace add-on will help you complete any substitutions in your sheets in seconds. If you have any questions about it, please post them here: https://www.ablebits.com/docs/howto-find-replace-google-values/
We'll be happy to assist!
Reviews
Language:
Sort by:
Profile Picture
A User of Advanced Find and Replace
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
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 Pciture
A user of Advanced Find and Replace
September 15, 2020
Thank you for your feedback! At the moment the add-on can't remove entire rows with the found record. However, this feature is already in our development list. I can't say for sure when it will be added, but we'll let you know once it is available.
Profile Picture
A User of Advanced Find and Replace
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
Profile Pciture
A user of Advanced Find and Replace
July 27, 2020
Thank you very much for your feedback! You can review all subscription plans and purchase one directly from the add-on. Just click the icon with a key at the bottom of the add-on pane.
Profile Picture
A User of Advanced Find and Replace
June 23, 2020
I love having the find and replace option for my docs. However, I do not like to be interrupted everyother time I open the app to subscribe, when i have a yearly subscription (that automatically renews).
Is this review helpful?
Yes
No
Profile Pciture
A user of Advanced Find and Replace
June 24, 2020
Thank you for your feedback. There is currently an issue on the side of Google that occurs when you are logged in under more than one account. This may force the tool to lose your key. Unfortunately, we can't control or bypass this issue, so please sign out and log back in only under the subscribed account. Then activate the add-on with your key. If you still have any difficulties, email us to support[at]ablebits[dot]com with your key, we'll do our best to help.
Profile Picture
A User of Advanced Find and Replace
June 18, 2020
Very good app!
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Find and Replace
May 27, 2020
It's just a bit slow in finding things
Is this review helpful?
Yes
No
Profile Pciture
A user of Advanced Find and Replace
May 28, 2020
Thank you for your feedback. The processing speed of the add-ons depends on your Internet connection speed, your computer operating memory, and the amounts of data you have in your spreadsheets. Thus, adding more memory or switching to a more powerful computer may help speed up the work of the tool.
Profile Picture
A User of Advanced Find and Replace
March 3, 2020
Nice
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Find and Replace
February 18, 2020
Didn't work. Even if all pages/sheets selected, it wouldn't find the search value.
Is this review helpful?
Yes
No
Profile Pciture
A user of Advanced Find and Replace
February 19, 2020
Hello, Please use the Support link under the comments section to contact our support team. We'll look into the problem and make the tool work for you.
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
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 Pciture
A user of Advanced Find and Replace
December 10, 2019
Hello, The trial 30-day version is mentioned in the tool itself, the description here on G Suite Marketplace as well as our website. We'll try to make it more clear in the future.
1-10 of 40
Additional information
Ablebits
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu