Worklog not being exported to Excel

ACD - Mauro Ransolin
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!
January 2, 2025

Hello,

 

When exporting data from Jira issues to Excel, the worklogs for issues (epics, stories, tasks) are no longer being exported.

Previously, I exported this data to retrieve the worklog.timeSpent field and others.

The query I used is simple and worked perfectly until December:

resolved >= 2025-01-01 ORDER BY key ASC

The current export result looks like this:

Tipo de itemChaveStory point estimateStatusAtualizado(a)ResponsávelRegistro de Trabalho.authorDisplayNameRegistro de Trabalho.timeSpentRegistro de Trabalho.timeSpentSecondsResumo
BugHW4-12340Concluído02/01/2025 16:09Lucas   Refatorar Map e List de PlaceStore.lastTransmission
TarefaHW4-12350Concluído02/01/2025 16:17Mauro   Acompanhamento Sprint

Why has the export of worklogs stopped working?

Thank you for your assistance.

Best regards,
Mauro Ransolin

2 answers

0 votes
Zoltán Gombos
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!
January 6, 2025

I'm having the same issue. A simple query worked till end of last year and from January 2025 Log Work value is not available in excel. (Log Work values entered in 2024 are correctly exported, only logged work in 2025 is not visible.)

Zoltán Gombos
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!
January 7, 2025

Wow, from one day to another it has been fixed. Probably there was a bug on Atlassian side. With no changes on my side (in jira query or excel-jira connection) this morning excel export contained the Log Work.timeSpentSeconds values.

Like Valerie Knapp likes this
0 votes
Valerie Knapp
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 3, 2025

Hi @ACD - Mauro Ransolin , welcome to the Atlassian Community and thanks for your question.

You are showing here the Excel export, correct?

Do you see the data displayed in Jira? Please can you confirm?

I had seen some other posts about people having problems with the Excel extension https://marketplace.atlassian.com/apps/1221301/jira-cloud-for-excel-official?hosting=cloud&tab=reviews 

Have you tried / can you try instead to just export as a CSV and open in Excel to see if that resolves the issue?

Please reply here if you have other questions or doubts.

Cheers

Suggest an answer

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

Atlassian Community Events