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
------------------------