ExcelPipe is a mass search and replace tool designed to ease the editing of hundreds or thousands of spreadsheets when they all need changing, such as changing an organization's phone number, address, web site, CEO etc.
ExcelPipe takes ALL the hard work out of replacing text across multiple Microsoft® Excel® spreadsheets. Just imagine - next time your organization changes its phone number, address, web site or CEO - just run ExcelPipe across your file server or website to fix all affected spreadsheets in one hit. Translators can use ExcelPipe's grid to define multiple search/replace pairs.
Search and Replace multiple Microsoft Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed; update contact details such as names, addresses and phone numbers; translate spreadsheets with find/replace lists; update Microsoft SharePoint documents or Microsoft Namespace Server mappings.
Using ExcelPipe is simple. 1) Drag and drop files from Windows Explorer to ExcelPipe, or right-click the files or folders to process in Windows Explorer and choose 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 overnight or over a weekend. 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) and more. EasyPatterns and Perl regex patterns can also be used.
Unlike competing products, ExcelPipe is fully Unicode compliant (allowing Find and Replace with international character sets), and can handle an unlimited number of spreadsheets and find/replace pairs. ExcelPipe can also update ISO-9001 version numbers.
Use it for...
- Standardizing corporate name changes such as your organization's phone number, address, web site or CEO
- Performing server consolidations where document links need updating
- Server renaming or replacement where document links need updating
- Updating documents to use Microsoft Namespace Server mappings
- Changing part numbers or SKUs across multiple files
- Translating documents
- and much more.
User benefits
- Fast!
- No limit on the number of spreadsheets processed - use it across an entire file server or web server
- Translators can import search/replace lists from Excel, CSV- or Tab-delimited files
- Easy to use with integrated online help
- Supports the same search and replace options as Microsoft Excel, plus much more
- Stand-alone - doesn't integrate directly with Excel so it doesn't destabilize your installation
- Update documents to use Microsoft Namespace Server mappings
- Translations are available for other languages.
Microsoft SharePoint Services
To use ExcelPipe with Microsoft SharePoint Services, just specify a UNC path to the document root e.g. \\servername\path |