none
How to export search results to Excel or Notepad RRS feed

  • Question

  •  

    Hi all,

     

    I want to know is there any way to export search results in windows to an excel sheet or notepad?

    Or is there any program or code either in vb or java which can run to look for specific file extensions under home directories of users and list them or export them to excel sheet.

     

    Thanks for your support in advance .

     

     

    praveen

    Wednesday, February 27, 2008 6:16 PM

All replies

  •  

    I could really do with this functionality as well, does anybody have an answer.
    Thursday, March 13, 2008 11:06 AM
  • I found this bit of freeware rather handy.

     

    http://www.nirsoft.net/utils/sysexp.html
    • Proposed as answer by mdolnik Friday, August 19, 2016 12:14 AM
    Thursday, March 13, 2008 11:34 AM
  • I too would like to see the results of a search in an exportable format.

    Tuesday, November 11, 2008 8:58 PM
  • There is no way to export search results from the explorer window.

    But, you can use Excel built in query support using ADO and directly query the search index. 

     

    http://msdn.microsoft.com/en-gb/library/bb266517(VS.85).aspx

     

    Thursday, November 20, 2008 7:03 PM
  • I found this bit of freeware rather handy.

     

    http://www.nirsoft.net/utils/sysexp.html
    This rocks!
    Wednesday, February 10, 2010 7:30 PM
  • Hi, this is an old thread, but I hope this info can be useful for somebody:

    you can make this with "DIR" command:

    dir *search-pattern* *modifiers* > *output-file"

    For example, if you want to export a search of names of files with .pdf extension located in c:\home\user and its subfolders to a text file:

    dir c:\home\user\*.pdf /s /b > result.txt

    Regards,

    Dani.

    • Proposed as answer by RonNasty64 Friday, May 24, 2013 3:54 PM
    Wednesday, December 1, 2010 11:38 AM
  • I'm not technical.  I found success by using the SNAG IT* photo-editing software - a business tool that I use daily.  SNAG IT enables you to take a screenshot of a screen (even a scrolling window, such as the search results window) and saves the results as text. 

    My steps:  I did a search in excel.  Got the excel search results window.  Used SNAG IT to take a "picture" using the scrolling window/text capture feature.  Snag it placed the data in a text file.  I copied the data from the text file and opened up excel and cut and pasted it into a new workbook.  Voila!  Editable search results for someone who is not a programmer or developer. 

    *I work for an apparel company, not for snag it.*

    Wednesday, October 26, 2011 2:43 PM
  • Try this in a DOS/Cmd Prompt window

    To find files that contain a specific string

    findstr /s/i/m "payday" *.doc

    /s - Searches for matching files in the current directory and all subdirectories

    /i - ignores case

    /m - Prints only the filename if a file contains a match.

    DOS ROCKS!

    Tuesday, January 24, 2012 6:02 PM
  • Great little simple tool indeed ! nice one !
    Sunday, May 27, 2012 12:14 AM
  • This works great! I use it all the time now.
    Wednesday, July 11, 2012 2:30 PM
  • Hi,

        Check this one..

    http://www.nirsoft.net/utils/search_my_files.html

    This has more functionality and it's free of charge too..


    Pasan Indeewara

    Monday, July 16, 2012 9:17 AM
  • Found this a few years later looking for how to export Excel Find results as text (Google suggested this page.)  Rather than all the suggestions of going through VBA or using a plug-in, I used Snagit to capture the text.  Beautiful.  I do not work for TechSmith either.  :)  Thanks for the post!
    Wednesday, February 6, 2013 9:20 PM
  • Hi, this is an old thread, but I hope this info can be useful for somebody:

    you can make this with "DIR" command:

    dir *search-pattern* *modifiers* > *output-file"

    For example, if you want to export a search of names of files with .pdf extension located in c:\home\user and its subfolders to a text file:

    dir c:\home\user\*.pdf /s /b > result.txt

    Regards,

    Dani.

    I use a similar dir command, and import the txt file into Excel.
    Friday, May 24, 2013 3:54 PM
  • easy.

    use textpad

    Search > Find in Files > whatever_string

    and you should have a cut and paste text right there.

    Friday, August 23, 2013 10:56 PM
  • In another forum the suggested this and it works:

    I have faced this problem before, and this is how i ended up getting that list:

    1 - Open Windows Explorer and search for what you want
    2 - When the search results populate, select all (Ctrl + A)
    3 - Hold the Shift key and Right Click on the search results
    4 - Select "Copy as Path" (this option only shows up when you hold shift before the right click)
    5 - Paste into a notepad window, Excel spreadsheet, etc...

    The results will be formatted as:
    "\path\to\first\item"
    "\path\to\second\item"
    ...

    Hope this helps.
    Tarek


    IT man

    • Proposed as answer by alesit0 Sunday, April 13, 2014 2:38 AM
    Wednesday, March 19, 2014 12:44 AM
  • The absolutely best answer, simple and quick!
    Thursday, August 14, 2014 9:23 PM
  • I also agree. 

    After exporting to excel you can use Text to columns (from the data tab) and use \ as the delimiter. This will split the cells so you can remove the path and have all of the files names in one cell.

    I don't know why Microsoft could not show this in the help. Would save a lot of google time.

    Sunday, September 21, 2014 4:30 AM
  • For a comprehensive utility to get listings of almost anything from Windows Explorer, including search results, have a look at ExpPrint: http://www.jddesign.co.uk/products/expprint/expprint.htm
    Sunday, September 21, 2014 7:52 AM
  • I found this bit of freeware rather handy.

     

    http://www.nirsoft.net/utils/sysexp.html

    This program works really well (works in windows 10 and presumably all versions prior) and is able to export whatever columns you have in the windows search result.

    A quick bit of instructions...

    • Have your windows search window ready in the details view with whatever columns you want
    • Drag the target/bullseye icon from SysExporter to the search window
    • In SysExporter click File > Export All Items
    • Save as txt, csv, xml, html, etc

    Friday, August 19, 2016 5:05 PM
  • Works very well and is a standalone program.
    Wednesday, February 28, 2018 4:47 PM