JIRA Dashbaord Export

I want to export my dashboard to excel. I performed the following steps but not able to export the data in Excel:

1. Right clicked on Dashboard; selected Export to Microsoft Excel.

2. Web Query box appeared, saved the query.

3. Now whrn I am trying to open the Microsoft Office Excel Web Query File in Excel it says caanot download the data.

Can anyone help me with this or provide me any other solution to export Dashboard to Excel.

Thanks in advane.

4 answers

Although your question is quite confusing, these may smile be answers for you:

#1

You can export a dashboard to PDF as written in this tutorial. Note: this is about exporting dashboards (also including chart-type gadgets), not about exporting the issues from Issue Navigator.

It looks like this:

jira-dashboard-pdf.png

#2

First, Excel may not be the best format to export JIRA dashboards to, as the charts in JIRA are rasterized images (or SVG), not the same representation used by Excel.

If you want to re-produce the charts in Excel, use the Better Excel Plugin. It allows to export JIRA issues, and create any chart from the named range that encompasses the issue list! See this tutorial.

It is actually super-powerful and looks like this:

excel-chart-result.png

 

 

0 votes

I don't understand this. There is no "export to excel" option on dashboards so you need to explain where that is coming from first...

When I right click on Dashboard there I can see Export to Microsoft Excel. It creates a Excel Web Query file. When I am trying to open it, its says Getting Data and then an error message appears.

Sorry, I wasn't clear.

None of the systems I use have "export to excel" when I right-click on Dashboard.

Where are you getting this function from? It sounds like a browser plugin of some sort to me, so you'll need to explain that. Tell us EXACTLY where you are clicking - what Jira screen are you on and which bit you are clicking. What other options do you get?

I am on JIRA Dashboard page. When a right click my mouse, along with Print, Print preview I get this option Export to Microsoft Excel.

Still sounding like a browser function to me, especially with "print" appearing (what are the other options there?). Which browser is it? Can you try another browser?

I certainly don't get an excel export option when right clicking. I am now 99.99% sure that it's something in your browser and not Jira. You'll probably need to fix whatever is providing that.

and again,

Tell us EXACTLY where you are clicking - what Jira screen are you on and which bit you are clicking.

Spam, instabanned.

Hi, did you set the Issue Navigator as your home page instead of the normal gadget Dashboard? Can you let us know which version of Excel you are using? It's definitely worked for me.

Excel 2003 has worked for us. Hi and what browser you are using? You can only export the list of issues with either all your fields or your currently configured fields. Then you may create a chart/graph from the excel itself, but you cannot export it as a predefined graph.

Ah, good point. If they are not talking about the dashboard at all, and using the issue navigator, then it is an option (hence my three attempts to get them to answer the question "where are you clicking").

This function is prone to networking problems, and only more recent browsers and spreadsheets support it properly.

I am using Excel 2003. I want to Export my Dashboard only with the Graph view. Is it possible??

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,137 views 13 19
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot