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