Share via

How do I export File Directory information in CSV format?

Anonymous
2012-06-18T16:42:56+00:00

I have created large file directories for files that I have captured digitally.  I need have the file directory information in a spreadsheet so as to determine the total number of pages that were caputred. 

It is labor intensive to type the file directory information into spreadsheet.

If anyone as a methodology to accomplish this task it would be appreciate.

Archivers

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
    2012-06-18T18:22:14+00:00

    Here are two methods I use to capture/save/print file information, which may help you:

    1. To display the contents of a folder open Windows Explorer, navigate to the source folder and press Ctrl+A to select all the items. Hold down the Shift key, right-click on the selection and choose Copy as Path. Open your spreadsheet program (or word processor), paste (Ctrl+V) the list to it and adjust the width of the column. You can now print it, edit it or save it and add to it later.
    2. To display the folder hierarchy, open Windows Explorer, navigate to the folder you wish to start at, hold down the Shift key, right-click on the folder name and choose Open command window here. Type tree |clip and press Enter. Open your word processor program and paste (Ctrl+V) the list to it. You can now print it, edit it or save it and add to it later.

    Switches are tree /a |clip (use text characters) and tree /f |clip (display files in each folder).

    100+ people found this answer helpful.
    0 comments

Answer accepted by question author

  1. Anonymous
    2012-06-21T15:18:29+00:00

    Hi,

    You can do so by exporting the names to a text file using Command Prompt.

    a. Click Start, click All Programs, click Accessories, right-click Command Prompt, and select Run as Administrator.

    b. Browse to the location that contains the files and folders whose list of names you want to generate.

    cd <path>

    Path is the location of the main folder that contains the files that you want the names of. For example, E:\New\Folder is a path.

    c. Next, enter the following command to copy the names of the files and folders to a text file.

    Dir /b > Myfileslist.txt

    d. The text file will be saved in the same location as the files whose name you want.

    80+ people found this answer helpful.
    0 comments

8 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-07-04T12:58:25+00:00
    1. In the directory where are your files make new Text Document and name it dirTOfilelist.bat
    2. Than Edit it and write in dir /b > Dirlist.txt
    3. Save and close.
    4. Run this dirTOfilelist.bat by doubleclicking on it.
    5. Dirlist.txt with your file list appears.
    6. Move this file anywhere you want and run it to have a list of that directory ;)

    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2014-09-17T21:32:55+00:00

    Here is a one-liner PowerShell command to write directory to CSV with metadata (size, owner, last modified date)

    3 people found this answer helpful.
    0 comments