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: 7.8Batch Search and Replace multiple Excel spreadsheets. ExcelPipe makes search / replace tasks with Microsoft .xls .xlsx simple.
License: Free To Try $10.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 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.
Version 7.3.1: * Now can find and replace Excel images in Microsoft Excel or OpenOffice spreadsheets * Enhanced and improved user interface. * Minor bug fixes
Version 7.0: * Now allows the subaddress (anchor) part of hyperlinks to be modified. * New warning when all Search Locations checked (slows job down). * New checks if the hyperlink change does not get saved if the hyperlink is invalid or the destination cannot be found) * Restart controls in new tab
Version 6.9.2: * Fixed handling of updates to Pivot Table caches. * Fixed loading of highlight color data from Import file. * Updated button enable/disable for grid.
Version 6.8: * Fixed intermittent XML loading/saving error on x64 systems. * Fixed error with /I= command line option not loading the search-replace list.
Version 6.7: * Fixed Save from removing leading and trailing whitespace. * Fixed Recent settings from not appearing in the Recent files history.
Version 5.1.1: New help options and hints for connecting to SharePoint.
Version 5.0.8: Search/replace now continues even if there is an error getting the document protection type under Office 2007/2010.