Use Jira Cloud for Sheets | Jira Software Cloud | Atlassian Support

Jira Cloud for Sheets lets you import Jira data into your spreadsheets using existing Jira filters or custom Jira Query Language (JQL).