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".
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!!