Excel Find & Replace Batch

Excel Search and Replace Tool is a remarkable Find and Replace tool for MS excel files that helps the user to carryout Find and Replace and formatting tasks in multiple excel files in a time saving manner. Tool allows the user to add large number of files at one go. User can add files by clicking ‘add files’ or ‘add folders’ button. After clicking on ‘add files’ button user has to select files to be added but by clicking on ‘add folder’ button user can automatically add all files contained in the folder. User also has the option to remove any or all added excel files. After adding files user needs to add words that need to replaced (Find what) and words with which these words need to be replaced (Replace with). User can add words one by one or load word list from TXT or CSV files. By loading words from TXT or CSV files user can save considerable time. After adding words user can highlight or format words and phrases in ‘find what’ or ‘replace with’ list or even edit text. User can seamlessly carry out different formatting tasks like bold, italic, underline etc. in this step. User has the option to even remove all the selected words from the list or clear all formatting. User has the option to save processed files in separate folder or in the source folder itself. Tool provides backup facility so that original files don’t get overwritten. Tool also generates log file giving details of data processed.

In the present scenario, Excel search and replace tools like this one have become a necessity for offices, as most offices rely heavily on MS excel to process and store data. Processing large scale data on MS excel without the use of excel addins becomes very cumbersome. This has given rise to efficient Find and Replace tools for excel. Recognising this ned we have come up with this tool. This tool assists the user not only to find and replace in excel but also carryout formatting tasks in multiple files at one go.