Is there a way to export all items from Ideation to Excel?

Question

We have over 300+ items listed in ideation, but are looking for an easy way to provide a readout.  Is there a way to export these items to a spreadsheet?

Sam Tsubota · Answer

Jira Align Enterprise Insights (EI) data warehouse has tables with all the idea, ideation groups and ideation form custom fields. You can get an EI instance for your Jira Align instance and connect a data visualization/BI software like Tableau or Power BI and build a report or dashboard and export the data to Excel. You will also have all of your data in your Jira Align instance to build custom reports and metrics. You can reach out to your Atlassian Enterprise Advocate for more information and even request a 45 day trial.

Rodrigo Cortez_jg22qq · Answer

Hi @Chad Evans !

Exporting ideas from the Ideation portal is not yet supported by Jira Align.

However, there are currently two open ideas on that matter:

* iZone 736 - Ability to export the Ideation contents

* iZone 1036 - Ideation module - Add ability to Export Ideas

I'd encourage you to subscribe and upvote these ideas, to raise awareness on that demand along the Product Management team.

Allan Maxwell · Answer

I don't think a direct export to Excel format exists, but you can use the Jira Align API 2:  GET {{base_JA_url}}/Ideas

The results are returned in JSON format.

{
"id": 4,
"ownerId": "Allan.Maxwell",
"createdBy": "Allan.Maxwell",
"createDate": "2017-12-21T08:50:39Z",
"lastUpdatedDate": null,
"title": "As a system admin I would like ...",
"groupId": 3,
"productId": null,
"status": 0,
"isExternal": 0,
"description": "blah, blah, blah",
"companyId": 1,
"categoryId": 1,
"isPublic": 0,
"self": "https://xxxxxx.jiraalign.com/rest/align/api/2/ideas/4"
 }