Jira Cloud for Google Sheets (Official)
- Jira Service Management
Jira in spreadsheets: the solution for your reporting pains
Import Jira data into your spreadsheets
Query Jira from Google Sheets and combine data from multiple Jira sites and projects.
Visualize Jira data
Slice and dice your Jira data. Analyze and create the reports your stakeholders, managers, and clients need to understand your team's work.
Keep your data fresh
Update your reports periodically or on demand. Ensure that your reports are always up-to-date.
This app gives any Jira user the power of Jira filters and JQL in Google Sheets. You can import Jira issue data from any number of Jira sites into a spreadsheet using either your saved filters or a custom JQL query. To customize the output format simply configure your saved filter or change your default columns in Jira.
There are two ways to import Jira data in a spreadsheet:
- Using the “Jira Cloud for Sheets” sidebar
- Using the =JIRA() custom function.