Bulk Find & Replace for Sheets™
Lets you to search multiple Google Sheets™ with regular expressions and batch replace lines of text.
The Bulk Find & Replace add-on for Google Sheets™ transforms your data management workflow by allowing you to efficiently search and replace text across multiple spreadsheets. Save time and ensure consistency with powerful find and replace capabilities, including support for regular expressions and various advanced search options.
Features:
Advanced Find and Replace:
Regular Expressions: Use a list of regular expressions to find and replace text, enabling complex and flexible search queries.
Case Sensitive Toggle: Choose to perform case-sensitive searches for precise text matching.
Multi-File Support:
Multiple File Selection: Process multiple files in one go, streamlining your document management tasks.
Comprehensive Replacement Options:
Multiple Find and Replace Matrix: Execute batch replacements based on a matrix of find and replace criteria.
Match Formula Text: Include or exclude formula text in your search and replacement operations.
Ignore Diacritics: Opt to ignore diacritics (accent marks) during searches for broader text matching.
Match Entire Cell: Limit replacements to cells where the entire content matches the search criteria.
Streamline your data management with the Bulk Find & Replace add-on for Sheets™. Enhance your efficiency and maintain consistency across multiple spreadsheets. Upgrade to access unrestricted file processing and additional advanced features.
Free Version Limitations:
Allows find and replace operations in up to two files simultaneously.
Video help: https://youtu.be/-EIHWUYsUJ0
* Google services impose daily quotas and hard limitations on some features - https://developers.google.com/apps-script/guides/services/quotas
Bulk Find & Replace for Sheets™ use and transfer of information received from Google APIs to any other app will adhere to Google API Services User Data Policy, including the Limited Use requirements.