Integrate Jira Cloud with MS Excel add-in

Summary

Jira Cloud can be integrated with Excel with an add-in in order to export your work for powerful reporting and analysis.

Solution

Adding the Add-in to Excel

To integrate Jira Cloud with MS Excel you will need the add-in available in the Microsoft Store.

• Jira Cloud for Excel

You can also add it directly in Excel:

1. Open a blank spreadsheet.

2. On the Home tab, click on Add-ins.

3. Search for Jira Cloud for Excel.

4. Add.

Integrating it with Jira

Once the add-in is added to Excel, you need to follow the below steps:

1. Click on Get started.

2. The Jira authorization tab will open on your browser with a space for six numbers under "Please enter the verification code ..."

3. In Excel, a six-number code will appear, so copy and paste it to the browser.

4. Once validated, the page will be loaded informing "Jira Cloud for Spreadsheets is requesting access to your Atlassian account."

5. Select the Jira Cloud URL where you want to connect to export your work and click on Accept.

6. You will see the following message: Login Successful - Signed in! You may close this tab.

Getting data from Jira

Once the connection is successful, you can import data from Jira to Excel by using a JQL or a saved filter (only Starred Filters are supported).