Export Project Data to Excel
Perform the following steps to export project data from all grid-based tabs in the main Project Analyzer window as well as detailed staffing data to an Excel spreadsheet.
To export the data grid contents to Excel:
- Click the Home tab in the Project Analyzer ribbon bar.
- In the
Organize section of the Home tab, shown below, click the
Export Project to Excel button.
Note: If the Project Analyzer has been resized (not maximized), you may only see the icon in place of the text. - In the Save contents of the grid as... dialog box, enter a name for the file and select the location where you want to save the file.
- Click Save. The file is saved as an .xlsx file in the selected location.
The spreadsheet file contains a separate tab for each Project Analyzer tab. The spreadsheet also includes a separate detailed staffing tab for each phase of the project that contains the detailed staffing information for that phase.