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

[Chethana Hashani]

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 solution]

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.

[Chethana Hashani]

Hi Mirek,

Thanks a lot for the support. I will try it :)

Cheers,

Hansi