Friday, December 16, 2011

Save Windows 7 Search Results as Text File

I recently had to create a list of over 3000 files that were dispersed amongst 60 folders. In the past, I would have used NirSoft's SysExporter, but unfortunately it does not work with Windows 7.

Fortunately, rummaging around in my internet, I found a simple way to make lists from Windows Searches. Here is a step by step guide.

Select the directory that you want to search:

Click images to enlarge

Enter your search:


Once you have your list, select all results and hold the Shift key and right-click on the list. Select "Copy as path" from the menu:


Now you can paste the results in a text document - here I have pasted the results in Excel (2007):


To get rid of all the path information, choose "Text to Columns" from the Data menu:


Then press the radio button for "Delimited":


And set the back-slash "\" as your delimiting value:


This will make the file name its own column:


And you can throw out all the path information and have a nice clean file list:


4 comments:

  1. Fantastic. I thought I was going to have to install a third party app to store my search results as a list. Thanks!

    ReplyDelete
  2. Wow, This soulution hits 2 birds with one:
    1. The search list that led me here and the
    2. Excel trick '"Text to Columns" from the Data menu' that I did not know about.
    Thank you so much!!!

    ReplyDelete