Users will need the Data export Permission enabled in order to export spreadsheets of Project folders.
Within a folder, select the Options button and choose Export:
You will now have the option to Export a Microsoft Excel Spreadsheet or CSV of all the files, and their associated information, that are displayed on the folder you selected Export from: