You can export the workload as an Excel file from the Workload tab 1 for a particular project and its resources or from the Workload section 2 on the left sidebar for all the projects and resources in your account.
It is possible to configure which information from the Gantt chart software the exported table will include. In particular, you can set up:
Select whether the workload is displayed in tasks, hours, or percent.
Select specific dates or date ranges you need to see the workload on.
Use standard Filters to export particular pieces of information.
Use Zoom to select the time scale of the exported workload.
Once you are done, click on the Export icon 7 in the top right corner.