Overview

ease Office for Jira (O4J) is a native Jira app that is installed in your Jira system by a Jira administrator. The Excel to Jira integration Add-In is a Microsoft add-in that works with O4J to load Jira issue data into Excel and upload modified Excel data to Jira. The Excel to Jira integration Add-in allows the user to work with Jira issues in Excel, while the authoritative source of the data remains the Jira instance.

Key elements in the data exchange supported by O4J:

• Loading issues into Excel from Jira using various filter options.

• Uploading modified Jira data from Excel back to Jira.

• Create Jira issues in Excel and upload them to Jira.

• Compare and refresh data in Excel.

Key Features

• Set up connections between Excel and Jira on Server, Data Center and Cloud instances.

• Load data from Jira by selecting a project, a saved Jira filter or by providing an expression in JQL (Jira Query Language). Fields to be retrieved are selected from a list. A refresh option loads the latest data from Jira.

• Support for various Jira field types, including link relations, multiple selection fields and comments.

• Check data stored in Excel against Jira and review differences with the Excel comment function.

• Upload modified fields to Jira.

• Create new issues in Jira, including the creation of sub tasks.

• Supports R4J - Requirements Management for Jira tree structures.

• Supports T4J - Test managements for Jira test steps in test cases.