Jira and Google Sheets guides

Practical how-tos for getting Jira data into Google Sheets, keeping reports fresh, and sending changes back to Jira, whichever tool you use.

1. Bulk Update Jira Issues from a Spreadsheet: CSV Guide

   Update existing Jira issues from a CSV or Google Sheet with the Work Item Key column, step by step, plus what to do if you're not a Jira admin.

2. Export Jira to Google Sheets: 6 Methods Compared (2026)

   CSV export, Atlassian's free add-on, =JIRA(), connectors and Apps Script compared: real limits, refresh options and which to pick for live reports.

3. Export Jira Worklogs to Google Sheets for Timesheets

   Get one row per Jira worklog into Google Sheets for timesheets and billing: the all-fields CSV, the free add-on, and a script that reads every entry.

4. Jira Cloud for Sheets Alternatives: 8 Options Compared

   Free and paid replacements for Atlassian's Sheets add-on, compared on refresh schedule, row limits, write-back and price. Facts checked October 2026.

5. Jira Cloud for Sheets Not Working or Refreshing: 9 Fixes

   Blank sidebar, GS-404, No Jira auth, a schedule that quietly stopped: what each symptom means and the fix to try first, from Atlassian's bug tracker.

6. Jira Google Sheets Two-Way Sync: 6 Options Compared

   Unito, Mobility Stream, SheetSync, Project Aid, Zapier and Make compared on how edits reach Jira, conflicts, admin install and price (October 2026).

7. Jira SLA Report in Google Sheets: Met, Breached, At Risk

   Build a Jira Service Management SLA report in Google Sheets: JQL for met and breached requests, met-rate formulas, and a script for goal and elapsed time.

8. Jira Time in Status in Google Sheets, Without a Plugin

   Measure time in status and cycle time for Jira Cloud work in Google Sheets: what Jira shows natively, JQL for aging work, and a free changelog script.

9. Jira Weekly Status Report in Google Sheets (with JQL)

   Build a weekly Jira status report in Google Sheets: JQL for done, in progress, blocked and overdue work, summary formulas, and a refresh you can trust.

10. JQL Examples for Reports: 40 Queries for Jira Cloud

    40 JQL queries for status, sprint, workload, aging, time tracking and SLA reports, plus the date and history rules that quietly skew report numbers.