HRStop makes it easy for admins to upload employee attendance in bulk using a CSV file. This feature helps save time by allowing quick import of multiple attendance records.
Available CSV Formats for Upload
You can upload attendance using any of the following formats:
-
Format 1: Based on Attendance Status
In this format, you need to include fields like Employee Code, Email ID, Enrollment Number, Attendance Date, Punch Time, Source (like Web, Mobile, etc.), and Status (Present, Absent, etc.). -
Format 2: Based on Time In and Time Out
This format requires details such as Employee Code, Email ID, Enrollment Number, Time In, and Time Out. -
Format 3: Based on Punch Times
This format is useful when employees have multiple punch entries. It includes fields like Employee Code, Email ID, Enrollment Number, and Attendance Punch Time (you can enter multiple punch entries).
Tip: You can download sample files for each format from the system, edit them as needed, and upload them.
Steps to Bulk Upload Attendance:
- Go to: Control Panel → Attendance
- Click on the Import button in the navigation bar.
- On the import page, review the instructions provided on the right.
- Download the sample CSV file in your preferred format.
- Edit the CSV with the necessary attendance data.
- Choose the Import Type (Daily / Monthly).
- Click Choose File to upload your CSV.
- Select the correct Date Format that matches your file.
- Click Preview & Upload.
- Map Fields: Match system fields with your file’s columns.
- Click Preview and then Upload to complete the process.
- Scroll down to review uploaded data. Any rejected records will show the reason under the Reason column.
All changes will be reflected instantly after a successful upload.