Skip to main content

Importing Employees from an Excel File

Written by EZTIME SUPPORT

Overview

Importing employees from an Excel file allows you to quickly add or update multiple employees in the system at once, including filling in important fields in the employee profile and general details.

Please note: This action requires accuracy — entering incorrect data may overwrite existing information in the system.


Step 1 — Download the Sample File

Go to "Employee" and click "Employee List". Click the "Import Employee Data" button and download the sample file.

The file format is CSV — make sure to keep it in this format when uploading to the system. The first row contains the column headers and must not be changed or deleted.

Please note: The "Import Employees from Excel" window also includes an option to manually enter employees directly from within the system.


Step 2 — Fill in the Details

Enter the employee details in the file according to the columns.

Please note: The "ID" field (ID number) is the unique required field — all data is entered based on it. If the ID number already exists in the system, the existing employee's details will be updated rather than creating a new employee.


Step 3 — Upload the File

Once the file is filled in, go back to "Employees" → "Employee List" → "Import Employees from Excel" and select the file you filled in.

After uploading, a preview window will appear showing the data. If there are any errors in the file, the problematic cells will be highlighted in red — you can correct them directly in the window or fix the file and re-upload for review.


Step 4 — Verify the Data in the System

Once you have confirmed there are no errors and have completed the upload, go back to the employee list and verify that the new and updated employees have been loaded correctly with no missing information.

Did this answer your question?