Importing hyperlink with user friendly text into a Jira ticket from a csv

michel
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!
May 10, 2024

I have a lot of tickets to import in bulk from a master csv file, tasks with associated subtasks.

My task tickets have hyperlinks to various documents, which I can hyperlink in the description field easily enough, ie.

"Batch location: https://drive.google.com/drive/folders/1_kbe5JaWBaW7RvfKvov-Zdgv4rgBk9Wc"

However, I would rather have user friendly text such as:

Batch location: A-level Biology

My first approach was to use the HYPERLINK excel function e.g.
"Batch location: "&HYPERLINK("https://drive.google.com/drive/folders/1_kbe5JaWBaW7RvfKvov-Zdgv4rgBk9Wc","A-level Biology"

In the authoring *.xlsx

But this only gets converted to plain text with all links removed when saved as a *.csv. Equally, attempting to "cheat" by copying the hyperlinks formulas directly into the *.csv and then attempting to import into Jira does not work, as the hyperlink information is stripped away in the process.

Has anybody found a work-around for this? I can live with full URL in my descriptions but it can become unsightly very quickly.

 

1 answer

0 votes
Michael Wohlgemuth
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.
May 14, 2024

Hey 👋 

can you try this formatting in the csv? Check the "create external link (with an alias)" section.

Suggest an answer

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

Atlassian Community Events