copy file names from explorer to paste into excel

Anonymous
2009-06-30T14:00:06+00:00

I am trying to copy a long list of file names in file explorer and paste them into excel so I can keep track of file status, is there an easy way to do this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Hal Hostetler MVP-Outlook 12,011 Reputation points MVP Volunteer Moderator
2009-06-30T22:52:55+00:00

Thereare a number of ways to print Directory listings detailed here:

Print directory - Vista Forums

Hal

-- 

Hal Hostetler, CPBE

Senior Engineer/MIS -- MS MVP-Print/Imaging -- WA7BGX

www.kvoa.com -- KVOA Television, Tucson, AZ. 

Live at Hot Licks - www.badnewsbluesband.com

Was this answer helpful?

10+ people found this answer helpful.
0 comments

45 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2015-03-22T17:35:23+00:00

    you can use the cmd.exe to copy all of your files in the folder.  

    1. Click start > in the search box, type cmd > click on the cmd program.
    2. In the cmd > type cd /d C: or D: (hard drive) + location (you can get your location by right click on the folder > Properties > Location > type in the exact destination to the location) > press enter. The next line should be in the folder that you want to list the name.
    3. type in dir > enter (this command will list all of the file names in your folder)
    4. Right click, choose select all > Ctrl+C (copy) > paste it into Notepad or Word (it will copy whatever listed on the cmd screen).

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-04-08T00:58:17+00:00

    Perfect, basically a little program that does exactly what you need.  Took me 2 seconds to put it together.  Worked like a charm (Windows 7, Excel 2007).  Thanks!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-04-08T08:14:22+00:00

    To get a list of filenames  (including path) into excel: 

    1. Start Explorer  ( i.e. with Windows+E) 
    2. Go to folder with files you want to list.
    3. Select all filesnames you want to list in Excel
    4. Press SHIFT + right mouse click.
    5. select option " Copy as Path"
    6. go to excel and paste.

    Voila

    Was this answer helpful?

    0 comments
  4. Anonymous
    2015-04-08T10:37:51+00:00

    Thank you Peter Wijntjes, what a simple and easy solution, love it.

    Was this answer helpful?

    0 comments