Use Google Sheets or Excel Online with Jira
Export your Jira issues to Google Sheets or Excel Online (Microsoft Office 365) and keep them up-to-date in real-time
Boost Productivity By Empowering Your Team
Collaborate with non-Jira users using spreadsheets. Share Jira data and reports securely with anybody in your organization directly out of Jira.
- Give your team the power to work and collaborate in the way they are most productive
- Collaborate with non-Jira users
- Analyze and share Jira data in a flexible way
- No more manual imports and out-of-sync data
Share, View & Update
- Permission controls to share with users, groups, or domain
- Published spreadsheets can be viewed directly in the Jira administration section
- Create exports easily based on your familiar Jira filters and search screens
- Real-time or scheduled updates
Work Smarter by Integrating Spreadsheets with Jira
Never copy and paste or worry again about data not being in-sync in your latest spreadsheet reports. Optionally, enable changes in a Google Sheets to flow back into Jira.
- Drag and drop to add columns and change order right inside of Jira
- Auto updates or restrict updates to a defined schedule
- Granular control of access permissions directly in Jira
- Manage your published spreadsheets in Jira
- Combine data, create diagrams and pivot tables, and update them automatically
Features In Detail
Google Sheets Integration
Bidirectional Jira - Google Sheets Synchronization
- Edit issues directly in Google Sheets, see them instantly update in Jira (must install free Google Sheets add-on).
Fully Configurable Exports
- Manage real-time exports within Jira to flow into Google Sheets whenever an issue is updated.
- Export Jira issue list on basic and advanced search. The data can be exported into a new Google Sheet or into an existing spreadsheet. The name and update schedule can be edited directly in Jira.
- Select standard and custom fields to be exported. All fields of your Jira instance are available for export and are formatted and displayed in a spreadsheet friendly way.
Excel Online Integration
Right Inside Excel Online (Microsoft Office 365)
- Analyze and manipulate your Jira data in Excel Online.
Export Jira Issues to Excel
- Create real-time, ad-hoc, and scheduled exports to Excel. Even export to Excel for desktop.
- Select Jira fields to export. Select standard and/or custom fields to export. All Jira fields are available for export and formatted and displayed in a spreadsheet friendly way.
- Copy in data from other systems and create diagrams, pivot tables and more.
Gabor Braun, CTO
How to Install Google Sheets Intergration for Jira
Obtain Google API key and then everybody will be ready to
export any issue searches to Google Sheets with a few
simple mouse clicks.
How to Install Excel Online Integration for Jira
This add-on is easy to install. Obtain the Microsoft Excel
Online API key then everybody will be ready to export any issue searches to Excel Online with a few simple mouse clicks.
FAQs
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.
