Access Jira in Excel

Issues

  • JQL Search - Searches for issues using Jira Query Language.
  • Lookup - Returns a specific issue by Id or Key.
  • Comments - Returns all comments for an issue.

Projects

  • List - Returns all projects which are visible for the currently logged in user.
  • Lookup - Returns a specific project by Id.

Users

  • Search - Returns a list of users that match the search string. Available settings:
    • Include or exclude Inactive Users

JQL Examples

Queries are a series of simple elements strung together to form a more complex question. A query has three basic parts: fields, operators, and values. Read this official guide for a complete walkthrough

Example 1: This will only return issues that match both clauses (are part of the Collaboration project and have their status set to "In Progress")

project = Collaboration AND status = "In Progress"

Example 2: Returns all issues from either the Collaboration project or that have their status set to "In Progress".

 project = Collaboration OR status = "In Progress"

Example 3: What issues are blocking or critical in Projects A, B, and C?

priority in (Blocker, Critical) AND project in (ProjA, ProjB, ProjC)

Access

Add from Manager

The Jira Connector is available in the Connectors Manager in the top ribbon:
Manager position in main ribbon

Head over to the Programming Category and install Jira:
Connector category in Manager window

Credentials

To use the Jira Connector you need to enter your username, password and Jira base URL in the Settings menu.

The Base URL is specific to your account and is generally in the form www.foobar.com/jira or jira.foobar.com.

Paste credentials in Excel


Contribute

This connector suite is open-sourced on GitHub.


See

Official Documentation

Resources


Get help with this function in the community →