Get a list of files inside folder on your Mac
I have an add-in for this also but now Power Query is available on the Mac (not as good as in Windows) we can use Power Query on the Mac to get a list of file names, I show you how below to do this. If you want to check out the add-in, follow this link: FileName Lister Add-in for Excel for the Mac
Because there is no folder option in Power Query in Mac Excel we must create a AppleScript file with M code to get it working, I did all the work for you so the only thing you have to do is open the Script Editor and copy the script below in it and save it with filename you like, for example 'GetPath'.
When you open and Run the script you can browse to the folder you want and copy the M code with the correct script lines to the clipboard, then you can do a Command a and command v to replace the 4 lines in the Blank query. To open a Blank Query go to the Data tab in Excel and in the Get & Transform Data group click the button namedn : Get Data (Power Query) and choose Blank query. It will get the list of files and add a new column with the file size to the query, press Close & Load in the editor if you want to copy the result into Excel.
Because there is no folder option in Power Query in Mac Excel we must create a AppleScript file with M code to get it working, I did all the work for you so the only thing you have to do is open the Script Editor and copy the script below in it and save it with filename you like, for example 'GetPath'.
When you open and Run the script you can browse to the folder you want and copy the M code with the correct script lines to the clipboard, then you can do a Command a and command v to replace the 4 lines in the Blank query. To open a Blank Query go to the Data tab in Excel and in the Get & Transform Data group click the button namedn : Get Data (Power Query) and choose Blank query. It will get the list of files and add a new column with the file size to the query, press Close & Load in the editor if you want to copy the result into Excel.
Note: Use Folder.Contents if you not want to get the files in the subfolders.
My favorite way to run Script files
Tip : I like to add my script files(.app or .scpt) in the Script Editor menu in the top menu bar on your Mac. Open the Script Editor on your Mac and use Command , to open Settings and mark Show Script menu in menu bar and also mark Show Computer scripts.

If you have done it correct you see this menu item now on top of your Mac, to add script files to this menu choose 'Open Scripts Folder > Open Users Scripts Folder' to open the folder where you can copy the GetPath.app file in. This way you can always access your app files because you can always access the menu on top of your Mac.

Tip: You can also open a app file like this with VBA : Shell ("/Users/rondebruin/Library/Scripts/GetPath.app")
More info about Power Query on the Mac I will list on this page : Power Query in Mac Excel