ExcelPipe

Batch Search and Replace multiple Excel spreadsheets. ExcelPipe makes search/replace tasks with Microsoft .xls .xlsx simple. 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: 1) Drag and drop files from Windows Explorer to ExcelPipe, 2) Add one or more search/replace pairs. 3) 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.