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 total number of issues, they can be broken down in batches and then imported. Example first 1-1000, then 1001 to 2000 issues can be imported as so on. 

To do so following syntax should be used : 

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

Example : 

• To import issues from 0 to 1000 where project = AV

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

• To import issues from 1001 to 2000 where project = AV

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