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

Question

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!

Iida Salminen · Answer

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

Alexey Matveev · Answer

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 · Answer

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!