How do I get a list of files in a folder in Excel?

Question

This is an easy way to list all the files in a given folder and no VBA is needed. Select cell A1. Go to Formula tab in the ribbon. Select Define Name from the Defined Names section. Type in List_Of_Names in the Name area. Type in =FILES(Sheet1!$ A$1) in the Refers to area. Press the OK button.

How do I get a list of files in a folder into Excel?

Get the List of File Names from a Folder in Excel (with and without VBA)1Select the file and copy its name.2Paste that name in a cell in Excel and hit Enter.3Move to the next file and repeat step 1 & 2.

How do you get a list of all files in a folder and subfolders into Excel Windows 10?

Get a List of File Names from Folders & Sub-folders1Go to the Data tab.2In the Get & Transform group, click on New Query.3Hover the cursor on the 'From File' option and click on 'From Folder'.4In the Folder dialog box, enter the folder path, or use the browse button to locate it.5Click OK.

Is there a way to get a list of files in a folder?

Press and hold the SHIFT key and then right-click the folder that contains the files you need listed. Click Open command window here on the new menu. A new window with white text on a black background should appear. o To the left of the blinking cursor you will see the folder path you selected in the previous step.

Expert · Answer