Advanced Find and Replace - Google Workspace Marketplace

Ablebits

• 108,639

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/google-sheets-find-replace-values/
We'll be happy to assist!

Reviews

Language:

Sort by:

Gretchen Leslie

January 25, 2021

This just saved me HOURS of work. Fantastic tool!

Is this review helpful?

Yes

Samson Assefa

December 10, 2020

Samson Assefa Gebrehiwot

Is this review helpful?

Yes

Troy Pasulka

November 25, 2020

Works great!

Is this review helpful?

Yes

Hari Neupane

October 29, 2020

Good add on but search is bit slow.

Is this review helpful?

Yes

Natalia Sharashova

October 30, 2020

Hello Nari, 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. Adding more memory or switching to a more powerful computer may help speed up the work of the tool.

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

Natalia Sharashova

October 23, 2020

Thank you for your feedback. You mentioned that the add-on is not perfect: could you tell us why? What is it that the add-on lacks to your opinion? We may be able to add a missing feature or let you know if it's already in the development.

Katie Kline

October 5, 2020

Exactly what I was looking for to be able to make wholesale replacements to character strings in cell formulas. Works great!

Is this review helpful?

Yes

Cindy Scott

October 1, 2020

Advanced find love it

Is this review helpful?

Yes

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

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

Natalia Sharashova

December 10, 2020

Hello Amanda, We've just added the possibility to remove rows with the found entries to the add-on. Feel free to check it out!

Ablebits team

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.

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

Ablebits team

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.

1-10 of 47

Additional information

Ablebits

Website

Support

Clear search

Close search

Google apps

Main menu