Time Tracking Log (csv export or change the look of the file)

[magla021 (Danijel)]

Hi Monday.com team. Love the work that you are doing and I’m finding new ways to implement in our organisation. What I would love to see is a different format of time tracking log. Currently this is how the Time Tracking log looks like (see image below).

And this is how I would like it to looks like.

But in the end what would be perfect is that time tracking log would either give you csv export of time tracking log with following information:

• Pulse Name
• Started By
• Ended By
• Start Date
• End Date
• Start Time
• End Time
• Duration

In other words you get one heading row and all necessary information below which you can then easily use for other reporting or billing purposes.

Hope this feature will soon see the light of day.

And the last but not the least important. I love the work that you done and constant improvements. Keep up the good work.

[PLingows (Peggy Thomason)]

@BenP-monday.com
Is this something that we’ll get soon? Our company is currently spending 8 hours a week to extract the data from the excel spreadsheet in its current format. The suggestion above would be a perfect solution. Thank you.

[hlopezvc (Hernan Lopez)]

Hi, if you want to add your feedback here, this post is from 2019

Improvements on Time tracking column

Hello Monday We are trying to use the timetracking column and (for what i have read in the forum) there are things that still are not solved, critical to us for using this column and not other ways (secundary boards, etc). I mean timetracking column is the perfect answer for timetracking, but if is not improved, it cannot be efficient to use it. Add manual sessions without specifying hours and minutes, i mean, only hours worked. Add android App capabilities to add manual se…

[llevito (Leslie Levito)]

If only they would change the way data exports as you suggest… then we could do whatever we want with the data in Excel!!

[Yoggie (Yogev David)]

Hi @magla021 , @PLingows & @llevito !

I think you can use Monday CSV Converter as it will give you a URL with a CSV of the current state of a board.

Then, you can link it to a google sheet.
There’s more info about this here.

Also, you can set the spreadsheet to refetch the CSV from the URL in predetermined intervals using the sheet’s script editor, this is not mandatory though as it will refetch the data from Monday.com every time you open the sheet, or repaste the link.

[llevito (Leslie Levito)]

Oh wow THANK YOU! This works great to get all the tasks into the Google spreadsheet but it doesn’t seem to pull each and every time the task is logged to in the Tracking column.

Did you or your company create this converter? Is there a way to email each other?

[Yoggie (Yogev David)]

Hi @llevito !

Yes I’ve built this tool, and yes you can set a function on your google sheet to reretch the board data every hour or so.

You can reach me at Yogev@Formrally.com

[HannahKnight]

This would be a great feature to add @monday-team !
We are also looking into ways to export the data in a much clearer format. Being able to extract line items/tasks with time logged then being able to filter said data without too much admin would make our Monday experience much better! It’s currently one of the biggest hangups we have with it compared to our current system.

Do we know if this will be looked at?
Thank you.

[gcmcpa (Grace McKay)]

Same here - It takes me hours to extract the data since the csv exports are not very usable. I use the time tracking for client billings and payroll and since the time format in the csv export is not in a numerical format it does not sum in excel - I basically have to re-key in all the time again just to add it up. The multiple heading rows in the time tracking report is frustrating because I need to reformat the sheet just to sum the data. While it is really handy to be able to track time by task, the data export is really not usable at this point. I really hope there can be some improvements on this. Thanks!