MS Excel — Effortlessly Create Dynamic Folder Lists with #PowerQuery
#TwinzTechTip #TwinzTalk
Published in
2 min readMar 24, 2019
Microsoft has never made it easy to create a list of files contained in folders on your PC. Why?
Add-in’s can do it.
Finally, it is easy…using Power Query!
Open a blank Excel workbook and follow these steps (this assumes Office 2016. If not, the Power Query add-in needs to be installed):
1️⃣ Select “Data >> Get Data >> From File >> From Folder”.
2️⃣ Browse to the folder you want a list of (in this case, the Downloads folder). Click OK.
3️⃣ Click “Transform Data” and make a couple of data modifications (see below).
4️⃣ Next, “Load” the data as a Table into Excel. 💥 BOOM — you have your list!
Coming soon…modifying your folder list to make it truly usable!
How do you get a list of folder contents?