How to search all excel files for a keyword ?

[Deep_Level_Shark]

I want to search a text in all excel files under C:\

which tool can help me ?

[jakem1]

Windows Explorer. If you're using Vista or higher you will need to index the locations you want to search.

[+Nik Louch Subscriber²]

I would use win grep - specify filetype, location and words

[Deep_Level_Shark]

  On 27/05/2013 at 11:24, jakem1 said:

Windows Explorer. If you're using Vista or higher you will need to index the locations you want to search.

windows 7.Enterprise.

How do I tell windows explorer to filter only excel files and search a specific keyword ?

Can you please tell me the steps ?

  On 27/05/2013 at 11:46, nik louch said:

I would use win grep - specify filetype, location and words

I am getting multiple matches for this tool in google. Can you please tell me which one to download ?

[+Nik Louch Subscriber²]

http://www.wingrep.com/

[Torolol]

which version of excel files?

version 97-2003 (.xls) can be searched directly as the content is not compressed, you can use program like SearchMyFiles from Nirsoft

version 2007-... you need program that can search within .zip files, as .xlsx really are .zip file.

EDIT: yeah wingrep can do this as its support searching within .zip files.

[jakem1]

  On 27/05/2013 at 11:48, Deep_Level_Shark said:

windows 7.Enterprise.

How do I tell windows explorer to filter only excel files and search a specific keyword ?

Can you please tell me the steps ?

Run through these steps first to ensure that Explorer searches file contents:

http://www.wikihow.com/Make-Windows-7-Search-File-Contents

Then in the search box type kind:spreadsheet followed by the text you want to search for. For instance, kind:spreadsheet income will find all spreadsheets containing the word income.