dspTrack
Export a Project as an Excel File in MS Project
-
In MS Project, select File > Save As and select Excel spreadsheet.
NOTE: The export wizard displays.
- Click Next.
- Click Selected Data and click Next.
- Select New map and click Next.
-
Ensure that Tasks, Resources, Assignments and Export includes headers check boxes are enabled.
NOTE: The Include assignment rows in output check box should be disabled.
- Click Next.
- Enter Task_Table in the Destination worksheet name field.
-
Click Insert Row to add a row for each field that should be mapped.
NOTE: All fields are required.
Microsoft Project Field
Excel Field
ID
ID
Active
Active
Task Mode
Task_Mode
Name
Name
Duration
Duration
Start
Start_Date
Finish
Finish_Date
Predecessors
Predecessors
Summary
Summary
Critical
Critical
Milestone
Milestone
Notes
Notes
Actual Start
Actual_Start
Actual Finish
Actual_Finish
- Click Add All.
- Click Next.
- Enter Resource_Table in the Destination worksheet name field.
-
Click Insert Row to add a row for each field that should be mapped.
NOTE: All rows are required.
Microsoft Project Field
Excel Field
ID
ID
Name
Name
- Click Add All.
- Click Next.
- Enter Assignment_Table in the Destination worksheet name field.
-
Click Insert Row to add a row for each field that should be mapped.
NOTE: All rows are required.
Microsoft Project Field
Excel Field
Task ID
Task_ID
Resource ID
Resource_ID
- Click Add All.
- Click Next.
- On the Congratulations screen, click Save Map, and save the map for further use.
- Click Finish to save the spreadsheet.