Search text in multiple Excel files

Wondering how to find a specific Excel file amongst thousands of others by a specific text it contains?  If you are using Windows 7 or newer versions, you should be able to customize the search options available in Windows Explorer.

 

Using the Windows Explorer search, and the Indexing options

 

Open Windows Explorer by right clicking the Start button in the bottom left corner. Go to your folders with Excel files, or to My documents.

 

If you wish to adjust search features of Windows Explorer Search, from the menu choose Organize –  Folder and search options and navigate to the Search tab.

 

 

2. Search text in Excel files

 

 

If you usually search within small folders with a small number of files, you may choose “Always search file names and contents” option. Otherwise, choose the first option – to search contents in indexed location only.

 

Other tips for using the Advanced Query Syntax feature of Windows Search

 

You can search for an exact phrase in the content of an excel file by adding quotation marks around it in the Search box in Windows Explorer.

 

Also, you can limit your search to Excel workbooks only. This can easily be done by either adding a plus sign after the text you are searching for and then adding xlsx.  An example might be “Search: damaged equipment + xlsx”. This will make the search limit itself to finding the words “damaged equipment” in the content of xlsx files only.

 

Software and tools for searching through the content of your Excel files

 

There are various tools, add-ons and extensions available for a concise and quick search through your multiple Excel files.

 

SeekFast

 

SeekFast a desktop tool which is very easy and straightforward to use, and yet can rapidly go through thousands of your documents. The most relevant results will be displayed on the top, where you can see a preview or view the file itself with just one click.

 

 

Windows Explorer search

 

 

The best part about using this tool is that no indexing of every single file is necessary, unlike the case with the Windows integrated search option.

 

SeekFast can be accessed by clicking the right mouse button on a folder, and it will pop up as one of the menu options.

 

 

Windows Search

 

 

The tool can search for specific content in a wide variety of files, including doc, docx, pptx, xlsx, xls, odt, rtf, txt, pdf, txt, Java, html, php, xml, and many more.

 

So don’t waste hours trying to customize your Window search options, or trying to find the exact Excel file you are looking for, and try out the powerful and easy to use search desktop tool SeekFast. You will never loose precious time trying to locate a specific file on your computer ever again.

 

SearchMyFiles

 

SearchMyFiles allows for easy search of various kinds of files, including Excel files – by date modified, by last accessed, date created, and can also search through the content of your files as well. However, it only displays a list of file names, containing the searched text.

 

 

Software and tools for searching