Missing Jira Key URLs in Excel Exports or Imports

Bex Streeper

When either exporting from Jira or using the add-in from Excel, the issue keys are missing the URLs/link. My data is converted to an Excel table. 

 

When exporting from Jira or using the Excel add-in, the issue keys no longer include the Jira Key URLs/links. Additionally, my data is being converted into an Excel table.

Ramakrishna _RK_

Hi @Bex Streeper ,

Welcome to Atlassian Community!!

In Jira Cloud, the issue key URLs are not included by default in the exported Excel or CSV file. 

But once you exported to Excel/CSV you can use formula to generate the issue URL for each issue like below.

=CONCATENATE("https://yourcompany.atlassian.net/browse/", A2)

Note: A2 is the column in excel where you have Issue key.

Please accept this answer if it solve your query. Thanks!

 

Regards

RK