I am not able to import issues from Jira into excel.

[sarvotham.chenji]

I use 'Get Data' -> 'From Other sources' -> 'from Web' option in Excel. I give the below URL

"https://acsjira.honeywell.com/sr/jira.issueviews:searchrequest-csv-current-fields/158751/SearchRequest-158751.csv" 

to get defect/issue data from Jira. But what I get is html script. I googled and found a suggestion to append '?' at the end of the URL. By doing this, I am prompted to key-in Jira login id and password. I choose the option to use my Windows login credentials. When I click on 'Ok' button, nothing happens. And if I click on 'load' option, I see hour glass and then the request times out. How to resolve? 

[Daniel]

Any update here? I'm facing the same problem.

[Nic Brough -Adaptavist-]

There is something not set up correctly in your Excel importer.  Check the user credentials and that the network is connecting ok.

[Ganesh Babu]

Hi @sarvotham.chenji 

Are you trying to import issues to jira from excel?

Please find the  document 

https://confluence.atlassian.com/display/JIRA062/Importing+Data+from+CSV

[sarvotham.chenji]

No, I am trying to import from Jira to Excel, not from Excel to Jira

[Ganesh Babu]

It's Export 

Go to issue navigator, Create a jql query and there in the corner you can see view menu item and there select excel(all fields) option to export all issues to excel

[sarvotham.chenji]

Ganesh, I request you to read my problem statement again. I know how to write a JQL query and I also know about the export option using which one can export. What I am not able to get working is, from within Excel 2016, I use 'get data' from 'Web' option where I give the URL. But excel fails to get data from Jira