The way to do this is to use this windows script to create a text file of all folders and filenames.
Then import the file into Excel.
Change the destination path/filename for the output of the script as appropriate.
I cannot remember where the script came from - I did not write it, so my apologies for not crediting the author.
The script is a file named 'DirectoryListing.vbs'
Create it using notepad or similar
Set oFSO = CreateObject("Scripting.FileSystemObject")
strPath = InputBox("Enter Folder Path: ")
Set fOut = oFSO.CreateTextFile("c:\temp\Report_file.txt", True)
Set oDir = oFSO.GetFolder(sDir)
For Each i In oDir.Files
For Each i In oDir.SubFolders
When you run this script it asks for a Folder Path, so enter a path to the root of the folders you wish to get the names from.
Once you have the names in Excel, if you only want folders, use Auto filter for cells containing '\'