General - Import
Import Jira issues using favorite Jira filters or build JQL expressions.
You can even save your JQL expression as a new filter.
When issues are imported you can edit available fields.
With Refresh button you can check Jira for any updates in imported issues.
Import is the first section of General view of Excel 365 Connector.
It’s marked green color on the below screen.
Import modes:
Standard mode
You can import issues:
From Jira filters
By building personalized JQL
Importing issues using Jira filters:
In active “Filter” tab view. (1)
Select filter from dropdown. (2)
Displayed filters are your favorite filters in Jira. To make filter favorite click a star icon next to its name in Jira.
To refresh list of favorite filters use the refresh icon on bottom of filters list. (3)
Use the “Import” button to fetch issues
Use saved column order
A Jira filter can remember the order of its columns. Turn on Use saved column order to import issues with the columns arranged exactly as saved on the selected filter — without changing which fields are shown.
The checkbox is active (3) only when the selected filter (4) has a saved column order.
It is greyed out (1) when the filter has no saved column order, for default/system filters
Import issues using JQL:
Select JQL tab. (1)
Input JQL language expression. (2)
Please note that when switching from the Filter tab to JQL, the selected filter will be automatically translated to JQL, allowing you to make changes smoothly.
Optionally: you can save your JQL expression as new Jira filter. (3) General - Import | Saving JQL expression as filter from Excel 365 Connector
Use the ‘Import’ button to fetch issues (4)
In both of these method final step is to click “Import” (1) button to fetch issues. All issues matching criteria will appear on the sheet, with default set of columns.
If you find the need to update the current view, the "Refresh" (2) option can be a valuable tool. Additionally, it proves useful in the event of an error during data editing in the spreadsheet, allowing you to reset or reload the information for accurate and up-to-date records.
After importing data to Excel, connection icon will change:
From Not Managed (3)
Into Managed (4)
Connection icon indicates that there is a metadata available for currently active worksheet
Another thing that appears after importing issues is the Last used filter (1). If the data was imported by using JQL tab view, the Filter from JQL label will be displayed (2)
After Excel will restart, if the issues were fetching through the Filter, the Last used filter it will be displayed as the active filter(1), if by the JQL - will be open with label name: Filter from jql (2). After clicking on the name it will open the JQL</> tab with a last used query.
When app is open for the first time on worksheet, then first ‘Reported by me’ filter will be open with no Last used filter label.
If new sheet or app is open for the first time on, then first “Reported by me” filter will be open with no Last used filter label.
The Last used filter will be kept until the data is re-imported.
To check for updates in presented on sheet issues → Use the Refresh (1) button (eg. 20 issues visible, it will check only those 20 issues)
To check for new issues → Use import feature (eg. filter returned 10 issues, but new issues were created and it should show 15 issues)
Tip 1: It is a good idea to check for updates, before making your own changes. Especially, if you didn’t make any changes for a while, because your data might be outdated.
Tip 2: Consider adding ‘fetch fresh issues’ to your routine, when you open the spreadsheet.
Tip 3: You can always open a new worksheet and check for the filter/jql results.
More info : Refreshing sheet
Saving JQL expression as filter from Excel 365 Connector
When you build your own JQL to find related issues, you can use an option ‘Save as filter’, to use it in future. In the pop up window you need to add a name for your new filter (1), then set the checkbox responsible for Favorites (2) and click Save (3).
This way you created a new filter in your Jira instance.
Read-only mode
If you choose read only mode, you won’t be able to edit imported issue.
Use this option to analyze large sets of data, limit is 100 000 issues.
Before clicking Import you can set checkbox ‘Read only’ (1).
When you import issues to sheet without ‘Read only’ checkbox, this checkbox will disappear - to avoid data mismatch.
Fetching issues in read-only mode allows you to pull raw issue data from Jira. Be aware using this mode, that worksheet will not be managed by Excel 365 Connector and changes will not be tracked. Therefore you won't be able to send any changes to Jira.
Enabled (5) only when the selected filter has a saved column order.
Refresh (2) button is disabled in this mode, you are only able to view your issues (4) after clicking Import (3).
With Update 2.4.0 EC365 has received Excel dropdown list support .Dropdown list support
Unbound JQL in Jira Cloud
In Jira Cloud, a Jira Query Language (JQL) query is considered unbound when it is not constrained by required search boundaries. This usually happens when a query is too general (e.g., missing filters, project scope, or other constraints), which can lead to lower performance or the query failing to execute.
If a user has a saved filter containing a JQL query such as ORDER BY key (1), it is treated as unbound when used in the application. This means the query does not include sufficient search constraints and therefore cannot be used outside Jira until it is updated to include proper limits.
When navigating to the filter selection dropdown, unbound filters appear in the list but are disabled and cannot be selected (2). They remain blocked until the JQL is updated in Jira.
Hovering over a disabled filter shows a tooltip explaining the restriction (3)
In the JQL tab, a warning icon (4), indicates that unbound queries are no longer usable in their current form and require updates in Jira.
Clicking the icon opens an informational modal (7) provides additional details and a Learn more button (8), which redirects to Improve Jira issue export experience due to JQL search API.
If a user tries to import an unbound JQL manually via the input field (5) and the Import button (6), the operation is blocked and a validation error popup is shown (9).
What next? After you import issues you can edit them or create new issues. To send those changes to Jira you need to export changes: General - Export