Forum Discussion
How do I get Directory F: list copied into EXCEL worksheet
I can get a directory list for F: using Explorer. I can't find a method to copy and paste into Excel Worksheet, only get a popup saying it can't do it.
I used to use File///F: in my browser and then copy and paste into EXCEL. That doesn't work any longer.
Any suggestions?
I can't believe I am the only one needing this.
3 Replies
This is a Windows command prompt solution.
Open a command prompt and run these two lines:
dir /s F:\ >all.txt
Press enter after entering the above. Wait a minute or two (it may take some time to complete and show the blinking cursor) and then the next command:
all.txt
Press enter after entering the above and a notepad file will open. Copy/paste to Excel where you can run Text to Columns using space as a delimiter.
- Thanks, this worked to well. i got a lot more info than I needed, I said "files" and I should have said "folders" within drive. My intent was to create a worksheet with folders in each ext. HD to help me determine if I have already purchased a product. I create a new folder for each product I purchase. I have about 40Tb stored on HD's and am trying to organize the information.
- For just the folders, include another parameter on the DIR command:
DIR /S /A:D > all.txt
(The command and its parameters are not case sensitive.)
