How could I connect JIRA to Excel and update JIRA user stories in excel automatic?

[Iida Salminen]

We have an version v6.4.14 and I should create the connection from excel to Jira and update JIRA User stories in excel automatically. For eg. We have user story details in excel : id, status, title, description ... These should be uploaded from JIRA automatically but I don't know how to do it. Is there any tool or any suggestions how I could create the connection to excel and update certain fields in excel  directly from JIRA? 

Super thanks for helping and advices!

[Alexey Matveev]

Hello,

Jira has rich REST API. You can use it from Excel VBA. 

You can find here, how to make a REST call from Excel:

https://social.msdn.microsoft.com/Forums/office/en-US/3f8d06eb-4e90-4631-99e6-d6c691aa327e/calling-web-service-from-excel?forum=exceldev

You can find Jira rest api here:

https://docs.atlassian.com/software/jira/docs/api/REST/7.11.2/?_ga=2.247677703.1285141952.1534141867-1659643416.1506407535

[Iida Salminen]

Hi!

Thank you very much! I appreaciate your help! :) 

I tried to ask if I could use that but I was adviced to not use any plug in or extra apps to do it.  I'm not allowed to install one. Sorry.. But about my task,  I should get Jira tickets and description and all details of tickets(description, summary ect..) to excel automatically and update these fields to another excel. But if it's not possible, do you have any suggestions how to export these details to excel and then update these fields to another excel file? I have tried to find solution for this, if I then export first manually and try how it works and then think about the options how it would be possible to do it automatically..Would it need some VBA script or? 

Thank you very much! 

[Alexey Matveev]

Jira Rest Api is an in-built feature of Jira. It is not a plug. You can use it for free. If you want to download all details of tickets to excel, then you could use the Jira's export functionality to download issues to the csv format file. Excel can read this file later:

https://confluence.atlassian.com/jiracoreserver072/working-with-search-results-829092736.html

Then you would need a macro to convert download file to the format you need. 

[Iida Salminen]

Allright, sounds good!  Thank you so much! :)