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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-02-28T15:41:44+00:00

    works like a charm! thanks so much....

    in a nutshell: create a text document in the same directory that you want to extract the file names from. In the blank text document type:

    dir /b *.* >dirlist.xls

    in this example you will create an excel file called "dirlist" but you can give it any name you want.

    Save the file. Then change the extension of the file from ".txt" to ".bat", it will ask you to confirm that you wnat to change the file extension, make sure to reply yes.

    The icon of the file changes to "gears" and when you double click on it, it executes the action you just asked it to do (i.e. create the excel file with all the file names).  

    Thanks again!

    Alessandra

    THANK YOU FOR THIS! Alessandra's method is the ONLY one that worked for me!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-01-24T15:08:44+00:00

    Best and easiest solution. Thanks!!!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-10-06T19:47:10+00:00

    Please search in google for a free program named ClipName .

    Read the description,

    Download it,

    Install it

    and you will solve your problem once and for all.

    Greetings from Greece.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2013-10-04T11:23:07+00:00

    can't seem to use my mouse in the command prompt window...

    Was this answer helpful?

    0 comments