How to list all file names from a folder and sub-folders into a works…
https://www.extendoffice.com/documents/excel/627-excel-list-files.html
How to List Folders in Excel Go to copy the path of the folder ( Folder test) in Explorer. For example, the path of this folder is: C:\Users\DT168\Desktop\Folder test. Open one of the web browsers (FireFox, Opera and Google Chrome) and paste the folder path in the address bar and press Enter key. Click Ctrl+A to select all contents in the web browser and press Ctrl+C to copy them.
Go to copy the path of the folder ( Folder test) in Explorer. For example, the path of this folder is: C:\Users\DT168\Desktop\Folder test.
Open one of the web browsers (FireFox, Opera and Google Chrome) and paste the folder path in the address bar and press Enter key.
Click Ctrl+A to select all contents in the web browser and press Ctrl+C to copy them.
DA: 44 PA: 83 MOZ Rank: 54