Batch Search and Replace multiple Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed, update names, addresses, phone numbers, data sources, translate with find / replace lists. Automatically handles passwords
Version: 8.9Batch Search and Replace multiple Excel spreadsheets. ExcelPipe makes search / replace tasks with Microsoft .xls .xlsx simple.
License: Free To Try $99.00
Operating System: Windows
Homepage: www.datamystic.com
Developed by:
Change hyperlinks, UNC paths and Data Sources when servers get renamed; update contact details such as names, addresses and phone numbers; translate spreadsheets with large find / replace lists imported from excel / csv / tab; update Microsoft SharePoint documents or Microsoft Namespace Server mappings.
Using ExcelPipe is simple:
- Drag and drop files from Windows Explorer to ExcelPipe,
- Add one or more search/replace pairs.
- Go!
ExcelPipe can change thousands or millions of spreadsheets, and can make multiple changes simultaneously to save time.
It automatically handles read-only files, passwords and other protection, and it can be automated to run when you need it to. No user interaction is required. It even includes restart recovery in case Microsoft Excel crashes!
ExcelPipe offers many more search and replace options than Microsoft Excel; such as hyperlinks, text boxes, shapes, document properties (such as Title, Subject, Author, Company etc), data sources and more. EasyPatterns and Perl regex patterns can also be used for more sophisticated replacements.
ExcelPipe is fully Unicode compliant (allowing Find and Replace with international character sets), can handle an unlimited number of spreadsheets and find / replace pairs, and cabn be fully automated from the command line.
ExcelPipe can search / replace .XLS, .XLSX and OpenDocument .ODS formats.
NEW! Now can find and replace images inside Excel spreadsheets
Microsoft recommends ExcelPipe to its customers for good reason!
Version 8.9: Fixed periodic reprompting for license key information.
Version 8.7: * License manager now handles key renewal. * Updated ribbon controls.
Version 8.5: Improved the search/replace grid editing experience
Version 8.3: Search/Replace mode now respects the Retain Last Access Date option
Version 8.2: * The results of searching/replacing Data Sources are now added to the Hyperlink report * Fixed an error that occurred when closing the running process before it completes.
Version 8.0: Update UI Updated icons Updated license manager
Version 7.9: Updated license manager
Version 7.8: New! Data Sources can now be updated (Office 2016+). Updated status tab warning about MS Excel already running to only display when no ExcelPipe job is running. Added cleared error messages for EasyPattern and Perl Regex errors. Removed logging warnings.
Version 7.6: Fixed error with non-recognized languages.
Version 7.5: * Fixed export error. * New warning display if MS Excel is currently running, with a button kill it. * Removed numbering from status dialog tabs as this was confusing. * Look In field now shows count of number of locations selected. * Fixed SharePoint URL dialog not allowing https:// links.