Hey everyone! I'm the PM on the Jira Cloud for Spreadsheets team. We've been quietly working on a feature that will let you very easily export all of your worklog data so that you can: * Create project bills & invoices for your clients * Figure out how much to pay your employees or * Track how much time your teammates are spending on their work P.S. This functionality is also available on Excel as well! Once you've imported the data, you can refresh the data using our refresh feature to ensure that all the worklog info gets automatically updated!

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; } } }

Want to save 16 hours when you export worklog data from Jira?

Catherine Chang

Hey everyone!

I'm the PM on the Jira Cloud for Spreadsheets team. We've been quietly working on a feature that will let you very easily export all of your worklog data so that you can:

Create project bills & invoices for your clients
Figure out how much to pay your employees or
Track how much time your teammates are spending on their work

Screen Shot 2020-02-11 at 12.11.49 PM.png P.S. This functionality is also available on Excel as well!

Once you've imported the data, you can refresh the data using our refresh feature to ensure that all the worklog info gets automatically updated!

Accepted answers

All comments

Matt Doar_tzgiej

"save 16 hours" - how many issues and how many worklogs is this measure for?

Sara Dubuque

Hi Matt!

16 hours is an estimate based on some of our customer interviews. They said that the manual work they were doing to get worklog data, transform it into something useful to them, and do various calculations was taking them about 16 hours a week. This update allows them to skip those initial steps and saves a lot of time.

The actual worklog data import itself only takes a few moments.

If you give it a try, let us know how it works for you!

-Sara

Thomas Lübbeke

Hi, will this work with the data from tempo timesheets as well?

AlexC

Hi Thomas,

It will show some worklog related fields from Tempo such as time spent and created/updated date, but Tempo also seems to store part of its data outside of Jira which our add-on does not access. Give it a shot ... it may have enough data for you to run the type of reports you need.

Thanks,

Alex

YC Lian _ServiceRocket_

Hey Catherine,

Dropping a note to thank you and your team. I have been using this add-on in the past few months to solve different problems (e.g. gaining insights on multiple service desks), and today, I learned that it has solved the long desired Jira feature: getting time log of individuals within a specific period.

I'm happy to drop you guys/girls some beer if you can write to my email.

Cheers.

Foulques de M

From my experiences with Jira API, tempo seems to use jira worklogs as Jira would; so you should get what you need from it.

Angela Plater_6nycrz

Hey Jira Cloud for Sheets Team

Thank you for this integration!

Quick Question - how long does it generally take to get early access to this awesome functionality after signing up for it? Is there a notification I should be looking for? Is there a difference between individual user request vs domain install?

Thank you!

Catherine Chang

Hi @Angela Plater ,

The functionality has been released and you should be able to select worklog fields as you wish.

Thanks,

Catherine Screen Shot 2020-08-11 at 11.57.47 AM.png

Angela Plater_6nycrz

@Catherine Chang Awesome! Thank you!

Patrice Bazerque

Hi , I m trying to get monthly overviews of our worklogs through the sheet Addon.

Typical usecase : produce a report of epic spent times by Project / Epic / month

However it seems that filtering using JQL can only filter the issues, and not the worklogs.

As we have long-standing epics , when I query recently updated epics I get all worklogs from previous years , resulting in *timeouts* and un-necessary huge data in sheets.

I would need a way to get only recent worklogs , just as a direct usage of startedAfter ( https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-worklogs ) would allow.

PS: thx to the team for this otherwise awesome add-on !

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

tempo

tempo-timesheets

ms-excel

google-sheets

worklog

log

billing