No option available to extract issues from backlog into excel

[Deepali Dabholkar]

We are using JIRA cloud instance and I am unable to locate any option to export epics from backlog to excel

[Aron Gombas _Midori_ · Accepted solution]

Epics are work items in Jira with a special work type. To get all epics in a project, run this JQL query in the "All work" screen:

project = MYPROJECTKEY and type = "Epic"

... then export it using the CSV exporter feature or a third party Excel exporter app.

[Staffan Redelius · Accepted solution]

Hi @Deepali Dabholkar and welcome to the community.

There is no export button in the backlog view but if you go to "List" or "All work" you can filter the issues you are intrerested in and click on the export button in the top right in the menu

Best regards,
/Staffan

[Swathi Acharya · Accepted solution]

Hello @Deepali Dabholkar

Welcome to Atlassian Community!

We do not have an option to directly export issues from the Backlog, however, you could navigate to the filter used by the Board and Export the results.

I hope that helps!

Thank you

[Natalia_Kovalchuk_SaaSJet_]

Hi @Deepali Dabholkar !

In your case, I want to recommend you try the Issue History for Jira app from my team. With it, you can easily export your epics, including a detailed history of their updates, from Jira to Excel.

For that, you need to do the following:

1. After the app installation from Atlassian Marketplace, open it from the Apps menu and select work items by JQL like issuetype = Epic. 

2. Use the other filters if needed (filter by date range, updater, epic status, project, etc.).

3. Export the needed epics in Excel format. 

You will receive such a report:

Hope this will be helpful. 

[David Nickell]

if you can tolerate my 8 minute video here:  https://www.youtube.com/watch?v=EP-VJRzrdrg.. you can see how to use the free REST API to Excel spreadsheet from the SplitDimeData.com website.

https://splitdimedata.com/downloads

I'm not selling anything.  At least not until early next year :-)