Skip to main content
Skip table of contents

Jira Issues Sheet


This feature imports Jira issues into the specialized sheet, Jira Issues Sheet for it.

So, it allows you to make use of the contents for a data source.

To create the sheet, in any sheet, press 'Create New Sheet' in the Data tab - Jira Issues Sheet menu group (see the following section).
It will create Jira Issues Sheet as a new sheet.

Menu Items

The “Data” tab has the menu group for Jira Issues Sheet.

Menu item

The behavior of the item

Create New Sheet

  • Create a new Jira Issues Sheet

  • Default fields are Issue type, Issue key, and Summary

  • Default JQL is “project=<the project of current issue>

  • This action allows you to create multiple Jira Issues Sheet

  • The copied Jira Issues Sheet will also be Jira Issues Sheet

Edit JQL

  • Set a JQL for importing Jira issues

  • (warning) The sheet will be reloaded after modifying settings

Edit Fields

  • Set Jira fields that will be displayed

  • (warning) The sheet will be reloaded after modifying settings


  • Reload the sheet with the given JQL and Jira fields

  • (warning) On reloading, it clear every cell on the sheet. If you want to use the data of Jira issues, do it on other sheets.

How to move a column

The following instructions allow you to move a column to other columns.

  1. Select the whole column you want to move

  2. Drag the selection rectangle with pressing the Shift key to the point of a target column

  3. Drop it

Restrictions & Tips

  • In rich text fields, it shows string includes HTML tags

  • If you save as ssJSON format, it stores the information of JQL and Jira fields

    • The data will be lost in other formats

  • This feature doesn’t support editing Jira issues. However, for bulk-editing Jira issues, this app(Excel-like Issue Editor for Jira) is suitable for it.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.