When you use Excel Connector on Jira Server or Data Center, then you have an option to export data from Jira with Excel Connector Export feature - it allows to get data from Jira, then log in from within Excel and work on tasks. Here is an example how to do it
Previous: 14. Color legend - data validation
Next: Start using it. That’s all 
! Thank You!