15 - Get a List of File Names from a Folder in Excel Using Power Query скачать в хорошем качестве

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://trumpexcel.com/course-downloa... ☕ 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... ------------------------------------------------------------------------------ 00:00 - Introduction 00:14 - Opening a folder and accessing Power Query 00:55 - Preview pane and opening Query Editor 01:41 - Understanding the content column (Binary files) 02:29 - Selecting and filtering columns 03:39 - Working with subfolders 05:02 - Filtering by file extension 06:39 - Refreshing data when new files are added ------------------------------------------------------------------------------ #Excel #PowerQuery #ExcelTips