nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

All comments

Vishal Biyani_2pr07j

@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?

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_2pr07j

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.

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)

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

Danut.

Akash Singh_vujl0e

@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:

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

Open a new Excel file.
Go to the Data tab and select From Web.
In the URL field, paste a Jira REST API URL like this (replace with your site and project details):
```
<span>https://<yoursitename>.atlassian.net/rest/api/3/search/jql?jql=project=OS</span>
```
Excel will prompt you to choose an authentication method — select Basic Authentication.
Use:
- Username: Your Jira account email.
- Password: Your API Token (from step 1).
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..

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

ms-excel

unknown-hosting-type

jira-unknown-hosting-type