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...
Related Video Tutorial: • How to Get the List of...
Free Excel Course - trumpexcel.com...
Paid Online Training - trumpexcel.com...
Best Excel Books: trumpexcel.com...
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: www.youtube.co...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Негізгі бет Get a List of File Names from Folders & Sub-folders in Excel (using Power Query)
No video
Пікірлер: 60