You can do it in two different ways:
Using your filters saved in Jira
Click Get Issues button (2)
If you want to update your current sheet and leave your changes intact, use Append to existing issues option (3). By doing so, new issues will be added to the bottom of the sheet without removing those you already have.
Each time you press Get issues button the following prompt will appear:
This indicates that data is being loaded from Jira to your sheet and you will soon see it begin to fill.
2. Using custom JQL queries
Click Get Issues button (2)
If you want to download issues from sevral different filters or JQL querries at the same time just check Append to existing issues checkbox (marked with number 3 on the above picture) before pressing Get Issues button. New issues will simply be appended to the end of your issue list.
You can find each JQL query you save as filter in Jira (1), in Excel's Connector Filters dropdown (2):
After selecting filter and pressing "Get Issues" button, you will get same issues in Excel as from filter in Jira.
The following scenario is an example of creating JQL query in Jira, and then using the same jql querry to import your issues to excel.
3. In order to use and view JQL queries switch to advanced search:
4. Type your JQL querry. Tips will appear in the drop-down below text field when you start to write, showing all comands starting with typed letter.
For more information about syntax, please refer to Syntax Help at the bottom of the drop-down → https://docs.atlassian.com/jira/jcore-docs-076/Advanced+searching.
4. When writing correct query and pressing Enter results will appear in the window below.
As you can see in the images above and below results of JQL "type = Bug AND assignee = admin" are the same.
5. After you pulled the metadata from Jira (by creating a new issue or by pulling issues from Filter or JQL), you can get issues just by typing their issue key in the 'Key' column and pressing 'Refresh issue' from the ribbon. Here is an example:
Pulled issue