How to Get the List of File Names in a Folder in Excel (without VBA)

Channel Avatar
Comment
X
Share
How to Get the List of File Names in a Folder in Excel (without VBA)
How to Get the List of File Names in a Folder in Excel (without VBA)
In this video, I will show you how to get a list of file names from folders into Excel (without the use of any VBA or coding).

You can use this technique to fetch all the file names from a folder and list that in Excel.

This Excel trick uses an old Excel Function – FILES.

FILES function can be used to get the list of all the file names (or specific file names) in a specific folder in Excel. It an old excel function that does not work in the worksheet, but still works in named ranges in Excel.

All you need is this formula with the folder address.

To get the folder address, save the excel file in the same folder and use this formula – SUBSTITUTE(CELL(/”filename/”),RIGHT(CELL(/”filename/”),LEN(CELL(/”filename/”))-FIND(/”@/

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Keywords: get list of file names in excel, get list of file names in folder, File Names in a Folder in Excel, Excel File Name, extract file names in excel, generate list of files from any folder in excel, copy files names from folder, copy file/folder name to excel, Excel File list, Excel Folder, File Names, File Names in a Folder, Filename (File Format), get a list of filenames from windows, Excel, Excel Tip, Excel Advanced, copy file name to excel, trump excel, Microsoft Excel

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *