Create a File Index in Microsoft Excel and Power Query Tutorial

In this video you will see a step by step tutorial of how to create a File Index in Microsoft Excel using Power Query. This is a great and versatile tool which will allow you to update the index with new files at the click of a button

[povig]

Very helpful video. I've used it multiple times to reference back to. Greatly appreciated.

[brucelee]

Thank you fo much for the video! this is very helpful. Do you know if it'd work if i zip the folder and send it to a another computer? the filepath would change. do i need to instruct the other user to reconnect the datasource?

[szilviamelich]

Very useful however is there a way to have the index show other attributes of files? For example: length of a video? The data is shown in the detailed view of the windows folder but when I fetch the list, length doesn't show.

[wwbehrouz]

Thank you very much for the great video. Would it be possible to turn this Excel file into a template so that when we copy and past it in a new folder and click refresh, it populates the data automatically for the new folder?

[himanshuchapsey]

Very very helpful. How do I however, create a tiered structure and not a list. Tiered for folder name, below it sub folder, below it sub sub folder and so on till the end of it with file names

[YW-sdrv]

Hi Ed, i am getting Some Value Errors? How to address those.