JIRA data to Excel for burn down chart

[Murali K R]

Hello Community,

I am working as defect manager in the project and regularly check for problem tickets in JIRA.

in my project i have more than 500 problem tickets and want to have a burn down chart in MS Excel, and excel must fetch data from JIRA and update online ( instead of manual update)

i tried an option in excel to connect JIRA ( through Data-->From Web option), but not successful..

could you pls help , how to have JIRA data in excel for burndown chart ... This will help me to automate my tasks and live visualization of JIRA tickets in MS Excel  

[Akash Singh]

@Murali K R Welcome to Atlassian Community!

You’re on the right track! Below are the steps to set up a live Excel dashboard that automatically fetches Jira issue data — ideal for creating a burndown chart.

---

Prerequisites

Before starting, make sure you have:

1. A Jira API Token — You can create one by navigating to:
   Manage Account > Security > Create and Manage API Tokens.
   Refer to the official guide here:
   Manage API tokens for your Atlassian account

2. The JQL Query — This defines the issues you want to fetch. For example, to get all issues in project "OS", the JQL would be: `project = OS`
   

---

 Step-by-Step Process

1. Open a new Excel file.

2. Go to the Data tab and select From Web.
   

3. In the URL field, paste a Jira REST API URL like this (replace with your site and project details):

   https://<yoursitename>.atlassian.net/rest/api/3/search/jql?jql=project=OS

4. Excel will prompt you to choose an authentication method — select Basic Authentication.

5. Use:

   • Username: Your Jira account email.
   • Password: Your API Token (from step 1).
     

6. Click Save — Excel will fetch the data from Jira.

Once the data loads, you can transform it into a table and shape it to fit your burndown chart requirements using Excel’s Power Query features.

---

By default, Jira’s API returns only the issue ID and key. To include more fields (like summary, priority, status, etc.), modify the URL like this:

https://<yoursitename>.atlassian.net/rest/api/3/search/jql?jql=project=OS&fields=summary,priority,status,created,resolutiondate

Full API documentation can be found here:
Jira Cloud REST API - Issue Search

Once your data is in Excel, use Pivot Tables or Charts to visualize open vs resolved issues over time for your burndown.

[Murali K R]

@Akash Singh thanks for your response... I will try as you suggested..

---

[Danut M _StonikByte_]

Hi @Murali K R,

Welcome to the Atlassian Community.

Would it be okay to display the burndown chart directly in Jira, in real time?

If so, I would recommend looking at the Release Burndown Burnup Chart gadget offered by our Great Gadgets app.

Danut.

[Murali K R]

@Danut M _StonikByte_ JIRA also fine.. But want to make planned and actual burndown chart on weekly basis.. I thought, exporting to excel and preparing chart would be a good idea.. 

I explored some chart in JIRA but could not find it... If you know, pls suggest.. 

Thanks

[Danut M _StonikByte_]

Hi @Murali K R,

Unfortunately Jira does not provide such gadget...

By using the Release Burndown Burnup Chart gadget offered by our Great Gadgets app you can generate the chart you need with just a few clicks.

All you have to do is to configure it to use a filter/JQL that returns the bugs, set the timeframe, use intervals of 1 weeks and calculate by issue count. The gadget is capable to make a prediction of the ETA (when all the bugs are fixed, based on your weekly velocity)

See also this article: https://community.atlassian.com/forums/App-Central-articles/Creating-a-cross-teams-release-burndown-chart-in-Jira-with-Great/ba-p/1803421

If you need any assistance, please contact support@stonikbyte.com. 

Danut.

[Murali K R]

@Vishal Biyani Yes... i use JIRA cloud..I did not use " Get JIRA data".. How do i install it and how to use ?

I tried below steps in JIRA:

1. Created the filter in JIRA for problem tickets based on assignee 

2. Used Export option..... CSV ( Current Fields ) --> Right Click --> Copy the link address

3. Then in Excel :  Data --> From web -->   Used this address in Excel in "Advanced" option

     Then i tried to connect 

[Vishal Biyani]

@Murali K R 

Are you on JIRA Cloud? Are you able to uses a plugin like "Get JIRA data" to download the data from JIRA into excel based on the JQL given?

[Vishal Biyani]

Check this link out

Jira Cloud for Excel (official) | Atlassian Marketplace

This is a free plug-in by Atlassian. It simplifies getting data from JIRA in excel.