Exporting from JIRA Help Service Desk to Excel

[Deb Warren]

I am trying to copy a list of JIRA issues from the Service Desk and paste these issues to an Excel file.

The data is pasted in one column instead of across the columns as they appear in the Service Desk.  I have tried pasting this to Google Sheets as well as directly into Excel.

Please advise.

I have also tried to grab data from the Service Desk using an Excel Query and Excel doesn't pick up the data from the JIRA table.

[Victor Mutambuki]

Go to Issues -> Search Issues and on the upper right corner you'll see Export. See attached image.

[Deb Warren]

Okay I see how that works and thanks!  But I am working with a particular queue and I am trying to export just the issues in that queue.  I can't seem to get the Search Function to work when I am in the queue.

[Bastian Stehmann]

You can use the same search criteria like in your queue and save that as filter. You can use that filter then every time you want to export that issues. 

It is not direct in the queue, but not much overhead, I think. 

[Deb Warren]

Help so sorry, I am new to JIRA.

I tried to copy the query JQL,  but I cannot figure out how to save it as a filter.

[Bastian Stehmann]

When you are in the issue navigator,  there should be a "Save as" link next to the Search header on the top of the page.

[Deb Warren]

this is what my screen looks like.  I am in my queue. I cannot find the 'save as' link .....

I think this is hopeless! We use JIRA Service Desk Cloud.

[Victor Mutambuki]

checkout the image. There's the save as button....and also export button.

[Deb Warren]

Yup it worked in terms of exporting every issue to a csv file, but it didn't limit the export to the queue I needed it to .... maybe there's something wrong with the queue.

Thanks for your patience!  I will keep trying to figure this out.

[Deb Warren]

Hey Victor!

I got it!

Thanks so much for your patience.

Deb

[Victor Mutambuki]

you're welcome

[Bastian Stehmann]

Hi @Deb Warren,

Did you try to select the issues in the issue navigator and use the export option?