|Are they all subdirectories of another folder? If so then open the closest root of the directory in Windows Explorer.|
For example; let's say they are all in My Documents and the path is:
C:\Documents and Settings\Mint\My Documents
Then go to Start, Run, cmd and it will open to the above directory.
At the command prompt type:
dir /ad >list.txt
This will create a text file named "list" of all items in the directory that has the "Directory" attribute. You will find the .txt file in the same folder.
You can then open Excel and go to File, Open. Change to All file types and browse to the same folder to find it.
Hopefully you have opened a text file in Excel before. Otherwise just follow the prompts to get it open in Excel and then delete columns as needed.
Do save it as an Excel worksheet though versus a .txt file when prompted.