Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Missing Jira Key URLs in Excel Exports or Imports

Bex Streeper
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 2, 2025

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. 

JiraLinks.PNG

 

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.

1 answer

0 votes
Ramakrishna _RK_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 2, 2025

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events