Use Google Sheets with Jira
Better analyze Jira data with the ability to export Jira issues to Google Sheets, all updated in real-time
Share with both Jira and non-Jira users
End manual imports & out-of-sync spreadsheet data
Fully Configurable Exports
Features In Detail
Gabor Braun, CTO
If you repeatedly need to export data from Jira to your spreadsheets, our integration products are for you.
Once setup, exporting data becomes a breeze, always in-sync, everyone who you provide permissions can easily create their own exports. Our products are the most complete, most convenient, and provide the highest degree of automation.
Unlike other solutions, ours works straight out of Jira. No tinkering in the spreadsheet itself required.
First, install the add-on in Jira Cloud, Server or Datacenter. Then obtain the Google Sheets or Excel Online API keys. You may need to follow a few configuration steps:
After that, simply upload the obtained key on the Add-on configuration page and you are ready for your first export.
API calls to Google Sheets and Excel Online are free. There will not be any additional charges.
However, there are time-based API call limits. For example, if you have a large Jira instance with many real-time updates going to Google Sheets you may need to increase the API call limit. Increasing the API limit is free.
For more details see this documentation page.
Excel has a much higher API call limit, increasing it will rarely be necessary.