Site icon QuickQuick

How to list files in folder & subfolders with Excel – no formula needed!

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!

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:

Exit mobile version