Export tickets from queue jira servicedesk to excel

[SMT - Mustafa Demir]

Hi all,

I have a queue named "Tickets last two weeks". I want to get a button below, that it will export the tickets to excel.

[Ravi Sagar _Sparxsys_ · Accepted solution]

Hi @SMT - Mustafa Demir 

You can use the Issue Navigator to search for the issues using the same JQL as used in your queue, there is an option there to export the issues in csv.

I hope it helps.

Ravi

[SMT - Mustafa Demir]

where is this "Issue Navigator" exactly? i can't find it.

I'm now in the queue, and only see "edit queue" and "delete queue"

[Ravi Sagar _Sparxsys_]

Go to the search box on top right of your Jira instance or press forward slash / and then click on Issues. 

[SMT - Mustafa Demir]

Thx, it worked. i appreciate it. But when i export it doesn't auto seperate?

[Ravi Sagar _Sparxsys_]

You will get CSV which you can open in Excel. Use the option Text to Column with comma as the delimiter.

[SMT - Mustafa Demir]

thank you very much

[SMT - Mustafa Demir]

Is it also possible for in the search, to choose only fields that i want in the output of excel.
Example. In excel in only want as Output: Issue type,Summary, Status, 

[Daniel Ebers]

yes, therefore just click on the option reading "current fields". With this in the exports the current displayed columns are exported.

[Lorenzo Bernardi]

Is it possible to export Text filed with bulleted list or enumerate list?
Excel reply the bullet with * and the Number with # or ##.

Thank you.

[Slim Hassoumi]

Thank you Guys.

This helped answering my question.

;-)