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

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: https://trumpexcel.com/list-file-name...

Related Video Tutorial: https://www.youtube.com/watch?v=OSCPV...

✅ Power Query Course Download files: https://bit.ly/power-query-download

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

#Excel #PowerQuery #ExcelTips