Jump to content



Photo

How to search all excel files for a keyword ?


  • Please log in to reply
6 replies to this topic

#1 Deep_Level_Shark

Deep_Level_Shark

    Neowinian

  • Joined: 02-December 05

Posted 27 May 2013 - 11:21

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


which tool can help me ?


#2 jakem1

jakem1

    Neowinian Senior

  • Tech Issues Solved: 3
  • Joined: 17-November 06

Posted 27 May 2013 - 11:24

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

#3 +Nik L

Nik L

    Where's my pants?

  • Tech Issues Solved: 2
  • Joined: 14-January 03

Posted 27 May 2013 - 11:46

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

#4 OP Deep_Level_Shark

Deep_Level_Shark

    Neowinian

  • Joined: 02-December 05

Posted 27 May 2013 - 11:48

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 ?


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 ?

#5 +Nik L

Nik L

    Where's my pants?

  • Tech Issues Solved: 2
  • Joined: 14-January 03

Posted 27 May 2013 - 11:57

http://www.wingrep.com/

#6 Torolol

Torolol

  • Joined: 24-November 12

Posted 27 May 2013 - 12:00

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.

#7 jakem1

jakem1

    Neowinian Senior

  • Tech Issues Solved: 3
  • Joined: 17-November 06

Posted 27 May 2013 - 12:25

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.c...h-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.