JQL Data Pull in Excel

[Frank Wilson]

Is there a way to pull the "Key" field in an Excel query without it automatically putting in the hyperlink to the issue?  Waiting for Excel to create the hyperlink is slowing down my daily data pulls in Excel.

[Aron Gombas _Midori_]

Whether issue keys or summaries should be link or plain text is configurable with the Better Excel Exporter generated exports!

See these two intuitive settings in the "field-helper.groovy" script:

def issueKeyAsLink = true
def summaryAsLink = true

 (Discl. it is a paid and supported app developed by our team. Free for 10 users!)

[Benito Jiménez _Sevidev_]

Hello @Frank Wilson! How are you performing the export? I understand it's from the issue search screen, selecting Export issues / Export Excel CSV, right?
Can you elaborate on the steps you're following?

Kind regards.

[Frank Wilson]

Actually, I am using the JIRA add in tool in excel and doing a query / data pull from within Excel.  It works well, but it is takes several extra minutes to pull data because Excel wants to add the hyperlink to each issue key.  I would love to have a way to tell the JIRA Excel add in to not pull the hyperlinks.  I do need the issue key itself, but I just don't need it to be hyperlinked back to Jira.

[Benito Jiménez _Sevidev_]

Thank you for the information @Frank Wilson I now understand that you are using the "Jira Cloud for Excel" add-in for Microsoft Excel.

As far as I can see, there is no way to configure it to export the IssueKey field without a link. However, I don't think this feature should make the process much slower.
Two alternatives come to mind:

• Use the IssueID field, although it's clearly less descriptive than the IssueKey.
• Manually export the issues by going to the issue search screen and selecting Export issues / Export Excel CSV. However, I believe this option is more time-consuming and difficult than the one you're currently using.

Hope this can help you.

Kind regards.

[Frank Wilson]

While checking to see whether I can use the IssueID field, I did a test spreadsheet and I noticed the same search query that normally takes 3 to 5 minutes ran in just a few seconds in the temporary spreadsheet.  It likely is due to my more complex datasheet and the autocalc function.  So I am going to take a different approach where I pull the data in a simple spreadsheet and then have the more complex spreadsheet map to the simple spreadsheet.  Thank you for getting me to try a different approach!