Jira Cloud Excel plugin - Hyperlinks not importing into Excel Table

Question

Hello,

I have installed the Jira Cloud for Excel plugin and have successfully imported data from my Jira projects into Excel.   I want to maintain a hyperlink in the KEY field, so that within Excel I can click on the Key and it will take me to the issue in Jira....very useful.      The plugin has checkbox options for 1) maintaining hyperlinks on import and 2) importing as a table.    I have of course checked the box to maintain hyperlinks.   Here is the issue:

1) If I import that data as a range (table option un-checked) the KEY hyperlinks work in Excel.

2) If I import the data as a table (table option checked) then the KEY hyperlink are lost and don't work.

What I need:  I use this table to generate several pivot tables (reports), so I need to import the data as a table (#2 above) and I need for the hyperlinks to work throughout the imported data and generated pivot tables.

Any suggestions are much appreciated.

Bill

Levente Szabo _Midori_ · Answer

@Bill Ketchel

If you want to export your Jira data to Excel with hyperlinks working reliably, you can try Better Excel Exporter for Jira Cloud. It does maintain your Jira issue links for issue keys (you can even configure your template to add links to any other field if necessary).

It also comes with report templates for a number of typical use cases. You can use those ou-of-the-box, or modify them to build your own Excel report.

Browse Excel export samples to discover what's possible >

(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)

Hannes Obweger - JXL for Jira · Answer

Hi @Bill Ketchel

as already mentioned, this indeed looks like a bug that ideally would be raised with Atlassian.

On somewhat of a meta note: One thing to consider is whether you actually need to export your data to Excel. This of course depends on your exact use case, but you may be aware that there's a large number of dedicated reporting apps available from the Marketplace, ranging from additional dashboard gadgets to sophisticated BI solutions. Just since you've mentioned pivot tables: My team and I work on an app named JXL for Jira that brings spreadsheet/table capabilities directly into Jira, with features like (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. This is one possible report - but you can configure pretty much any table view you can think of:

Plus, of course, any issue links work as expected, and you can navigate to your issue in just one click :)

Any questions just let me know,

Hannes

Dmitry Astapkovich _Colined_ · Answer

That looks like a bug. Jira Cloud for Excel is developed by Atlassian, so you should submit a support ticket: https://support.atlassian.com/contact/#/

As an alternative, you can look for apps that create reports directly in Jira. E.g. Pivot Report, that we develop at Colined, was created to avoid data export:

You can play around with demo reports or install the app from the Marketplace.