I want to Download user story data for all stories into Excel > 2000 stories

[Brian Grogan]

Being able to extract a file into Excel with the following data points from Jira project with > 2000 user stories

  User story, status, user story description, Story Point estimate, Assignee, Epic Link, Issue reference

[Prachi Bolar]

Hi Brian,

Welcome to community :) 

• Refer to this article on how to use Google Sheets or Microsoft Excel to export over 1000 results.
• An alternative solution is to use the Filter Counts gadget for projects with fewer than 9999 work items.
• Another option is the Starred Filters gadget, which retrieves even more tickets.

A few other solutions:

• After running the JQL query, just tap on the 'Export' icon on top right side and select 'Print List' option. It will show the full list of the work items with total number of work items, from which you can get the count.

In addition to the above workaround, there is also a knowledge article, which provides a workaround to see the total count of work items. 

• How-to-see-total-count-of-work items-when-using-jql-and-the-result-is-greater-than-1000

Thank you,

Prachi

[Hannes Obweger - JXL for Jira]

Hi @Brian Grogan,

welcome to the community!

If the issues that you're interested in have a (more or less) continuous sequence of issue keys within a project, another trick is to break your search up into smaller chunks using a condition like e.g.

issuekey >= "PROJ-1" AND issuekey < "PROJ-1000"

... and so on. This way, you at least don't have to fiddle around with your query to only hit <1000 issues.

Of course, as already suggested, it would certainly be easier to utilize one of various Marketplace apps that allow circumventing Jira's 1000 issue export limit. 

If I may provide a specific recommendation, this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Plus, its export feature will allow you to export all your 2000+ issues in just two clicks:

Any questions just let me know, 

Best,

Hannes

[Aron Gombas _Midori_]

You could either split the 2000+ user stories to smaller chunks (e.g. 250 or 500) using filters in the query (e.g. filter by creation date to a single month or to a quarter) and use the built-in export feature or use the Better Excel Exporter app which scales to large data sets.

(This paid and supported app is developed by our team. Free for 10 users!)

[Jim Knepley - ReleaseTEAM]

Welcome to the community, @Brian Grogan 

You can export issues to a file suitable for Excel from a query results field. You should be able to export all fields, or only the fields currently displayed in the issue navigator.

ref: https://support.atlassian.com/automation/kb/how-to-export-issues-from-jira-cloud-in-csv-format/

[Brian Grogan]

Thanks Jim for the guidance and prompt response. Working away on it with filters to get around the 1,000 limit. Thanks Brian