5

    Jira Cloud for Google Sheets (Official)

    by Atlassianfor Jira Cloud
    Supported
    Atlassian supports this app.

    Get support

    Jira Service Management
    This app is compatible with Jira Service Management.
    Unsupported
    This app isn't formally supported.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Jira Service Management
    This app is compatible with Jira Service Management.
    Unsupported
    This app isn't formally supported.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Jira Service Management
    This app is compatible with Jira Service Management.
    Get it nowLearn more

    Jira in spreadsheets: the solution for your reporting pains

    Jira in spreadsheets: the solution for your reporting pains

    Jira in spreadsheets: the solution for your reporting pains

    Import Jira data into your spreadsheets

    Visualize Jira data

    Keep your data fresh

    Query Jira from Google Sheets and combine data from multiple Jira sites and projects.

    Slice and dice your Jira data. Analyze and create the reports your stakeholders, managers, and clients need to understand your team's work.

    Update your reports periodically or on demand. Ensure that your reports are always up-to-date.

    More details

    This app gives any Jira user the power of Jira filters and JQL in Google Sheets. You can import Jira issue data from any number of Jira sites into a spreadsheet using either your saved filters or a custom JQL query. To customize the output format simply configure your saved filter or change your default columns in Jira.

    There are two ways to import Jira data in a spreadsheet:

    • Using the “Jira Cloud for Sheets” sidebar
    • Using the =JIRA() custom function.

    Reviews for cloud

    (5)
    Sign in to write a review
    by Ian Sheffield on 2021-02-19
    The latest work on this takes it to the next level. I'm using this with a custom filter to import all my publically viewable issues that have been address for a particular release. I then format it quickly using google scripting and embed it in a table in a google doc so I can auto-generate pretty release notes! Amazing way to simplify building release notes without manual copy and pasting / fudging required.
    Was this review helpful?YesNo
    by Ernesto Barrionuevo on 2019-09-07
    An excellent extension for google sheets. Haven't found anything yet to complain about 5/5
    1 out of 1 found this review helpful
    Was this review helpful?YesNo
    by Phil Merricks on 2019-04-30
    Half a job. This would be essential if it could import and export between Google Sheets and Jira.
    2 out of 4 found this review helpful
    Was this review helpful?YesNo
    by Artem Zavyalov on 2019-03-29
    One of the few free and good apps for Jira Cloud! Hope it stays this way.
    Was this review helpful?YesNo

    Reviews for server

    (5)Sign in to write a review

    There are no reviews yet. Be the first to review this app.

    Reviews for Data Center

    (5)Sign in to write a review

    There are no reviews yet. Be the first to review this app.

    Cloud Pricing

    Server Pricing

    Data Center Pricing

    Atlassian provides support for this app.

    Vendor support resources

    Documentation

    Find out how this app works.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Atlassian-hosted discussions connect you to other customers who use this app.

    Versions

    Jira Cloud • Released 2019-03-27

    Summary

    First version

    Details

    Support for importing Jira data to a Google Sheets spreadsheet in basic and advanced mode

    Installation

    • Open the listing in the Google Suite Marketplace and press "Install". Note: Google Suite administrators might need to enable access to Google spreadsheets add-ons for all users. Read more

    Similar apps