Why is 'Jira for Excel' returning duplicate rows?

Mark Ericson September 1, 2023

When I use the 'Jira for Excel' add-in I sometimes get duplicate rows in my target sheet.  Even when I clear everything in the sheet before reloading data from Jira, the plugin returns duplicate rows.

It isn't just random duplicate rows; when there are duplicates, it is consistently the complete results appended consecutively in the sheet.

An additional oddity is that the results are sometimes correct, and it is one result, but sometimes it is two complete sets and even four complete sets of the results.

7 answers

1 vote
Dale Jordaan
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 11, 2023

I have to exactly the same issue. You can literally divide values by half and get the correct answer. 

 

I have tried all of the above. I also used a new sheet altogether. After a few refreshes it happened again to the new sheet. Now I have to start from scratch every time and change pivot table sources etc 

 

Very frustrating 

Mark Ericson September 12, 2023

Yes, it is very time-consuming for me to set up the set of fields and order of fields when starting with a fresh workbook.  And then, as you mentioned, fix up the formula and pivot table references for the data for the new sheet.

Siddharth Thirumalai
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 26, 2023

I encountered the same problems with my sheets to Google sheets connector. I noticed that in the connector plug-in window, I had previously selected quite a few fields  (around 30) and this issue keeps happening. I then tried reducing the number to a few key columns (around 19) and this issue doesn't recur. YMMW but I thought you might want to check this and see if this addresses the issue until a more permanent fix is provided by the plug-in providers.

1 vote
Diana Valencia
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 5, 2023

I've noticed it happens to me only when I have the Updated field as part of my columns. Maybe it's showing a register for every time the issue is updated?

Mark Ericson September 12, 2023

@Diana Valencia I see the same behavior even when I remove the Updated field.

Jasmine Anderson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 9, 2024

Same for me, this is super aggravating 

0 votes
Dale Jordaan
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 23, 2024

Thanks - What i do now is I whack sheet 1 so it's empty, then select A1 and refresh. Seems to work

 

0 votes
joseluis.bonilla
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 23, 2024

Hello, it happend the same to me until I found that I was adding "Comment.Updated" instead of "Updated". I changed it and the duplicated rows dissapeared.

I hope I have helped you.

0 votes
Norah Medlin
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 14, 2024
0 votes
MobilityStream
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 12, 2023
Both exporter add-ons "Jira Cloud for Excel" and "Jira Cloud for Google Sheets" have known issues and have been put into de-facto maintenance mode by Atlassian. If you are looking for something more reliable and are open for a marketplace app, you can try our Excel Online integration which works both for Excel Desktop as well as Excel Online. It doesn’t have any issues with duplicated rows. Also, it scales to a large number of Jira issues and supports real-time, schedule, and manual exports.
Kind regards,
The Mobility Team
0 votes
Brant Schroeder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 1, 2023

@Mark Ericson I would suggest submitting an support ticket to the vendor of the app https://marketplace.atlassian.com/apps/1221301/jira-cloud-for-excel-official?tab=support&hosting=cloud 

Mark Ericson September 3, 2023

The vendor of "Jira for Excel" is Atlassian.

Brant Schroeder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 4, 2023

@Mark Ericson If you are just using the delivered product then it is not an add in.  Can you share some steps and screenshots of what you are doing when this issue occurs?

Mark Ericson September 4, 2023

It is an Excel add-in provided by Atlassian. I click refresh and sometimes I get one copy of the results, in the sheet, sometimes two copies, and sometimes four copies.  When I get multiple copies I get a new header and all the rows each time.

Screenshot 2023-09-04 at 9.28.02 PM.png

Brant Schroeder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 4, 2023

@Mark Ericson can you provide the steps that you are taking.  Example:

  1. Open Excel
  2. Use Jira add-in to connect to Jira and setup parameters
  3. Click get data
  4. Data is imported and is ok

Are you using the same sheet multiple times and is that when it adds additional rows, when refreshing data?

Mark Ericson September 5, 2023
  1. I open my workbook in Excel,
  2. I go to the sheet where I always load the latest Jira data
    • I use the same sheet because other sheets have pivot or lookup references to the sheet
  3. I clear all the existing data in the sheet
  4. I open the 'Get Jira Data' Excel add-in
  5. I click 'Get Data Now' to load the latest data from Jira

The data for my JQL query is currently about 2149 rows. For months, this has worked just fine.

A few weeks ago, I started getting duplicate results in my sheet.  Currently, I am seeing Jira loading four sets of the same data, each with its header row.

Brant Schroeder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 5, 2023

@Mark Ericson Once you connect the sheet you should just be able to refresh the data.  What happens if you use a new Excel file and connect to the data?  Do you only get one set of data?  What happens when you refresh?

Mark Ericson September 12, 2023

@Brant Schroeder After a few refreshes, the duplicate behavior starts occurring.  It is time-consuming to start with a new Excel file because I need to construct the query and the set of fields and order I need to be returned in Excel.  At least the JQL is cut & paste; I can't say the same for the included Fields and order.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events