How to Create Excel Spreadsheet of Folder & Subfolder Directories

Written by mercedes t. green
  • Share
  • Tweet
  • Share
  • Email

Documenting your directory tree can be an arduous process. While a screen print would suffice to document a small number of folder and subfolder directories, it's not the best choice for documenting large numbers of folders. You could output the directory listing to a printer but that lacks the options to send it in e-mail or store it electronically. Instead, document your folders using the DOS command window and Microsoft Excel to give yourself and your team the most flexible options for storage and communication of the data.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Log in to your computer as an administrative user.

  2. 2

    Open a command window by holding down the "Shift" key on your keyboard while you right-click anywhere on your desktop. A menu will appear. Click "Open a Command Window Here." A command window will open on your desktop. You will see a few words followed by a blinking cursor.

  3. 3

    Type "CD\" after the blinking cursor (do not type the quotation marks). Press the "Enter" key on your keyboard. A new command line will appear below. It should read "C:\>" followed by the blinking cursor.

  4. 4

    Type "dir /ad /s >c:/directories.txt" (do not type the quotation marks). Press the "Enter" key on your keyboard.

  5. 5

    Type "Exit" and hit the "Enter" key.

  6. 6

    Open Excel. Click "File" and "Open." Choose "Text Files (.prn; .txt; *.csv)" from the "Files of type" drop-down box. Select the file "c:\directories.txt." Click the "Open" button.

  7. 7

    Click the "Delimited" button. Click the "Next" button.

  8. 8

    Check "Tab" in the "Delimiters" area of the "Text Import Wizard" window. Click the "Next" button.

  9. 9

    Click the "Finish" button. Save the file.

  1. 1

    Log in to the computer as an administrative user. Open a command window by holding down the "Shift" key on your keyboard while you right-click anywhere on your desktop. A menu will appear. Click "Open a Command Window Here." A command window will open on your desktop. You will see a few words followed by a blinking cursor.

  2. 2

    Type "CD\" after the blinking cursor (do not type the quotation marks). Press the "Enter" key on your keyboard. A new command line will appear below. It should read "C:\>" followed by the blinking cursor.

  3. 3

    Type "dir /ad /s >c:/directories.txt" (do not type the quotation marks) . Press the "Enter" key on your keyboard.

  4. 4

    Open Excel. Click the "Office" button and "Open." Choose "Text Files (.prn; .txt; *.csv)" from the "Files of type" drop-down box. Select the file "c:\directories.txt." Click the "Open" button.

  5. 5

    Click the button for "Delimited." Click the "Next" button.

  6. 6

    Check "Tab" in the "Delimiters" area of the "Text Import Wizard" window. Click the "Next" button.

  7. 7

    Click the "Finish" button. Save the file.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.