Find and Replace in Excel - ExcelPipe

Microsoft Excel (Office 365, 2019, 2016, 2013, 2010, 2007) Microsoft® Windows® 11, 10, 8, 7, Vista®, 2019/2016/2012/2008/2003, x32 and x64 Buy

How to Find and Replace in Excel? ExcelPipe Find and Replace in Excel Office 365, 2019, 2016, 2013, 2010, 2007 ExcelPipe Search and Replace for Excel is an easy-to-use tool to search and replace phrases across large sets of Microsoft Excel spreadsheets. Automatically Fix broken links by migrating Microsoft Excel hyperlinks when you rename file servers Translate files by applying massive pre-written search/replace lists Find and replace outdated logos, names, addresses and phone numbers The ONLY tool to search and replace images in Microsoft Excel spreadsheets Also works with OpenDocument Spreadsheet *.ods formats Update tedious QMS and Business Process templates Fix My Excel Files Now Free Trial - No Email Address Required ExcelPipe is designed as a hands-off tool requiring next to no user intervention, as you would expect for migrating large numbers of files. It copes with a myriad range of Microsoft Excel bugs, such as restarting Microsoft Excel to avoid memory errors. It also copes with the largest variety of problem documents of any tool, from password protected to corrupted documents. To use ExcelPipe, you simply add a list of search/replace pairs, and for each one, specify where in the spreadsheet it should be found. Then you tell it which files to process - that's it! See the WordPipe Marketplace, where authors share their expertly curated word lists to help you be more efficient.

You're 60 Seconds Away From Fixing Link Rot and Outdated Info

Over 700 Satisfied Customers... more ►

I just ran a batch on 94 Excel files. 1008 strings. Replaced 8463 strings flawlessly - Don, Translator

Use it for...

• Standardizing corporate name changes such as your organization's phone number, address, web site or CEO
• Migration of documents when a server is renamed or replaced and all Excel spreadsheet links need updating
• Updating documents to use Microsoft Namespace Server mappings
• Changing part numbers or SKUs across multiple files
• Translating documents
• Detecting which Microsoft Excel spreadsheets are password-protected (specify a blank password - these appear on the errors tab)
• Use our timing calculator to see how much time you will save with ExcelPipe

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
• Hyperlink report/pre-migration analysis can identify the existing links and what they would be changed to (complete report in full version only)
• Lite version works with documents located on the local system. Pro version works with documents locally, on File Servers or NAS, Novell cluster volumes etc.
• Retains Last Access dates for data retention policy compliance
• Translations are available for other languages

Features

• NEW! Now search and replace Excel data sources
• The ONLY tool to search and replace images in Microsoft Excel spreadsheets
• Now can update the connection strings of Query Tables and Pivot Tables - ADO, DAO, OLEDB and ODBC database queries, web queries etc.
• 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.
• Files can be specified by folder (optionally including sub folders), by importing from a list file, or by pasting in a list of filenames
• Search and replace inside hyperlink addresses
• Search and replace UNC link paths
• Search and replace inside shapes, text boxes and tables
• Search and replace inside built in document properties and custom properties such as Title, Subject, Author, Company etc
• Search and replace inside headers and footers
• Search and replace inside VBA Code Modules - even if protected with a password.
• Search and replace inside Sheet Names e.g. Sheet1, Sheet2, Sheet3
• Works with Windows SharePoint Services document libraries, Office 365 / Network Storage via UNC path mappings
• 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
• Does not alter documents unless a change is made. In Search Only mode, no changes are made.
• All settings can be saved and re-loaded later, allowing you to manage multiple jobs.
• Full backup facility, and the ability to rollback if the results are not acceptable.
• Full audit trail on completion, logging the changed documents, unchanged documents and error documents.
• Beware of cheap imitations.

Microsoft SharePoint Services / Office 365 / Network Storage

Yes! ExcelPipe now talks directly to SharePoint sites via UNC path mappings

Consulting

We recently helped a customer migrate 198,000 Word, Excel and PowerPoint documents to Office 2007 format, then convert from UK English to US English. This used a search/replace list of 1,750 terms, and used our Search and Replace Server Bundle on a high-end Amazon EC2 Windows 2012 instance. Our consulting team monitored the process from start to finish.

Screen shots more ►

ExcelPipe's default screen (Click for more)

Testimonials

ExcelPipe works like a dream. I'm amazed by its speed! Michael Plant

This thing is great! I494 files changed in about 20 minutes........I'm tickled to death. Ed Baumgarten, IT Manager, Mid America Motorworks

My initial use was a smashing success and I am recommending to our IT manager that it is definitely helpful and worth getting. It was truly a great time saver. Janet Aldrich

I recommend ExcelPipe to anybody who has to make bulk changes in Excel - at this price you can't afford not to use it. Jonathan Defoy, CEO Biztree Inc

 

Buy ExcelPipe Now Start saving your time now

Awards

BrotherSoft

ExcelPipe Configurations

ExcelPipe comes in a number of different configurations to suit your deployment profile. Click below to read more about each configuration:

• ExcelPipe Lite for small office / home office. Limited to 100 files per run, no auto-recovery.
• ExcelPipe Full no limits
• ExcelPipe Pro Floating empower your entire team
• ExcelPipe Server run jobs directly on your File Server
• Full comparison chart

We also provide Professional Services and can tailor ExcelPipe to suit your requirements.

See also

• TextPipe industrial strength text conversion, transformation, cleansing and extraction workbench
• WordPipe search and replace in Word documents
• PowerPointPipe search and replace in PowerPoint presentations
• Clicker App - a tool to clear unwanted popup windows and dialog boxes originating from Microsoft Word, Microsoft Excel and Microsoft PowerPoint

Buy Download

find and replace in excel, how to find and replace in excel, find and replace in excel 2016