The easiest way is to select “Filters” from the top navigation bar, then “Advanced Issue Search”. You can export your Jira issues using the Advanced Search, which you can access a few different ways. Generating a Jira report in Excel and Google Sheets To that end, Atlassian has built integrations with Microsoft Excel and Google Sheets, so that users can generate charts and tables out of their Jira data in the platforms they’re most familiar with. While the best option is to purchase a reporting app from the Atlassian Marketplace to make customizable charts in Jira itself, many teams are more comfortable with traditional spreadsheet builders like Microsoft Excel and Google Sheets. Atlassian knows that many of its users are going to want more. While there are reporting options in native Jira (board reporting and standard dashboard reporting), they are limited and not very customizable. Ideally, you want these reports to display the data you want to display, in the way you want to display it. In daily standups or weekly reviews, reports are necessary for providing updates and showing the team and/or the stakeholders where you are in the development of a product.

When you’re working on a team, team meetings can be an important part of your day.

Import data from google sheets to excel