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
    2012-11-18T05:07:18+00:00

    See if this video helps:

    How to copy all file names into excel

    Thanks a lot. This worked for me. 

    To anyone following this thread if you have a problem changing the file extension, see this page:  http://www.mediacollege.com/microsoft/windows/extension-change.html

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-11-18T05:26:40+00:00

    Couldn't follow what was going on in that video.

    1. Right click on your Desktop.
    2. Select New then Text Document
    3. Rename the Nex Text Document.txt to Listing.txt
    4. Open Listing.txt
    5. Type the following, making sure you keep the spacing as is:

    dir/b "." >dirlist.xls

    1. Close the document and click Save
    2. Go to Start and select Computer
    3. Open Desktop
    4. Go to Organize, then to Folder and Search Options
    5. Click the View tab
    6. Uncheck the box "Hide extensions for known filetypes"
    7. Click Aplly and then Ok
    8. Go the the file Listing.txt. Right-click on the name and change the extension from .txt to .bat, then click Enter
    9. Click Yes to confirm the change of the file extension
    10. Move that file into any folder where you want to copy the file names into excel
    11. Double click on the file and it will open an excel document with your files listed.
    12. You can then move Listing.bat to another location if needed

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-11-18T13:33:18+00:00

    You might be interested in my DirTree add-in, available free from www.cpearson.com/Excel/FileTree.aspx .

    Was this answer helpful?

    0 comments
  4. Anonymous
    2012-11-18T15:19:39+00:00

    You might be interested in my DirTree add-in, available free from www.cpearson.com/Excel/FileTree.aspx .

     

     

    Thanks. I like your add-in, it works very nicely. A lot easier then the other solution I had found.

    By the way your link did not work, but I found it by surfing your site, and this worked:  http://www.cpearson.com/excel/FolderTree.aspx

    I am bookmarking your website and will browse it at a later stage. Thank you for helping us folks who want to do a little bit more but don't know enough.

    Was this answer helpful?

    0 comments