Live excel of Jira data

Question

Hi community!

I have an excel that does a few calculations etc on Jira data from two projects.
Currently, I am manually importing the Jira data with the Jira cloud for excel addon.

In an ideal scenario, this excel is updated automatically every X minutes. Is there a way to automate this through Jira, excel, or Ms power?

Looking forward to your thoughts!

Greetings,

-Kaj

Kaj Sennelöv · Answer

Hi @Hannes Obweger - JXL for Jira

We are using the excel for a Gecko board which will also use other integrations.
Hence we are tied to that excel.

Thanks for the tip though,

-Kaj

Kaj Sennelöv · Answer

Hi @Fabio Racobaldo _Catworkx_

Thank you for the tip!
This is a little above my current knowledge, but I like the challenge. ;)

Will give it a try one of these days.

Thanks again!
-Kaj

Hannes Obweger - JXL for Jira · Answer

Hi @Kaj Sennelöv

for a completely different path: May I ask which kind of calculations you are performing in Excel?

I'm asking because there's a number of apps in the Marketplace - our own app, JXL for Jira, being one of them - that bring many spreadsheet capabilities directly to Jira. This means that you always operate on "live" Jira data, and don't even have to worry about an export, let alone keeping this export up to date.

I'm happy to elaborate more if you're interested, but whether it makes sense or not really depends on your use case.

Best,

H