If you want to get all the files with a particular extension, just change the asterisk with that file extension. Want to Extract Files with a Specific Extension? Drag this down and it will give you a list of all the file names in the folder.
= IFERROR(INDEX(FileNameList, ROW()-2),"") Go to cell A3 (or any cell where you want the list of names to start) and enter the following formula: Now to get the list of files, we will use the named range within an INDEX function.
If you are not sure how to get the folder address, use the following method:.For example, if your folder in the C drive, then the address would look like.In cell A1, enter the folder complete address followed by an asterisk sign (*).Here are the steps that will give you the file names from this folder: Now, suppose you have a folder with the name – ‘ Test Folder‘ on the desktop, and you want to get a list of file names for all the files in this folder. While this formula does not work in the worksheet cells, it still works in named ranges. We will use this fact to get the list of file names from a specified folder. It is from the childhood days of Excel spreadsheets (a version 4 formula). Here is a way to get names of files from folders and sub-folders using Power Query Using FILES Function to Get a List of File Names from a Folder You will not get the names of the files in the sub-folders within the main folder. Limitations of the methods shown in this tutorial: With the techniques shown below, you will only be able to get the names of the files within the main folder.