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

jira export to excel -Boost_Productivity
jira export to excel -share_view_update

End manual imports & out-of-sync spreadsheet data

Fully Configurable Google Sheets Jira integration

jira export to excel

Features In Detail: Google Sheets Jira Integration

“I have subscribed for this addon, which really moves my reporting needs to a total new dimension! This tool rocks, and I have pulled a pretty advanced company wide reporting thanks to your hard work.”

Gabor Braun, CTO

5/5

How to Connect Jira to Google Sheets

Obtain Google API key and then everybody will be ready to export any issue searches to Google Sheets with a few simple mouse clicks. Jira Google Sheets integration is updated in real-time.

See Support page

FAQs

If you repeatedly need to export data from Jira to your spreadsheets, our integration products are for you.

Once set up, 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. 

Atlassian announced in the summer of 2022 that they were killing their app Jira Cloud for Sheets. They reversed the decision after an outcry.

If you no longer believe that Atlassian is serious about supporting Jira Cloud for Sheets then consider our app Google Sheets Integration for Jira.

Read about why you should move.

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:

Google Sheets steps

Excel Online 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.

Get your team the tool they need