Exporting Jira to Microsoft Project: Step-by-Step Guide for Project Managers

Are you using Jira and Microsoft Project simultaneously to cater to both agile and non-agile teams?

While utilizing these tools helps you to collaborate with stakeholders easily, it is awfully time-consuming to manage both, not to mention expensive.

Fortunately, there are third-party apps like WBS Gantt-Chart that simplify exporting issues from Jira to Microsoft Project.

Continue reading to learn how to export Jira issues to Microsoft Project in just three simple steps.


Data Export from Jira to Microsoft Project: The Need and Challenges

Like many PMs, you may want to export Jira issues (software bugs or tasks) to Microsoft Project to coordinate work across different teams and report progress to stakeholders. Or, you may simply prefer managing projects using a Gantt chart in Microsoft Project.

Whatever your reason for exporting data from Jira to Microsoft Project, you need an efficient tool that prevents data loss and other headaches.

Unfortunately, the native export function in Jira comes with its own set of challenges such as unsupported Microsoft Project format and 1000-issue limit on filtered results.

Understanding these challenges, we designed a quick and easy solution to export data from Jira to Microsoft Project: Ricksoft’s WBS Gantt-Chart app.

It is powerful enough to export projects, versions, and issues displayed in WBS Gantt-Chart into formats that are supported by Microsoft Project. Plus, it gives you a familiar Microsoft Project-like interface for visualizing Jira projects in a Gantt chart, which may save you from having to export data altogether. 


WBS Gantt-Chart App Allows Two Types of Data Export

Before you can export data from Jira to Microsoft Project, you’ll need to understand the types of data export available in WBS Gantt-Chart.

There are two formats: Excel export and Microsoft Project export.

With Excel export, the data from WBS Gantt-Chart is converted into a .xlsx file. You can then import this Excel file into Microsoft Project via the Project Import Wizard. The wizard will automatically map the data into appropriate Project fields.

Excel export allows you to extract the work-breakdown structure and Gantt chart from the app so that they can be printed and handed out.

As the name suggests, MS Project export converts the data from WBS Gantt-Chart into a .mpp file that is native to Microsoft Project software. You can then access and edit this file using Microsoft Project.

3-Step Data Export from Jira to Microsoft Project

Now that you understand the types of export available, you can start exporting data from Jira to Microsoft Project using only three simple steps:

Step 1: Log into your Jira account. From the WBS Gantt-Chart dropdown menu, select the project that you wish to export. If you’re using the cloud version, your Gantt charts are listed on the Gantt-Chart menu.

Step 2: Click Data in the dropdown menu and select the type of export that you prefer.

Step 3: A download dialog box will appear. Choose the download location to export and download your Jira data.

You can then continue working on your project.

The only restriction with Excel export is that having more than nine hierarchies will cause a system error, and you will not be able to open the file.

Hence, always make sure that the number of hierarchies in your project is within the limit.

Besides that, the latest version of WBS Gantt-Chart app does not allow you to export data into Excel (legacy) format – the one with macros embedded.

This is to ensure that MacOS users can also open the file without errors; while displaying the content in all available languages.

RelatedHow to Start Project Planning in Jira

What’s Next After Exporting Data from Jira to Microsoft Project?

Exporting data from Jira to Microsoft Project is only a part of your workflow. You may also need to import data from Microsoft Project to Jira. And yes, this app can cover that too!  

No matter the process, we advise our new clients to read the general user guide to get the most out of WBS Gantt-Chart app. If reading is not your cup of tea, watch this tutorial video instead.

However, the continuous export and import of data between Microsoft Project and Jira is a hassle. Why not use our app to migrate completely to Jira instead?

If you’re worried about the unfamiliar UI of Jira, fret not as our app is built on the trademark Gantt chart of Microsoft Project.

The Work Breakdown Structure (WBS) will help you to allocate resources and identify relationships between tasks. Its smart workload allocation will also highlight potential issues. This way, you can rest assured that project deliverables are accomplished within the set timeline.

Our Gantt chart tool provides instant visualization of your project plans. To further automate your project planning, the app is designed with an intuitive drag-and-drop interface. Simply drag, shorten, or stretch the taskbar on the Gantt chart to modify your project scheduling.

Don’t just stop at exporting data from Jira to Microsoft Project. Check out the sandbox version of our app. Explore its many uses to fully embrace Jira for project management without sacrificing the features from Microsoft Project that you know and love.

Share this article