Hi Atlassian community,
I work on the product integration team at Atlassian and I am very excited to announce our new Jira Cloud add-on for Google Sheets which gives any Jira user the power of JQL in Google Sheets. The add-on is available for free on the G-Suite marketplace and can be installed by any Jira Cloud user.
Over the past months, we collected feedback from early users. Here are some cool use cases from users:
Create a weekly stakeholder report to estimating the launch date of a project.
Analyze the velocity of a development team.
Estimate the quality of shipped code via bug re-open rates.
Review the budget of a project by merging data from Jira and other systems in GSheets.
We are excited to hear what you will do with the add-on, simply comment with your experience on this post or leave feedback in-product. Not using Google Sheet? Stay tuned for an integration with Office 365 in the coming months.
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.
Here are the ways to import Jira data in a spreadsheet:
The add-on will run the JQL query and return all Jira issues matching the JQL specified, using your default columns, as specified in Jira.
To change your default columns in Jira:
Simply select a Jira filter to import from the side panel, the import will display the columns specified in the filter.
Note: the filter must be starred in Jira for it to appear in the list of filters you can select in the add-on.
If it’s your first time creating a filter in Jira, we suggest you have a look at this very handy article from our friends over at Zapier: How to create a filter in Jira.
Alternatively, the add-on provides a function which gives you the option to specify the list of Jira fields you want the query to return, as well as the number of rows. You can also use it to paginate through a large list of issues.
Using the Jira function gives you a powerful way to return Jira data in Sheets
Before you use it to make sure to enable the function using the toggle in the add-on’s side panel:
Using the JIRA() spreadsheet function you can do more advanced things like refreshing the data periodically, returning more complex fields or returning a table without a header. In order to help you use it we’ve created this sample spreadsheet.
Here are a few examples of what you can do:
You can now export filters and searches directly from Jira to Google Sheets. You can find the Google Sheets icon as a new option next to the share and export buttons on the issues search page:
We’ve received quite a lot of feedback since the early access program. We’ve already addressed a few and we’re currently working on the following features (along with their Jira issue key so you can follow their resolution):
A way to easily see which fields are available in a Jira site, and which ones are supported/not supported by the add-on (API-81)
A way to refresh the spreadsheet data at the click of a button (API-52)
We’re also looking into the feasibility of the following feature requests:
A way to refresh the spreadsheet data based on a schedule (API-54)
A way to query the worklog (API-85)
A way to bulk create Jira issues from a spreadsheet (API-86)
A way to import issues in a spreadsheet, make changes and push them back to Jira (API-87)
This add-on only works with Jira Cloud, and does not yet support Jira Server, the on-premise version of Jira.
Using this is pretty simple and does not require any help from your friendly Jira administrator. From any Google Sheet:
Click on Add-ons > Get new add-ons
Search for “Jira Cloud for Sheets”
Click the “+Free” button and follow the prompts
G Suite administrators might need to enable access to Google spreadsheets add-ons for all users. Read more
Once enabled on G Suite, follow the steps below to install the add-on:
Go to the G Suite Marketplace
Search for “Jira Cloud for Sheets”
Click Install and follow the prompts
Note that we only support Jira Cloud today, if you are on Jira Server or Data Center you'll need to use one of the Google Sheets or Excel apps available in the Atlassian Marketplace.
We've done a lot of work to test this, but since this is the first version we put out in the wild you might hit a couple of rough spots. If so let us know and we'll fix this for you!
You’ll find it here on confluence.atlassian.com
Please get in touch with Atlassian Support, we’re here to help.
Yes, please! We have plans for additional features, and we'd love to hear from you how we can make the add-on even better.
You can send us feedback using the “Jira Cloud for Sheets” side panel
If you tick the "Yes, you may contact me about this feedback" box we might get in touch to understand your needs a bit more. Help us shape the future of this add-on!
Nice! The team would love to hear that their hard work has paid off: if you could drop us a comment in the feedback form we'd really appreciate it, that's what keeps us going! If you would like to give us a little quote we could use when we announce the feature more widely we'd be eternally grateful.
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