Can I create a column for the url link to the issue when I pull Jira into a csv?

[McKenna Hogan]

Hi,

I often pull my jira data into excel through a csv. I have columns set up such as Issue key, summary, issue type, etc.....

Is there a way to pull a column for the url to the issue? So that I can migrate straight from excel to jira when we are looking over the excel document? I know I can string aggregate in excel to create the url but I'm wondering if there is a way to do it straight from jira. When I look up "link" or "url" in configure columns, I don't get any options that suit what I want.

[Mikael Sandberg]

the short answer is no, not unless you have an app that supports it (I can't remember if Better Excel exporter did it or not), you create your own app that uses the API or you have access to Analytics. The issue key is a combination of the display name and the URL that is combined in the GUI.