Use Jira Cloud for Sheets | Jira 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).