3

    Jira Cloud for Google Sheets (Official)

    by Atlassianfor Jira Cloud
    Supported
    Atlassian supports this app.

    Get support

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

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

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

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

    Jira Service Desk
    This app is compatible with Jira Service Desk.
    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 in your spreadsheets

    Get started in a few clicks

    Support for simple and advanced needs

    Query Jira from Google Sheets, combine data from multiple Jira sites and projects, as well as other systems.

    Set it up and import Jira data in a spreadsheet in less than a minute. You do not need to be a Jira administrator to install this app.

    The app supports all Jira products, project types, built-in and custom filters, JQL, as well as built-in and custom fields. It exposes a Google Sheets custom function for power users.

    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

    (3)
    Sign in to write a review
    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.
    1 out of 3 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

    (3)Sign in to write a review

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

    Reviews for Data Center

    (3)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