Friday, July 20, 2012

Export Files and Folders in a Windows Folder to Excel

Not surprisingly this is quite easy; just do a select all (CTRL + A) in your folder and mouse Right Click while holding the SHIFT key; in the ensuing menu select the option Copy File Paths. 

Now open an excel worksheet and just paste. This will show you your total file path including directory path; if you want to get rid of this just do a find and replace to "". And you have your imported list of objects in a Folder.

Hope this helps...

No comments:

Post a Comment