Click here to download the Power Query add-in.Note that Power Query and Get & Transform refer to the same thing.įor Excel 2010/2013, you need to install the Power Query add-in to use it (steps described below). ![]() You will find all the Power Query options in the Get & Transform category in the Data tab. If you’re using Excel 2016, you don’t need to do anything extra. However, the limitation of that method is that it can only get the file names from a folder, and not from the sub-folders within the main folder.īut you can do this using Power Query (‘Get & Transform’ if you’re using Excel 2016 or later versions). In that tutorial, I showed various ways to get the list of file names from a folder (using the FILE function and VBA). ![]() Some time ago I wrote an Excel Tutorial about getting a list of file names from a folder in Excel. ![]() Watch Video – Get a List of File Names from Folders & Sub-folders
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |