Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,361,608
Community Members
 
Community Events
168
Community Groups

How can I export the Backlog to csv or Excel or TXT?

How can I export the Backlog to csv or Excel or TXT? There is no export in any of the menus options.

3 answers

1 vote

Hi @Greg Messemer -- Welcome to the Atlassian community!

Were you able to figure out this issue?  To export from JIRA, you

  • Navigate to Issues and Filters
  • Create a filter for the items of interest,
  • Select the Export to CSV at the top right of the page, under Export

There is a limit of up to 1000 items for exporting.  If you have more in the set, add more criteria to your filter to export in smaller batches.

Best regards,

Bill

How do you navigate to issues and filter?

Thanks, 

Danny

Hi @dnevarez -- Welcome to the Atlassian Community!

Please start with the top navigation bar...Filters > Advanced Issue Search

Kind regards,
Bill

Like Nishanth K S Rao likes this

Can anyone recommend the actual query to pull up only items in the backlog? Navigating to filters and exporting is simple enough. I'm having trouble coming up with what to request. Thanks

Hi @Samantha Mireanu -- Welcome to the Atlassian Community!

Please try this one, substituting in your project's name:

project = myProjectName AND statusCategory = "To Do" ORDER BY Key

Please note that if you are using a team-managed project, there is no way to query yet for the difference between "to do" in backlog versus on the board.  You would need some other way to distinguish those issues.

Kind regards,
Bill

Like # people like this
0 votes

1. You don't have to do it programmatically if scripting is not your forte

2. You don't have to navigate JQL and create filters, etc

Better Excel Exporter is integrated into the backlog view of Jira and you can export to Excel right from there.

Depending on your Jira deployment type (Server or Cloud), the UI is different, but you can export the Jira backlog to Excel like this:

  1. Go to the Backlog view of Jira Cloud
  2. Open the three-dot menu in the upper-right corner
  3. Select the Excel Export menu item
  4. Select the Excel export format you want

better-excel-exporter-backlog-export.png

(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)

Unfortunately, I am not seeing these options under my backlog tab, I only see the option to show 100 issues or 500 issues. Is there something I need to configure?

@Alicia Thompson I'm not sure if you are on the backlog screen. Please reach out to our support here, so we can give you a personalized solution to this and make it work for you!

Like Greg Messemer likes this

Found a PowerShell script to do this programmatically.

Thanks

Is this with Jira Cloud?

Like Greg Messemer likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

5,078 views 18 32
Read article

Atlassian Community Events