Export from JIRA Issues to Excel with links to the issues

[Alon]

I'm exporting from the Issue navigator to Excel. The only thing that's missing is a column for direct links to every issue found in the search query results.

For example:

Issue Type	Issue key	Summary	Jira
Bug	AB-118	Create	Link to issue

[Michael Kuhl _Appfire_ · Accepted solution]

Hey @Alon - A hack you could use is to create a formula field in Excel that concatenates the Jira URL and the issue key.

Like so: concat("https://examplegear.atlassian.net/browse/",A1)

[Alon]

It's a nice hack, but how can I implement this on 500 issues/cells?

The keys are not exactly following numeric order.

Issue key	Summary	Priority	Severity
NGA-118	Create	Highest	Critical
NGA-173	Series	High	Medium
NGA-175	Message	High	Medium

[Michael Kuhl _Appfire_]

HI @Alon - I made an example using the data you supplied.  Hopefully it helps illustrate the solution better.

[Alon]

Unfortunately it didn't work. The the plain text doesn't change in a corresponding hyperlink to the issues in Jira.

Besides the point, got no access to google sheets, and no function of CONCAT (only CONCATENATE).

[Michael Kuhl _Appfire_]

Concatenate is the same thing in Excel.  In Excel you can use the Hyperlink() function to convert the text to a link. 

So in Excel you would change the formula to:

Hyperlink(Concatenate("https://examplegear.atlassian.net/browse/",A1))

[Alon]

Thank you very much! it works now.

[Nitin Gupta]

Is there any update on this issue? this seems like a fundamental thing that should be supported to have URL links to each issue - without it seems very unusable.

[Krister Broman _Advania_]

Are you

- using Jiras built in Excel exporter or a plugin?

- using Jira Server or Jira Cloud?

Assuming the built in exporter in Jira Server, then make sure you have added the column called "Key". The one you have specified, "Issue Key" is used in JQL. 

If Jira Cloud then that export runs as csv file and wont give you http links, that one is text only.

[Alon]

The export runs as csv file and is showing text only.

[Manoj Reddy kancherla]

@atlassian Can you implement logic to import the JIRA issues with Hyperlink enabled by default when we pull a report?

[Tarun Sapra]

Hello @Alon 

That's strange because when I export current fields on cloud then I am able to export the linked issue in outward links section in csv file. Please see the below screenshot.

[Tarun Sapra]

I am using Jira -cloud and no apps. But here the export contains the link key in plain text and not direct links.