Question: how to put file names into excel?
Answer: 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.