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

[michel]

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.

[Michael Wohlgemuth]

Hey 👋 

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