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:
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:
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:
perfect!!!
ReplyDeleteFantastic. I thought I was going to have to install a third party app to store my search results as a list. Thanks!
ReplyDeleteThank you. Great soultion!
ReplyDeleteWow, This soulution hits 2 birds with one:
ReplyDelete1. 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!!!