[Search tip detail and code files using keywords, tip number, author name, etc ]
 
Copy List of Files from Explorer as Text into Excel
Tip# 4313 By Tina Stimpson On 02-Jun-2014
0
Rated By 0 users
Categories : Misc. User Tools
Software type :
Rename File To : No Files to download.
This tip allows you to select a list of files in Windows Internet Explorer and then put this same list of files into Excel.

I am sure at some point in your career you have wished for a command that would allow you to select a list of files in Windows Internet Explorer and somehow put this same list of files into Excel without having to either do screen shots or type in the file names one at a time. Here's how:

In Explorer, highlight one or more files.

Hold down the Shift key, and right-click any of the selected files. (If you fail to hold
down the Shift key, you will not get the context menu shown below.)

When the context menu pops up, left-click Copy As Path. (This appears only when you hold down the Shift key.)

Now open an Excel file and paste in your selection. It should look something like this.

Modify the text as you wish from here. It is much faster to delete the full path than to type it all or make screen shots.

Notes from Cadalyst tip reviewer R.K. McSwain: This is a nice trick that has nothing at all to do with CAD, but we think a lot of CAD users will like it. It is a simple way to copy the filename and path of multiple files into Excel. If you don't want the path, use Find and Replace inside of Excel to get rid of it.
 

 

Average Rating:
0


User comments
Comment by Rydman,Doug
Posted on 2014-06-02 15:30:10
This also works for Word in addition to Excel.
Comment by Rydman,Doug
Posted on 2014-06-02 15:30:36
This also works for Word in addition to Excel.
Comment by O'Connor,Art
Posted on 2014-06-03 14:44:03
In windows 8, Copy Path is located on the Home tab of the Ribbon. No need to use shift key.
Comment by O'Connor,Art
Posted on 2014-06-03 14:55:27
If you need all the File Explorer information, such as file size and date, use the Snipping Tool in Windows since Vista.
Comment by McSwain,R.K.
Posted on 2014-06-04 08:17:48
Good comments guys! I did not have a chance to test this with Windows 8, so thanks for that additional tip.