...
Use basic or advanced search to filter a list of issues in the Jira Issue Navigator.
Locate the Google Sheets button export action at the top right of the Issue Navigator screen. This button appears differently depending on whether you are using Jira Cloud, or Jira Server/Datacenter:
Jira Cloud
Find the Google Sheets item in the Export menu at the top right of the Issue Navigator:
Jira Server/Datacenter
Find the Google Sheets button at the top right of the Issue Navigator:
Field Selection
Select the standard and custom fields that you want to export
Hit Click the export button
Google Sheets
On the next screen the spreadsheet is displayed
You can edit and share the spreadsheet as usual
