Let’s see how we can quickly list all files in folder and subfolders using Power Query. It took only 30 seconds – less than 10 clicks away!

Remark:
Power Query is readily available with Excel 365, Excel 2016, Excel 2019.
For Excel 2010/2013, you can install the Power Query add-in for free following the instructions provided in the following video: https://www.youtube.com/watch?v=gwW2CDdvUUs