I have hundreds of .csv files that contain lots of data and i was wondering if it is possible to search for specific word all .csv files without opening them?

Thanks!          

You can do this without Excel - only with Windows. Which version do you use?

Some hints for XP: http://support.microsoft.com/kb/309173

Windows 7 already does indexing for csv files as you can verify by running "Indexing Options".

Thanks, but I mean to find a text inside the .csv files not in the file names. 

The Windows Index Service finds text inside the files as well. Just try it.

• Marked as answer by Nick WanModerator Thursday, August 18, 2011 2:26 AM

I realise your post is 2 years old, but if you are still needing to search multiple csv files I have an application designed to do that.

It will search a folder (and sub folders) for csv files, then search inside each csv file for the search criteria.
Results are then displayed as tabulate tables, with the option to save or copy the results, or open the parent file.

The utility is free. I have used it for over a year now, and I would not be without it.

I can send you a download link if you are still interested.

• Edited by webmayo Saturday, July 20, 2013 1:50 PM typo in reply

send me the link on tehseenahmad@gmail

I tried sending the link but the mail bounces back.

Anyway, I didn't realise I could post the link here.

The website is genscriber.com and the details are here...

http://genscriber.com/genapps/viewtopic.php?f=2&t=198

Direct download link...

http://genscriber.com/download/download.php?file=csvfilesearch_windows.zip

• Edited by webmayo Saturday, July 27, 2013 6:35 AM link missing

Hey Webmayo,

I downloaded Genscriber and am trying to do what you describe and cant fingure it out for the life of me. Looked in their help section too with no solution, can you give a few quick pointers of how you search like this with Genscriber please?

Thanks!!

Nope, this is a lie.  You should be fired.

Another lie.  This is potentially actionable.