Starting with empty worksheet [3.5.x]

• • Start MS Excel and create blank workbook
  • Open Excel Connector for JIRA ribbon (1), click Login to JIRA button (2)

  • Enter your credentials and click Connect button (3).

     There's no need to use administrator account when working with Excel Connector.

• Notice that the ribbon has expanded and the worksheet contents have changed. You are now logged into JIRA and ready to do some work.

• The following step is to fetch some issues from JIRA

While using Excel Connector 3.3.x you can be logged in only in one worksheet at the same time. If you would like to work with several sheets you may edit them offline. When your work is done just log out from other sheet and log in on the one you would like to send to JIRA. If you are logged in on one sheet, you will be warned while trying to log in on another.

Information about hidden 3rd row data

After logging in, there's a 3rd row in worksheet that is not visible (see image above). After manually changing its visibility, you can see what it contains (1):

 More details on 3rd row

When 3rd row is visible, you can see that it also contains custom fields' ID numbers:

Data placed in it is strictly tied with Jira elements and is crucial to successful work of the add-in.

 After making changes in Excel's spreadsheet, please refer to Color legend  page for information about changes in cells background color.

 For more details about please see: User roles and permissions in Jira and its representation in Excel Connector