...
Using filters
- Expand the combobox in the Filters section, choose the desired filter (1)
Click Get issues button (2)
If you need to update current Excel spreadhseet you may consider using "Append to existing issues" option (3). By doing so, issues are to be added at the bottom of a current sheet.
...
- Instead of expanding the combobox, just type your JQL query in there (number 1 below presents an exemplary JQL query: Reporter = admin)
Click Get issues button (number 2)
Presence of "Favourite Filters" from Jira in Excel Connector
Anytime you save your JQL query as a new filter in Jira (1) , you can find it Excel's Connector dropdown (2):
After selecting the filter and pressing "Get Issues" you will get the same amount of issues displayed, as in Jira itself.
...
You may want to download other issues using another filter but keep the ones you downloaded before. If that is the case just check Append to existing issues checkbox (marked with number 3 on the above picture) before you get other issues. As a result, the new issues will be simply appended below a last, filled line of your opened sheet.
...