Question: how to import data from jira to excel?
Answer: Login to jira.mycompany.com.
Selected Export dropdown menu.
Right-clicked on the CSV (Current fields) option and select Inspect.
Open Excel Workbook.
Select the Data tab.
Select Get Data -> From Web.
Pasted the CSV URL in the Web Address box (Basic selected), clicked OK.