How to export "Epic Link" with all fields (KEY and NAME)?

[Analucia Martinez]

I am exporting the results of a query I created in JIRA where one of the fields is the JIRA (locked) custom field "Epic Link". When viewing the results of the query in JIRA, the "Epic Link" field is rendered as the Name of the Epic (for example: "Fluids Events") but when I export the exact same fields, the value that exports for "Epic Link" is the JIRA ID for that Epic as opposed to the Epic Name (for example: JIRA-101 instead of "Fluids Events"). I need to export the Epic Name as it is rendered in JIRA when I am viewing the results of the query. Adding the column "Epic Name" results in blank values for that column for any story/bug/task that's part of an Epic, so that's not a solution. Help please! 

[Deleted user · Accepted solution]

Keep the "EPIC Link" column, but export it as HTML. Save the file locally and open it with Excel. I get the actual names when I use this approach. You can then save it as a worksheet.

[Matt Hessler]

Just ran into this issue. Your solution works great. Thanks for the workaround!

[Deleted user]

Good workaround, works in Cloud.  Seems like Jira should handle this simple request without a workaround though.

[Smita]

This is a great solution. I am glad one less Market Place plugin to look for.!

[Tom Garnett]

This is now broken in Jira cloud as they've removed the HTML export option - any other ideas on how to work around it?

[Deleted user]

Hi Tom,

Scroll down to the bottom of this thread and see if Smita's work around is still working.

Cheers!

[Paolo Franco Solinas]

Scroll down to the bottom of this thread and see my comment to visualize this in MS Excel export

[Kyle Fritz]

still works as of October 2020. Thanks!

[Aron Gombas _Midori_]

When you export using the Better PDF Exporter, the value of the Epic field will contain the name of the epic. If you also need to include the key, you can do that by customizing the "issue-navigator-fo.vm" template.

[Deleted user]

That's assuming you want to pay $.95/user/month...

Just saying

[Deleted user]

Saying again....

[Adam Dulberg]

As a 'community leader' @Aron Gombas _Midori_ I am disappointed to see you recommend a paid option. I wish Atlassian had a tighter grip over their forum and would discourage this type of behavior and strip individuals of their ability to respond as posts like this should be infringing community policies - in my opinion. Whether you have a stake in the paid option or find it helpful yourself, a suggestion like yours does not educate folks to understand the situation and the capabilities of the application.

Very unhelpful.

[Paolo Franco Solinas]

i recently started using the Get Jira Data Excel add into import data from Jira. I have the Jira Cloud version. For having the name of the Epic on report i included the Epic Link.Name field.

Please upvote/accept the answer if you're satisfied with the response. Thanks!

[Liah Fereydoonzad]

Paolo, how do you get the Epic Link.Name field?

[Sukanya]

Keep the "EPIC Link" column, but export it as HTML.

Now Import Data from HTML into Excel

1. Open an Excel file.
2. Click Browse for More… in the lower-left corner of the popping out window.
3. Find the HTML file you want to import in the folder, then double-click it or hit Open.
4. As suggested by the tip, click the arrow icon to select the area of data then hit Import in the lower-right corner of the window.

Save the file locally and open it with Excel. I get the actual names when I use this approach. You can then save it as a worksheet.

[matt.digel]

These are the only options I'm seeing. Where is printable?

[Smita]

Probably depends upon your JIRA version. For me that is the first option in the drop down (but hey we are using the old version)

[Smita]

For Everyone who is using JIRA server and would like to export Epic Name 

1. Once you have your JQL results, click on Printable.

2. Save the page as HTML

3. Open the saved HTML page in Excel workbook : you could see all your Epic Names as its shown in the UI

[Jane Sherman]

For those on the server version who can't export to html, I just cut/paste from an issues search where type = epic.   Requires some cleanup, but it's the fastest way I can find.

[Deleted user]

Hi guys,

This still works, select this export option and follow the rest of the steps I outlined above.

[joris van Emden]

What Jira version are you using?
They removed in JIRA v7.2.4 the HTML option.
So I guess we are downgraded from that version onwards :(

[Deleted user]

I'm currently on the 'Cloud' or 'On Demand' depending on what you want to call it. So I assume it's the latest version. Are you on the server version?

Not sure about that one. I do remember last year they messed the export options up and everyone screamed. I think the latest version is 7.4. You might want to upgrade

[Alex Nicholas]

This sucks... why remove the only workaround for something so simple?

[Deleted user]

Don't despair, we're on the server version now and the option I described above is still available.

[Agnieszka Kornas]

Not on Cloud though. Can't see any option to keep Epic link and issue Id is sth separate from Epic issue ID. 

[Analucia Martinez]

Thank you so much, that worked!

[Deleted user]

Glad to help!

[Pablo Lopez Martin]

Hi, this is still an issue for me.

From JIRA 7.2.X you can no longer do Excel HTML exports, so you are bound to use csv export, where the Epic Link is displayed as the JIRA ID, as opposed to the Epic Name.

There is a way to force enable the old Excel HTML exports but it will be something that they look forward to deprecate in future releases.

Is there any workaround for showing the name in the csv exports?

[Brad White]

A bit of a necro of this thread sorry, but I am facing this exact issue...and it looks like the "old Excel HTML" has indeed been deprecated.

Is there any way to obtain the actual Epic name rather than the JIRA ID for the Epic?

Thankyou in advance :-D

[joris van Emden]

Nope.
I hate this too.

I now manually find and replace the JIRA ID to the epic name for my reports

[Smita]

You can click on Printable and save the page as HTML. Then open it as Excel. Still works