Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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 Champion
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