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
Community Members
Community Events
Community Groups

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

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?

2 answers

0 votes

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:

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

Sam Tsubota Atlassian Team Nov 05, 2021

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.

0 votes

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,

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Align

Rockin' the Roadmap - How to make most of the Roadmap with Jira Align

The roadmap challenge for large scale agile enterprises Regardless of the agile framework you use, the agile enterprise has a massive scale with the challenge to connect hundreds of teams and thous...

2,612 views 7 26
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you