15 - Get a List of File Names from a Folder in Excel Using Power Query

Рет қаралды 32,292

4 жыл бұрын

You can use Power Query to get a list of file names in Excel from folders and subfolders.
If you're using Excel 2016, you already have Power Query options in the Data tab (under the Get & Transform group).
If you're using Excel 2010 or 2013, you will need to download, install and activate Power Query.
Note that Power Query and Get & Transform refer to the same thing.
For Excel 2010/2013, you need to install the Power Query add-in to use it (steps described below).
-- Click here to download the Power Query add-in. Make sure you are downloading 32-bit if your Excel is 32-bit and 64 bit if your Excel is 64 bit.
-- Install the Power Query add-in.
-- Open Excel. If you see a Power Query tab, skip the remaining steps. If not, move to the next step.
-- Go to File and click on Options.
-- In the ‘Excel Options’ dialog box, click on Add-in in the left pane.
-- From the Manage drop-down, select COM Add-ins, and click on Go.
-- In the list of available add-ins, select Power Query and click OK.
-- Close the Excel Application and restart Excel.
The above steps would install and activate the Power Query for your Excel.
In this video, I will show you the exact steps to get the list of file names from folders and subfolders.
I will also show you how to edit the data in Power Query Editor to add more meta columns to the file name data.
Read more about this here: trumpexcel.com/list-file-name...
Related Video Tutorial: www.youtube.com/watch?v=OSCPV...
✅ Power Query Course Download files: bit.ly/power-query-download
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #PowerQuery #ExcelTips

Пікірлер: 9

@khalidmajeed2886 Жыл бұрын

Mashallah sir, y are doing great ......sub saay acceh baat ye haaay kaay aap short video maay bata rahay haay......bohat accah explain ker raahay haay.....

@somojitdutta1202 5 ай бұрын

Amazing Content. The folder name could also be pasted via copy folder path option in file explorer. Once the folder path is pasted in Excel, we can use the text to column option to get the File Name.

@AgapeoNtsinzi Жыл бұрын

thank you so muuuch, God bless you

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks so much.

@yashshah9000 Жыл бұрын

Amazing stuff. Can we also get size description of file with power query?

@mohanadeepa1522 4 жыл бұрын

Hello Sir. Pls guide me how to remove selected multiple rows in power query.

@clarencedsouza2006 2 жыл бұрын

Hello Sumit. Great video! Thank you so much for your detailed video on how to use Power Query to get file names from folders and sub-folders. However, I am not able to get more than 100 entries and the last row in the sheet comes as "...". Could you please help me resolve this I have more than 50K entries which show as loaded but I can't see them beyond the 1st 100 entries.

@ntsikelelomaqubela2754 3 жыл бұрын

I am trying to combine the files within a folder, however I want to create an additional column in the output with the file name of the source file in there. In other words, keep the contents within the files in the binary column, yet have an additional column where the name is taken from that file name in the output combined file.