How to connect Jira to Google Sheets with live refresh
Updated September 28, 2026.
Two good options, depending on what you need.
Option 1: Jira Cloud for Sheets (free, from Atlassian)
Atlassian's own Google Sheets add-on imports issues with JQL and can refresh on a schedule. It is a good fit if you only need current issue fields in Sheets.
Option 2: OneFeed (one feed for Sheets, Power BI, Excel and Tableau)
Use OneFeed if you also report in another BI tool, or you need status history for cycle time.
- In Jira, open Apps > OneFeed and click New feed.
- Enter a JQL query, for example
project = ENG AND updated >= -180d. - Choose the datasets: Issues, and Status changes if you want time in status.
- Save. Copy the Google Sheets formula shown for the feed. It looks like
=IMPORTDATA("https://...?feed=...&entity=Issues&format=csv&key=..."). - Paste it into cell A1 of a sheet. The first time, click Allow access on the yellow banner.
Google Sheets refreshes IMPORTDATA on its own schedule (roughly every hour while the sheet is open). Keep feeds under about 25,000 rows; split large projects into several feeds.
The feed key is in the formula, so share the sheet only with people who should see that data. You can rotate the key in OneFeed at any time.
See the OneFeed documentation for Power BI, Excel and Tableau steps.