Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-20794

As a user I would like to be able to generate reports from Excel using JIRA as external data source.

XMLWordPrintable

    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      We have a number of users who use Microsoft Excel to generate reports on issues stored in JIRA. We currently have two options for getting issue data from JIRA to Excel.

      1) we export search results to excel file and import into Excel
      2) we create a Web Query in excel using URL to JIRA printable view

      The users prefer option 2 as they can just refresh the Excel Web Query and rerun their macros to update the Excel based reports. The only issue with option 1 is that the user needs to copy the URL from JIRA, create a new spreadsheet and web query manually. It would be nice if JIRA had option to create a new spreadsheet with embedded Web Query from the JIRA Issue Navigator.

              Unassigned Unassigned
              b3ad01633a91 Ian Kent
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: