how to export jira issue key links when exporting into csv format

[Susila Selvaraju]

When export the Jira issues into CSV format, the issue keys are getting downloaded as texts, what is the option to retail the hyperlink when we export the issues in CSV format? having restrictions and cannot use HTML/XML format.

[Vishal Biyani]

@Susila Selvaraju 

If you have O365, you can use Jira plugin with O365 and download the data in excel. Then you will get links. 

Otherwise, the option suggested by @Akriti Sagar are worth a try

[Susila Selvaraju]

Thank you, will try

[Akriti Sagar]

Hi Susila,

Great question. By default, when exporting Jira issues to CSV, the issue keys (like ABC-123) are exported as plain text, not as clickable hyperlinks. Unfortunately, CSV is a plain text format and doesn’t support rich content like hyperlinks directly.

That said, here are a couple of workarounds you can try:

Add a Formula in Excel or Google Sheets
After exporting your CSV and opening it in Excel or Google Sheets, you can convert the issue keys into hyperlinks using a formula.

For example:
=HYPERLINK("https://your-domain.atlassian.net/browse/" & A2, A2)
Replace A2 with the cell containing the issue key, and update the domain to match your Jira site. This will turn each issue key into a clickable link.

Add a Custom Field in Jira (Pre-Export)
If you frequently need links, you could create a custom field in Jira (e.g., "Issue URL") and populate it using an automation rule or script that adds the full issue URL to each issue. This field can then be exported as part of the CSV.

Unfortunately, there’s no built-in option to export hyperlinks directly in CSV without using one of the above workarounds, especially if HTML or XML export is restricted in your environment.

Let me know if you'd like help setting up the formula or Jira automation.