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


To import timesheets into WorkGuru


  1. Create or modify an exisitng timesheet export to match the WorkGuru timesheet import template.   Import template fields descriptions:
    1. User - WorkGuru username of the staff member the timesheet will be attributed to.
    2. Project - Project number the timesheets will be imported to.  Project number must already be in WorkGuru
    3. Task - Project Task the timesheet time is being assigned to.   The task MUST already exist on the project or an import message will appear.
    4. Length - Total number of hours in a decimal format.
    5. Date - Date timesheet entry occurred. Must be DD/MM/YYYY format.
  2. Go to the timesheets dashboard and click the Import Timesheets button.
  3. Click Choose file and select the timesheet import template
  4. Click Save to import timesheets.