You're probably going to need to get familiar with some programming. In ASP, you can use FileSystemObject to loop through the files in a specified directory, store the names in an array, and output the results as a CSV (which is essentially an Excel doc.
If I understand what you're trying to do correctly, You can use the dos command "dir".
From the command line, change to the directory that you want to get the files for. Then type the following command:
dir /A-D /B >> C:\files.csv
The "/A-D" will exclude any directories that exist in that folder. The "/B" will output the data as a bare format, meaning file names only. The ">> C:\files.csv" will pipe the output of that data to a new file.
You can open the csv in excel.
If you want to do all the files in all the subdirectories you can throw a /S in the arguments, it will display the full paths of the files as well.
Another really cool command I forgot about in dos is "tree" command. It just looks cool but doesn't have anything to do with your question. :)