Main > Business & Finance > Spread sheets > ExcelPipe

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. ExcelPipe can search/replace both .XLS and .XLSX Excel document formats. Try it today - and see why Microsoft recommends ExcelPipe to its customers!

Key features of ExcelPipe:

• NEW! Now can search/replace inside Chart Titles and Defined Names

• Now can change the path of embedded OLE and DDE links to databases and other sources.

• Unicode search and replace

• Search-Only mode

• Search and replace with all Excel's options such as Match Case, Whole Cell/Partial Cell etc, plus more.

• Handles any number of sub folders

• Search and replace inside hyperlink addresses

• Search and replace UNC link paths

• Search and replace inside shapes

• Search and replace inside built in doc

• ument properties and custom properties such as Title, Subject, Author, Company etc

• Search and replace inside headers and footers

• Works with Windows SharePoint Services document libraries

• Fully Unicode compliant - search and replace international character sets (unlike competing products)

• Allows replacements to be longer than 255 characters (Microsoft Excel limits this to 255)

• Control the spreadsheet types used - so you can process .xls, or any custom spreadsheet type

• Can be automated or scheduled via the command line, and settings are saved in an easy-to-edit or generate XML format
  Handles password-protected spreadsheets - these get flagged for manual follow-up

• Read only documents can be processed or skipped
  Easy to install/uninstall

• The original file date and time stamp can be preserved.

ExcelPipe screenshot: