Exporting Windows Explorer Search Results

Posted on 2004-11-21
Last Modified: 2008-10-03
Can some pls tell me how to export the windows explorer search results into an excel ?
I am on Win 2K Professional OS.
thanks and regards.
Question by:jmaruthi
    LVL 9

    Accepted Solution

    Hello Maruthi,

    I doubt if you can do it from Explorer.

    Use "Agent Ransack" (freeware) from instead.

    It is not only much faster, also gives you option to export search results in text/CSV format.
    You can then open CSV formatted file in Excel.

    LVL 11

    Expert Comment

    Open a DOS window or write a batch file to do something like:

    dir test* /s >c:\temp\dir.txt

    The "TEST*" is only an example of what you can search for.  The /s also looks in subfolders, depending on where you start the search from.

    The "TXT" file can then easily be imported into Excel.

    LVL 3

    Expert Comment

    Sorry, there is no way to export explorer search results to excel.

    Author Comment

    thanks to all..i have exported the search results using thirdparty tools..
    LVL 11

    Expert Comment

    Run the batch file mentioned in my previous comment.

    Set up a makro in an empty Excel Table, something like this:

    Sub Makro1()
        ChDir "C:\Temp"
        Workbooks.OpenText Filename:="C:\Temp\dir.txt", Origin:=xlWindows, _
            StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1), Array(9, _
            1), Array(31, 1), Array(39, 1)), TrailingMinusNumbers:=True
    End Sub

    LVL 2

    Expert Comment

    There is a mesed up way to do it. Very messed up time comsuming. Don't use this solution use the DOS solution as it is a much better answer. This answre does answer your question exactly. Take a screen shot of the search results, use a text recognition software to get the text. Better solution would be to use the sendmessage api to get the actual text.

    I wish windows seach had an AND OR and NOT operator. The ability to save a set of files and reseach them given new parameters..

    anyway use DOS
    LVL 9

    Expert Comment

    Thanks, Turn & Modulo.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Suggested Solutions

    This is a quick article, and by no means should you quit your job today or plan to feed your family of 5 on a business idea. Starting a business takes work. This article will only give you the basic skeleton of understanding. Going into business for…
    Whether you believe the “gig economy,” as it has been dubbed, is the next big economic paradigm shift ( or an overstated trend (…
    Saved searches can save you time by quickly referencing commonly searched terms on any topic. Whether you are looking for questions you can answer or hoping to learn about a specific issue, a saved search can help you get the most out of your time o…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now