Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do i download report and charts from Jira in Excel

I dont have jira excel option under my Export button as im using Jira on a server instead of cloud.

What can i do to if i want to download reports and charts into excel.

Thanks

3 answers

Hi @Thi Tran 

If you do a quick search, you will find that it's been discussed in many great threads on the Community.
However, if you are looking to generate professional reports from Jira Service Desk into native(!) Excel spreadsheets (possibly with charts, pivot tables, etc), one option you have is to look around for an app on the Atlassian Marketplace.

Better Excel Exporter for example has dedicated templates for Jira Service Desk.
The app adds a new "Export" menu to your Jira Service Desk queue UI, or if you pull together the tasks with a JQL query in the Issue Navigator that you want to export, you can get an Excel export like this or you can even use the Service Desk Report report template that is shipped with the app and create a report with pivot tables and charts, etc:

jira-service-desk-time-to-resolution-pivot-chart.pngPlease note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.

Thank you for your reply, without these additional add on then i cant generate professional reporting.

edited

wrong account

https://confluence.atlassian.com/jirakb/excel-issue-export-from-jira-server-opens-empty-or-blank-838403242.html?_ga=2.179264548.1816384661.1590141483-1654707711.1590141483

 

We removed the Excel export option in JIRA 7.2, as we've introduced a more robust, flexible exporter in the CSV export. We hope you find this more beneficial. We do plan on removing this functionality entirely, however in the meantime, it can be unlocked with the following steps:

1. Stop JIRA.
2. Locate the jira-config.properties file in the $JIRA_HOME directory. If the file does not exist, please proceed to create it.
3. Open the file and add the below on a separate line:

jira.export.excel.enabled=true

4. Save this file.
5. Restart JIRA.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Announcing Team Calendars in Confluence Data Center

Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond.  A long time favorite,  Team Cale...

27 views 0 2
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