Exporting to Microsoft Project

Exporting to Microsoft Project

You can export projects, versions and issues displayed in WBS Gantt-Chart as XML files that are readable in Microsoft Project by clicking Data ⇒ MS Project export on the operations bar.

The Microsoft Project field for each Jira field is shown in the table below.

Jira field

Microsoft Project field

Notes

Jira field

Microsoft Project field

Notes

Summary

Task name



Assignee 

Resource name

  • Makes the assignee's username and workload as the output.

  • If the workload is 0, Microsoft Project specifies the duration of the task as 0 days as a default. Therefore tasks with no milestones and 0% workload are exported with a 1% workload.

  • If square brackets are used for the full name of the assignee, convert to parentheses. In Microsoft Project, you cannot use square brackets for resource names.

Workload

Start date

Start date

Uses the value of the field configured as "Start date in WBS Gantt-Chart for Jira

Finish date

Finish date

Uses the value of the field configured as "Finish date" in WBS Gantt-Chart for Jira

Baseline start date

Standard start date

Uses the value of the field configured as "Baseline start date" in WBS Gantt-Chart for Jira

Baseline finish date

Standard finish date 

Uses the value of the field configured as "Baseline finish date" in WBS Gantt-Chart for Jira

% done 

% complete

Uses the value of the field configured as "% done" in WBS Gantt-Chart for Jira

However, in Microsoft Project, the % completion rate of a summary task is automatically calculated including accumulated  % completion of child tasks as well. Therefore the value shown may differ from % done in WBS Gantt-Chart for Jira.

Due date

Deadline