Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Export tickets from queue jira servicedesk to excel

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.

1 answer

1 accepted

0 votes
Answer accepted
Ravi Sagar Community Leader Oct 17, 2020

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.

Screenshot 2020-10-17 at 18.00.18.png

I hope it helps.

Ravi

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"


Untitled.png

Ravi Sagar Community Leader Oct 17, 2020

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

Like Slim Hassoumi likes this

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

Ravi Sagar Community Leader Oct 17, 2020

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

thank you very much

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 Community Leader Oct 26, 2020

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

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.

Thank you Guys.

This helped answering my question.

;-)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Apps & Integrations

🍂📹 Apptoberfest demo contest roundup: vote for your favorite demos!

Hi Community! The submissions are in (and listed below) for the 🍻🍂Apptoberfest🍂🍻 Demo Competition and it’s time for you to place your votes for the best: Analytics & reporting app demo ...

120 views 2 11
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you