How to Create Excel Spreadsheet of Folder Subfolder Directories

In Excel 2003 and Older
1. Log in to your computer as an administrative user.
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. 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. Type 'dir /ad /s >c:/directories.txt” (do not type the quotation marks). Press the “Enter” key on your keyboard.
5. Type “Exit” and hit the “Enter” key.
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. Click the “Delimited” button. Click the “Next” button.
8. Check “Tab” in the “Delimiters” area of the “Text Import Wizard” window. Click the “Next” button.
9. Click the “Finish” button. Save the file.
In Excel 2007
10. 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.
11. 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.
12. Type 'dir /ad /s >c:/directories.txt” (do not type the quotation marks) . Press the “Enter” key on your keyboard.
13. 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.
14. Click the button for “Delimited.” Click the “Next” button.
15. Check “Tab” in the “Delimiters” area of the “Text Import Wizard” window. Click the “Next” button.
16. Click the “Finish” button. Save the file.