Skip to main content

Upload timesheets with Timesheet Uploader plugin

Upload timesheet data in bulk from a CSV file.

J
Written by Joshua Shooter
Updated over 2 months ago

With the Timesheet Uploader feature, as a PeopleHR administrator, you can upload employees' clock-in and clock-out data as a timesheet on the employee's planner.

To use this tool, follow the steps below:

  1. Enter your clock-in and clock-out data in an Excel worksheet then convert it to CSV format.

  2. Create an API key containing all the Employee and Timesheets endpoints then copy it.

  3. In PeopleHR, click Plugins then click New Requests.

  4. Click Timesheet Uploader.

  5. Fill in the new request form. We described each field in the table below:

Field

Details

Enter API key

Paste your API key.

Employee ID (column no)

Type in the column number where you entered the Employee ID.

For example, if this is column second in from the left, usually shown as column B, you'd enter 2.

Time In (column no)

Type in the column number where you entered the Clock In or Time In.

The time format is HH:MM. For example, 17:30.

Time Out (column no)

Type in the column number where you entered the Clock Out or Time Out.

The time format is HH:MM. For example, 17:30.

Timesheet Date: (column no)

Type in the column number where you entered the Timesheet date.

The date format is DD/MM/YYYY.

CSV row (where data starts)

Enter the row number where the data begins. In most cases, columns have a header matching the fields name in PeopleHR.

CSV Timesheet File

Upload the timesheet CVS file.

Review the information above then click Submit.

  • To view the most recent requests, click Requests. It can take up to two minutes to be accepted.

  • If successful, to download an audit of this action, click Download.

  • If failed, to view an error report, click the red log image.png icon. If you can't resolve the errors, get in touch with us and quote the name of this article.

Did this answer your question?