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

Looking to export all tickets data to excel

Atkins, Carol February 2, 2024

I am trying to export all ticket history to excel.  I've used a basic jql search "created <= now() ORDER BY created ASC" and seem to only get 1001 tickets no matter what search criteria I use.  Appreciate any help you can offer, thank you!

1 answer

1 accepted

1 vote
Answer accepted
Rudy Holtkamp
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 2, 2024

Hi @Atkins, Carol ,

I would like to suggest you use this Excel add-on created by Atlassian and it is free.

You can get 5000 rows at once and it is very easy to use.

If you have more than 5000 issues, you need to break your query up into smaller fragments
E.g. only export a subset of projects, and in the next query another subset or first only export tasks, then stories, etc.

Good luck!

 

Atkins, Carol February 2, 2024

Thank you Rudy!

Like Rudy Holtkamp likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events