Planned · on the roadmap

Live spreadsheets for Jira

Sheets is coming to Jira: your tasks, issues and time as live tables that formulas, pivot tables and charts read directly, without exports.

Tell me when it's ready What works today
  • Spreadsheet formulas
  • Pivot tables and charts
  • Scheduled e-mail reports
Planned reports

What you will build on Jira

Each is one formula on live data. These are examples of the syntax: the column names will follow Jira's own fields once the integration ships.

=data.issues.count(id, assignee, A2, status, "<>Done")
Workload by person. Open items and estimated hours per assignee.
=data.issues.count(id, project, A2, due, "<"&TODAY())
Cross-project status. One table of every project with its open, overdue and done counts.
=data.issues.avg(cycle_days, project, A2)
Cycle time. Average days from start to done, per project or type.
The data

Tables from Jira

Issues or tasks · Projects · Sprints · Assignees · Worklogs

How it will run

Your data stays in Jira

Sheets will run on Jira's own app platform, so your data is read where it already lives. We plan to list it in the Atlassian Marketplace.

Want it?

Vote for Sheets for Jira

A thumbs up moves Jira up the roadmap. Leave your e-mail address too and we write once, when it ships.

We use your details only to answer you. Privacy policy

Project management: works today

Asanaready
tasks, issues and time

Project management: also planned

Wrikeplanned
tasks, issues and time
ClickUpplanned
tasks, issues and time
Trelloplanned
tasks, issues and time
FAQ

Questions

Is Sheets for Jira available?

Not yet. Jira is on the Sheets roadmap. Give it a thumbs up and leave your e-mail address on this page: we tell you when it is ready, and the votes decide what we build next.

What will Sheets read from Jira?

Your tasks, issues and time, as tables: Issues or tasks, Projects, Sprints, Assignees, and Worklogs. Each table becomes a data source that formulas, pivot tables and charts read live.

Will Sheets change anything in Jira?

It is planned read-only: Sheets reads your Jira data and does not change it.

What works today?

Sheets works today with QuickBooks Online, Xero, Shopify, WooCommerce, BigCommerce, HubSpot, FreshBooks, monday.com, and Asana.

Want Sheets for Jira?

Requests decide what we build next. We write once, when it is ready.

Tell me when it's ready

85 tools on the integrations page