Home » Howto & Style » How to Get a List of all Files in a Folder and Subfolders into Excel

How to Get a List of all Files in a Folder and Subfolders into Excel

Written By Chester Tugwell on Thursday, Jan 21, 2021 | 11:00 AM

 
👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺. https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ Thank you! 👍👍 In this video I demonstrate how to easily create a list of all the files in a folder including all files in its subfolders. I use Power Query to create this list. If you are using Excel 2010 or 2013 you will need to download and install the Power Query add-in from Microsoft's website https://www.microsoft.com/en-gb/download/details.aspx?id=39379 ------------------------