How to link a Jira ticket ID in an excel to Jira

Question

Hi,

I have a set of Jira IDs downloaded from Jira and saved as an excel document. Is there a way to map those IDs in the excel to actual Jira ID and make columns in excel get automatically updated according to the Jira?

For an example : When the status of ID-1 changed to "Done" status from "In-progress" status, can I make it to automatically updated in the excel as well?

Cheers,

Hansi

Mirek · Accepted Answer

HI @Chethana Hashani

In JIRA OOTB this is not possible however there is a plugin (paid) that might help you with that

https://marketplace.atlassian.com/apps/37857/excel-connector-for-jira?hosting=server&tab=overview

I think does exactly what you want to achieve.