Timesheet to Excel
Zeno Popovici
Right now you cannot export the time logged into a format which you can send to a client.
We built a Laravel App that uses ClickUp API to export a timesheet based on a selected period.
The App goes trough all open and archived lists and fetches the data, then orders it into a timesheet like the one attached, which we can send to our clients.
This is not ideal, also ClickUp API limits API calls and if you have a lot of tasks, it takes a while to generate it.
It would be also cool to export timesheets per tags or per person as it happens that design is charged differently for us.
All time tracking services are really expensive and do not integrate properly with clickup. The native clickup functionality works fine. If a timer would be available without an extension, but right now it works. We just need our data in a digestible format like the one below.
Log In
Anthoney Rimmer
I found this post searching for a way to get the timesheet data out of ClickUP in a raw format to do calculations for end of year projects. I found that I could export the raw data by using the dashboard for timesheets and in edit mode there is an export option that sends you the raw data in a spreadsheet. For my purposes I can then copy that raw data into a spreadsheet that does the calculation and summary magic to produce client or end of year reports.
K
Krysta Fox
Anthoney RimmerThank you so much. That is extremely helpful to me. I was so frustrated at not having an export option!
M
Mads Albertsen
Anthoney Rimmer It is nice that you can export raw data for the dasboard, but you get raw data and have to spend time to go through a lot of useless data, convert times and date and calculate and and. This is timeconsuming. There should be an export function in the new timesheet page where you can define what period and which data you want to export. It should also incluce weekno, month no, day of week, year.
Tran Thi Vui
Me too
D
David Goldwasser
I wrote a Ruby script using the API to initially dump time tracked to Ruby console organized by list. It does this for each day for the current week and the prior week. It would be easy to have this save to CSV or Excel file. Should be easy to filter or organize anyway you want, but some things would take more API calls than others. Since I use ClickUp just for myself, I'm not worrying about assignee but that can be added as well. https://github.com/DavidGoldwasser/clickup_api_scripts/blob/main/click_up_time_scrape.rb
P
Paula Dzik
I work at a marketing firm. We work with freelancers, who track their time in ClickUp. Different tasks have different fees. (I track the fees as tags.) When I exported, I had to manually convert the time from ClickUp lingo (2h 3 m) into Excel lingo (=2+3/60) so I could calculate their pay based on the different rates.