Get List of File Names from a Folder and Sub-Folders using Power Query in Excel

This video is about how to get a list of file names from a folder and subfolders using Power Query in Excel.

In the video, Kailash Sharma demonstrates how to achieve this by following these steps:

Create a new Excel file and go to the data tab.
Click on "Get data from file" and then "From folder"
Select the folder that contains the files you want to list.
Click on "Transform data" to load the data into the query editor.
Remove the "Content" column from the query editor as it is not needed.
Add a new custom column named "Size" to show the size of each file.
Click on "Close and load" to bring the results back to Excel.
(Optional) If you only want to list Excel files, you can use the text filter option in the query editor to filter for files that contain the ".XLS" extension.
By following these steps, you can easily get a list of file names from a folder and subfolders using Power Query in Excel.

Chapters:
00:00 Introduction
00:11 Explanation of Scenario
01:09 Create Basic Query
02:12 Customizing the Query
02:53 Review Result
03:04 Testing the Query
03:20 Conclusion