Jira Cloud for Sheets not importing filter data

Question

I'm trying to use the Jira Cloud for Sheets extension, by trying to import the results of a filter using both JQL Query or Filter, and can't seem to download the data as I keep getting the following error: "Hmmm ... looks like we stumbled a bit, please try again or contact Atlassian support if the issue persists. (§EN-510)". Also, I cannot seem to download the data via an Excel document either :(

MobilityStream · Answer

Hi @delfina.viotti

Atlassian transitioned Jira Cloud for Sheets to maintenance mode, with enhancements discontinued, in summer of 2022 (background here). This has resulted in many user-reported issues and increased system unreliability. The user community is full of post by users that lose connectivity, see frequent errors (503 and others), experience various data issues (duplication, missing data, etc.) If reliable exports are important to your business, we recommend to try our Google Sheet Integration add-on. It works fundamentally different by exporting directly out of Jira via API calls. It is much more reliable and used by the largest organizations. Exports can be one-time, scheduled, or real-time You can also export much richer data to create more sophisticated reports (Assets, Changelogs, Projects, Sprints, Users, etc.). Everything directly controlled within Jira. Give it a try.

Kind regards,

The Mobility Team

Hannes Obweger - JXL for Jira · Answer

Hi @delfina.viotti

welcome to the community!

Does the problem still occur?

Unfortunately, Jira's Google Sheets and Excel integrations appear to be brittle at times; if you search this community, you'll find a number of posts about various kinds of (sometimes temporary, sometimes permanent) problems.

Just as food for thought: If you are open to solutions from the Atlassian Marketplace, there are many alternatives available. Depending on your exact use case, you may even want to consider whether you need to sync back and forth between Jira and Google Sheets at all, or whether you could do all your work in one place, just Jira.

E.g., you may want to have a look at the app that my team and I are working on, JXL for Jira. It's a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. JXL also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. This is how it looks in action:

This all happens directly in Jira, using your Jira data - so whatever you chose to do in JXL, your view is always live and fully synchronised.

Any questions just let me know,

Best,

Hannes