Search in values, formatting, formulas, notes, links, errors. Get the list with all found entries and replace, color, delete, export all in a click.
Listing updated:November 18, 2024
Works with:
295K+
Overview
Advanced search doesn't have to be complicated! 😉 With all options in checkboxes, you're in control. Get all matches grouped by sheet or value, and effortlessly navigate to each cell with a click. Replace, color, extract, delete, and revamp formatting – for all or selected matches in one go! 🚀 Advanced Find and Replace is your ultimate solution for seamless search & replacement in Google Sheets!

🔎 Look in:
🗸 values
🗸 formatting
🗸 URLs
🗸 URL labels
🗸 formulas
🗸 errors
🗸 error descriptions
🗸 notes

🔥 Extra support for:
🗸 simultaneous search for multiple words/phrases
🗸 regular expressions (for pattern-based search)
🗸 fuzzy search (for approximate matches)

🎯 Search within:
🗸 current sheet
🗸 all sheets
🗸 selected range
🗸 multiple specific ranges

⚡ Handle all or only selected found records:
🗸 Delete entire rows
🗸 Replace
🗸 Replace with corresponding values from your list
🗸 Color found cells or text in found cells
🗸 Format (bold, italics, underline, strikethrough)
🗸 Export to a new sheet, file or hand-picked destination range

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:
*****V2.0***** (09 Jul 2024)
★ New features ★
- Meet the brand-new version with lots of new search & replace possibilities!
- Find & replace multiple values:
  - Enter several values separated by space/comma/semicolon to find them all at once.
  - Or copy-paste your list of words into the search field. 
  - Find & replace multiple values with their corresponding alternatives from a provided list.
- Find & replace entire cell formatting: bold, italic, underline, strikethrough, fill color, font color.
- Search & highlight: color found cells, change font color.
- Search numbers by condition: use comparison operators such as >, <, =, <>, <=, >=
- Search by formula results, e.g. =A2*0.5
- Search by any regular expression you want, e.g. \d+
- Fuzzy search: fine-tune the search precision by choosing the number of allowed fuzzy chars.
- 2 new locations to export found values: to a new spreadsheet and a certain range of cells within the current file.

Improved:
- Enjoy the new friendlier design!
- We've refined the 'Search within' options for a more straightforward experience. New options are: Current sheet, All sheets, Selected range, Specific ranges.
- Identify all currency numbers no matter their format, unless you explicitly include the currency symbol in your search.
- See the total number of found values & of the values you select to handle.
- The tab with found results now supports your keyboard. Use Tab, arrows and Enter keys to move through the list and select the options to manage the found values.
- Results are grouped by sheet by default, but you can regroup by search value. Expand/collapse the groups for better navigation experience.
- UX and UI improvements.

Fixed:
- Couldn't process data that contained some non-printing characters.
- Couldn't recognize some types of hyperlinks.

*****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 :
See, edit, create, and delete all your Google Sheets spreadsheets
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
Maxim Miller
October 29, 2024
It's a trial 30 days, and it ended up with just an error "couldn't replace". What's so difficult to replace a text to a newline?
Is this review helpful?
Yes
No
Profile Picture
JDW Logistics
July 23, 2024
Very helpful tool! Customer service is top-notch if you have questions or issues. Keep up the great work!
Is this review helpful?
Yes
No
Profile Picture
David Whitehead
September 18, 2024
Works amazingly! It works especially well for archiving my journals.
Is this review helpful?
Yes
No
Profile Picture
James Leakey
November 29, 2023
Superb app - works really well for what it does.
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Find and Replace
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
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
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
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
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
1-10 of 59
Search
Clear search
Close search
Google apps
Main menu