The traditional way to list files on Windows is using the dir command. It has a lot of options to use. But the main problem with this is the output. You can redirect the output to a file, but it has a format that is intended only to be viewed and it´s difficult to put the output in a csv or tab format.
If you need to make a list (excel type) the best way to do this is using a script or an app.
Here is a very useful app that can manage a lot of options to get the desired output:
Karen's Directory Printer
http://www.karenware.com/powertools/ptdirprn.asp#Download
The best way to list files into Excel is: Directory Report
ResponderBorrarhttp://www.file-utilities.com
It can save its output to a .csv file (which can be opened by Excel)
or
It can save directly into Excel