We have 2 options for exporting CSV Project files.
A. Workspace Setting
Go to the name of your workspace, and click the dropdown arrow.
Choose Manage Settings, and under the Settings Tab, click Workspace Projects.
Click Export to CSV.
B. In the Project Settings.
Click on the gear icon in the top right corner to open the project settings.
Scroll down and click on "Export to CSV".
The downloaded CSV file can be opened in most spreadsheet programs such as Excel 365 for Windows users, Numbers for MAC or Google sheets on any platform. The file includes all task properties including completion date, subtasks and custom fields.
How to import your CSV to Google Sheets
Please note: Excel 2016 and previous versions are not supported