Searching multiple excel documents one by one can be difficult. However, PowerShell is an amazing tool for search through tons of information. Below is the instruction on how to search multiple excel docs and return the matches.
Note: I do prefer to search the file format
.csv, however you should have no problem with
- Navigate to the directory you wish to search (This works best if all excel documents are in the same folder).
- Run the command listed below replacing
“searchabletext”with what you want to look for.
Get-Children -Recurse | Select-String “searchabletext” -list -Context 0,0