I'm trying to work out how to create a CSV file which will allow me to find out the number of files in a directory and any sub-directories, but not as a grand total.
I need it to have the folder structure and then the number of files (not including any sub-folders)
C:\Level 1\ 10
C:\Level 1\Sub Level 1\ 0
C:\Level 1\Sub Level 1\next level 1\ 5
C:\Level 1\Sub Level 2\ 5
C:\Level 1\Sub Level 3\ 4
C:\Level 1\Sub Level 3\next level 1\ 12
I would like to open this in Excel so that the folder path is column A and the number of files at that level is column B.