Share via

Export List of Files in an Explorer Folder

Anonymous
2010-05-19T22:48:06+00:00

How can I export a list of files located in a file folder to excel or to a text document? Preferably excel.

Thank you,

Tom

Windows for home | Previous Windows versions | Files, folders, and storage

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

  1. Anonymous
    2010-05-20T14:10:26+00:00

    Hello Tom,

    You can simply paste the list into Excel, as follows:

    1. Open Windows Explorer and select the source folder in the left pane.
    2. Press Ctrl + A to select all items in the right pane.
    3. Press and hold the Shift key, then right click on the selection.
    4. From the context menu, choose "Copy as Path".
    5. Paste the list into Excel.

    Doug M. in NJ

    1700+ people found this answer helpful.
    0 comments

Answer accepted by question author

  1. Anonymous
    2012-10-26T00:04:08+00:00

    You must have the directory you wish to list on your hard drive(not a network share although a mapped drive may work?

    Files should be displayed in the details format within the directory.

    1. type cmd into the start menu to bring up a dos prompt
    2. use the command (for instance)   "cd C:\Users\BobJones\Desktop\New folder" to navigate to the folder in question
    3. use the command "DIR > doggy.csv" to create a file named doggy.csv in the same directory that you can open directly with excel. Nothing much looks lik it is happening but you wuill find the small file as expected.

    Good Luck!

    200+ people found this answer helpful.
    0 comments

39 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-01-24T07:01:50+00:00
    1. Open the folder in in question right click on the address bar, select copy address.
    2. Paste the address into you Google Chrome address bar. 
    3. This will show the contents of your folder in Chrome.
    4. Select all contents of the Chrome page, copy and paste into Excel

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2010-05-20T10:47:11+00:00

    Here'a an article on how to save and print the contents of Folders in Vista: http://www.vistax64.com/tutorials/114593-file-folder-directory-list-print-save.html.  I think this will give you what you need (and provides several options).

    If you have any further questions about Excel, please repost your question on the Office Discussion Group at: http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.misc&lang=en&cr=US where experts in Excel will be happy to assist you with your question.

    I hope this helps.

    Good luck!

    Lorien - MCSE/MCSA/Network+/A+ --- If this post helps to resolve your issue, please click the "Mark as Answer" or "Helpful" button at the top of this message. By marking a post as Answered, or Helpful you help others find the answer faster.

    4 people found this answer helpful.
    0 comments
  3. Anonymous
    2010-11-30T20:47:01+00:00

    I am using Win XP SP3 and I didn't have a "copy as path" option, only copy (which didn't work).

    Do you have another idea I can try?

    Thanks, Laveda

    2 people found this answer helpful.
    0 comments