Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Yen asked in Computers & InternetSoftware · 8 years ago

For Windows, is there an easier way to copy-paste ALL the file names inside a folder to a text/excel document?

I have a folder with a bunch of files. For example, folder C:\Users\AAAA\Desktop\stuff has 150 ridiculous file names like "vous etes tres gentil.xls," "je ne sais quoi.ppt," and "iwe478r5yGHFAS.png."

I am trying to gather all the file names in a text document and I have been doing it the hard way by typing out the easy and memorable file names one by one and copying and pasting the longer/forgettable file names one by one to the text document. I eventually need to import the text document to excel.

Is there a better way to do this? There should be a program or a setting that allows you to copy and paste all the file names inside a folder in one non-heineous, non-redundant manner.

I know in linux, all you need to do is type in "./" or something and it automatically lists all the file names within a folder from the command prompt. Is there a similar function in Windows/Microsoft Office (more specifically in Excel)?

3 Answers

Relevance
  • 8 years ago
    Favorite Answer

    open notepad > copy paste this

    dir /b > files.txt

    then save it as files .bat (make sure the extension is .bat)

    place this file into a folder with a bunch of files

    then just double click on it, you will get the list of filenames stored into files.txt.

    or you can use

    dir /b /s > files.txt

    if you want a recursive listing.

  • ?
    Lv 7
    8 years ago

    Open a command prompt, go to the relevant folder and type:

    dir /b > folder.txt

    That will create a text file called folder.txt containing all the filenames. You can open that in Notepad or whatever and copy all the file names from there.

  • Anonymous
    8 years ago

    Have a go with "Karen's Directory Printer" (freeware):

    http://www.karenware.com/powertools/ptdirprn.asp

Still have questions? Get your answers by asking now.