Skip to main content

How to mass upload attendance

Updated over a week ago

This tutorial describes how you can upload check-in and check-out times in bulk.

To update the check-in and check-out timings in bulk, please follow the below steps:

Go to Settings > Attendance > Biometric Data > Start

You can upload biometric data in 2 ways:

A. Either you can enter the check-in and check-out timings directly on the platform. Close the dialog box if you wish to enter the data directly on the platform by clicking on the X icon, as shown below.

B. Or you can upload it via Excel. To do this, click on the Download Excel template, as shown below.

A. Entering the data directly on the platform

You can manually enter check-in/check-out data directly on the platform by clicking the “Add Row” icon, as shown below. This allows you to insert new entries for employee attendance as needed.

Double-click on the Employee Name cell to open a pre-fetched list of employees.


Select the relevant employee from the list to begin entering their biometric data.

Enter the check-in date and time by double-clicking on those cells against the employee's name.

Select the check-in date from the calendar, as shown below:

Select the check-in time from the clock as shown below:

Similarly, enter the check-out date and time.

Once done, click on Save

Once the data gets saved, you can either choose to Go to the attendance report or Add more data.

B. Uploading the data via Excel

In case the data is huge, for eg. you want to upload check-in and check-out data for the past one or two months, then you can do so by downloading the Excel file and entering all the data in Excel and then uploading that Excel back to the platform.

Click on Download Excel template

Once you download the Excel file, simply input the data using the same format as shown in the downloaded sheet.


This ensures a smooth and error-free upload back into the platform.

Note:

  • Employee names in Excel can be selected from the drop-down.

  • There are validations for each cell.

  • Check-in time can not be higher than check-out time.

  • In the case of upload, the dates should be in DD/MM/YYYY format.

  • The time format should be entered in 24-hour format (e.g., 14:30 for 2:30 PM) to ensure proper validation and processing.

Once done, you can upload the updated Excel to the platform by clicking on Upload Excel file and then click Save.

Note: If you try to enter the data for the same set of employees for a date where they have already checked in and checked out, then the check-in and check-out times will get overridden by your data.

Did this answer your question?