9 Nov 2010

Export file and folder contents on your PC to Excel

The simple DOS commands can do wonders, which we have forgotten with time. I was looking for a solution to list down the contents of files and folders with multiple sub-folders.

Today i got a finer solution, but it depends on your requirement too. Using the old TREE command in DOS. Heres what you have to do
1) Open Command prompt
2) Go to the path on your PC whose contents need to be listed
3) Type TREE /a > (filename).csv
4) You can type TREE/? to see the various arguments
5) Open the CSV file in Excel

Disqus

comments powered by Disqus