Connection between Jira and Excel

Question

Hi Team,

I have a big excel list for resource planning and I need a direct connection to Grip Jira to have the updated data without manually steps.

As of now I´m exporting the data via csv to excel and update then the data in xls with my export.

And to avoid this manual step, I would be great, if I can use any automatic interface to get the data form Jira in my xls sheet

My goal is, that I have a direct connection between Jira and Excel, that my tickets updates automatically in excel

Can someone help on how we can achieve this?

Thank you!

Trudy P Claspill · Answer

Did you try using the search options in the Atlassian Marketplace to find what you need?

Click on the Atlassian Marketplace graphic in the upper left corner to go to the home page. Then enter your search criteria.

Lucas Modzelewski _Lumo_ · Answer

Hi @Kanaka Ponnuru Prasad ,

I'm from the team behind the app Excel 365 Connector for Jira which allows a 2-way communication Jira <=> Excel

You can import Jira data to Excel (with use of favourite filters or just by typing JQL), then you can make changes/updates and export it back to Jira. Our app also allows to create new issues straight from the Excel.

It works in multiple sheets, so you can have different data in each sheet

Aron Gombas _Midori_ · Answer

Use Better Excel Exporter with a custom template to get the exact XLSX output you look for.

And, even make the process automatic by introducing Better Excel Automation.

(Discl. both apps are developed by our team.)