How to use JIRA() function to import large number of issues with JQL in MS Excel

Summary

There is a limit of 10K issue that can be imported using Jira plugin in MS Excel. If more issues needs to be imported, Jira functions with JQL can be used to import more issues.

Environment

• Jira cloud

• Jira Cloud for MS Excel

Solution

Instead of directly specifying the total number of work items, the list can be broken down into batches and then imported. This batching must be performed in JQL, as it's not possible to specify a starting index for imported work items into a spreadsheet.

To do so following syntax should be used: 

=JIRA.JQL("project= <project Key> order by key Asc", "", <number of issues to be imported>)

For subsequent batches, you can specify the creation date of work items, and test the returned total in Jira to ensure that no more than 1000 work items are returned at a time. Once the query returns a sufficient number of work items, you can use the JQL query in the spreadsheet.

Example : 

• To import the first 1000 issues where project = AV

  • =JIRA.JQL("project= AV order by key Asc", "", 1000)