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-08-15T03:48:07+00:00

    To copy file names from explorer to past into excel without downloading software nor use VBA

    • Go to command prompt (RUN / CMD)
    • go to the desired directory and type dir
    • Copy the list of the file names
    • Past it in Excel.

    It is as simple as that

    This is sheer brilliance! And I get to yank out old DOS commands like CD and DIR/W. Wish I could buy you a drink.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-05-07T13:19:17+00:00

    Use CD to move to the directory which takes the path as input.  If you need the path and don't want to type by hand, using windows explorer, select one of the files choose copy path from the ribbon.  Paste that into notepad, select just the path including the drive letter (minus the filename and tic marks), and past that into the shell after the cd command.  Now you are in the directory.  Issue the dir command to verify.  Then issue dir with /b for bare.  This gives filenames only allowing a cleaner list.  Mark and copy that back into notepad, and then from there into excel.  If you want to remove file extensions, use replace all in excel. It's a few steps, but can be done quickly and without loading more software to your system.  Once you get the hang of it, the process goes quickly.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-11-19T05:27:53+00:00

    hi admin how to do this procedure(run/cmd) please help thank you

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-11-29T07:18:09+00:00

    Hi

    Start Key + R (Run)

    type cmd + Enter

    Regards

    JY

    Was this answer helpful?

    0 comments