Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,373
Community Members
 
Community Events
165
Community Groups

Live excel of Jira data

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

2 answers

Hi @Kaj Sennelöv ,

you should use REST API provided by Atlassian JIRA in order to download data on your excel file and then perform all the calculation you want.

I did it for a customer using https://www.codeproject.com/Articles/1088523/Excel-Jira-Rest-API-end-to-end-example

Hope this helps,

Fabio

Hi @Fabio Racobaldo _Herzum_ 

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

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

Hi @Hannes Obweger - Fine Software - JXL

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,098 views 34 44
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you