Or just bring up a command prompt for the folder - use the DIR command to generate file list and manual copy it into excel (which should parse the columns).
I guess I am showing my age as I started in PCs with Dos 1.1 and always go to DOS for a solution first...
There is a DOS command that will write the directory to a text file.
dir /b > directory.txt
this saves the cutting and pasting
This article
Print a list of directory contents in Windows 2000 with DOS gives you more info and the switches you can use to alter the output.
Have fun