Forum Discussion
excel
I have a list of file names in a folder. How can I put that list into Excel, one name on a row?
(On Windows) With Get & Transform (aka Power Query):
- Data tab > Get Data > From File > From Folder
- Select the folder > Open (Power Query Editor opens)
- Transform Data (at the bottom of the window)
- Remove all columns BUT [Name]
- Close & Load