jira cloud for sheets limitation

[sharmila leo]

How many maximum issues we can import into Sheets from Jira cloud

[Joseph Chung Yin]

@sharmila leo -

Welcome to the community.  By the default, it is limited to 1000 rows when one exports data from Jira to avoid possible performance impact to your site.  According to this reference Atlassian KB - https://community.atlassian.com/t5/Jira-articles/How-to-export-more-than-1000-issues-using-Google-Sheets/ba-p/1810436, it stated it can be up to 10000 rows via "Jira Cloud for Sheets" add-on.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

[MobilityStream]

Hi @sharmila leo ,

As stated above, with a workaround, Jira Cloud for Sheets can export up to 10000 issues. However, there are a many other problems with it. Atlassian basically 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. There is no limitation on numbers of issues exported. 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