Search Knowledge Base Articles

Import Timesheets from CSV/Excel files

With this form, when you need to edit the working hours of an employee, you just need to edit it in the csv/xlsx file and import it back into the system.

  • Step 1. Go to Timesheets settings under Timesheets & Leave module from the left sidebar -> click on the Import Timesheets from CSV/Excel files -> click on the Save button 

  • Step 2. Go to the Attendance menu under Timesheets & Leave module from the left sidebar -> click on the Import timesheets button 
  • Step 3. To ensure successful import (correct format, full columns) you should download the template file by clicking Download a Sample button
  • Step 4. Enter the data you need to import into the downloaded file and save it. 

    Staff ID column: get id from Settingsmenu -> Norms of Leave  page

  • Step 5. Click the Choose File button under Choose excel file and choose a file  -> click on the Save button 

Did you find this article useful?

Related Articles

  • Permission

    Users can access the modules based on their permission. Admin: has unrestricted access to all the ...

  • Type of Leave

    Used to create leave types not available in the Timesheets & Leave module. This data will be u...

  • Timesheets Settings

    Setting timekeeping according to Manual or Task or import csv/xlsx file and select the roles to ap...

  • Setting

    Set the methods related to attendance, Google Map API key, configure the start month for annual le...

  • Norms of Leave Setting

    Used to configure the maximum number of leave days in the year and manage the remaining leave of a...