WorkGuru supports importing timesheets into projects via a import spreadsheet template.  This is handy if you capture your timesheets in a third-party system but still need to track time on projects.  Importing timesheets is managed from the timesheet dashboard.


Create or modify an existing timesheet export to match the WorkGuru timesheet import template.   Import template fields descriptions:

UserWorkGuru username of the staff member the timesheet will be attributed to.Required
ProjectWorkGuru Project Number the timesheet will be attributed to.Required
TaskProject Task the timesheet time is being assigned to.   The task MUST already exist on the project or an import error message will appear.Required
LengthTotal number of hours in a decimal format. Eg: 15min = 0.25.Required
DateStart date and time (daily) or date (weekly) timesheet entry occurred. Must be "DD/MM/YYYY HH:MM" format.  Note: If you are using the weekly timesheet method, HH:MM is not required.Required


From the timesheets dashboard and click the Import Timesheets button.

Click Choose file and select the timesheet import template.  Click Save to import timesheets.

The timesheet will be imported.  If you are using the daily timesheet method, the finish time is calculated from the start date/time + the duration.