nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira Cloud - Import Data from Jira into Excel

Tony Clemente_0tfbly

This feature could be a time saver except it takes very very long to save the data after importing and the widget gets stuck "Saving..." for several minutes though the data looks to have been imported. It ends up being faster to just download a spreadsheet view from Jira and then cut and paste it into another Excel sheet than it is to use the widget, which is unfortunate.

Accepted answers

Jehan Bhathena

Hi @Tony Clemente ,

Welcome to the community!

Perhaps you can elaborate the question here? Not sure I understand which widget you've mentioned here.

Perhaps you can add some steps to reproduce the behavior where you get stuck on "Saving..." .

All comments

Jehan Bhathena

Hi @Tony Clemente ,

Welcome to the community!

Perhaps you can elaborate the question here? Not sure I understand which widget you've mentioned here.

Perhaps you can add some steps to reproduce the behavior where you get stuck on "Saving..." .

Tony Clemente_0tfbly

Hi @Jehan Bhathena

Thanks, I am not sure if this is more of an Excel issue than a Jira one. When using the "Get Jira Data" option from Excel:

Screen Shot 2024-01-31 at 2.34.00 PM.png

both online and on my desktop, the import seems to get stuck on "saving..." if there are more than a few hundred rows to import.

Steps to repro:

Create an Excel spreadsheet
Use the "Get Jira Data" option from the menu (authenticate with Jira)
Select the option to use a Jira "Filter" for Import type from the widget/sidebar
Choose a saved Jira filter to import that contains more than 400 rows (I do not have an exact number for you here) smaller imports (approx 100 rows) seem to work fine.
Click the "Get Data Now" button

Screen Shot 2024-01-31 at 2.34.19 PM.png

At the bottom of the sidebar you will get feedback as the import queues up, processes then saves. Ex:

Screen Shot 2024-01-31 at 2.34.53 PM.png

When the issue occurs the status there stays at "saving..." and seems to hang there. The sidebar/widget is greyed out and unusable in the workbook at this point.

Desktop information:

Mac OS 10.15.6
Excel 16.66.1
Excel online - browser Chrome v121.0.6167.85 (Official Build) (x86_64)

Jehan Bhathena

Hi @Tony Clemente

It is an issue with the plugin in Excel, I've faced it too quite a few times, what I usually so is:

Open Jira in an Incognito Browser session, and click on "Open in Excel"
Chose the Desktop option and wait for authentication
The New sheet should ask for authentication, and then let you connect to the needed site

You can google to see the past history of complaints for this plugin :-P

One post that might help : https://community.atlassian.com/t5/Jira-Software-questions/Jira-Cloud-for-Excel-Not-Loading/qaq-p/1940988#M663130

If this still doesn't work, I would suggest Clearing your browser cache, and also your PC's temp files(not sure how it works in Mac).

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud