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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2015-04-08T11:21:56+00:00

    In Windows 7, the easiest way would be this command

    dir /B | clip

    Wow! Had used DOS for years but never knew this option...

    Is it something new or has it always been there?

    Was this answer helpful?

    0 comments
  2. 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
  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-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