You can export project team allocation and cost data to a Microsoft Excel *.xls file. All spreadsheets rows and the entire visible timescale are exported.
Tip: The timescale heading is converted to Month, Day, Year format and displayed in a single column.
Exporting resource allocation and cost data to an Excel spreadsheet file
- Open the project or group of projects you want to work with in the Projects section.
- Click
on the Projects toolbar to display the Team Usage page.
- If multiple projects are open, select the project you want to work with from the Select Project list.
Note: If a single project is open, the Select Project list does not appear. When multiple projects are open, the Select Project box lists all open projects you have rights to access. Any action you perform, and all data that appears on the page, applies to the selected project only.
- Choose the Spreadsheet option in the right pane.
- From the hierarchy Organized By drop-down list in the left pane, choose to view resources or roles, and select the resource or role for which you want to export data. Or, to export project level totals, with a breakdown by role or resource, select the project in the hierarchy.
- To select Units or Costs and a timescale option, click Customize. Choose the options you want, and then click Save.
- Click Export to file.
- Choose to open or save the export file.
If you choose to view the .xls file, Microsoft® Excel launches and opens
the file.
If you choose to save the .xls file, accept or revise the default export file name and click Save.