How to Import users to access control using excel

How to Import users to access control using excel

Adding users to an access control system one at a time can be repetitive and time-consuming. Using Excel allows you to prepare multiple user records and import them into the system more efficiently.

Follow the steps below to export the required Excel format, enter user details, and import the file into Access Control.

Step 1: Export the Excel Template

  1. Open the Access Control system.

  2. Navigate to Configuration > Personnel.

  3. Select Export to Excel.

  4. Save the exported Excel file to your computer.

Important: You must add at least one user to the system before you can export the Excel file. The exported file provides the required format for importing users.


Step 2: Open the Excel File

Open the Excel file you saved in Step 1.

Use this file as the template for entering the details of the new users.



Step 3: Enter the New User Details

Follow the format of the existing user record when entering new users.

For each new user, enter:

  • User ID: A unique identification number for the user.

  • User Name: The name of the user.

  • Card Number: The RFID card number, if available.

Make sure the information follows the same format as the existing user record in the Excel file.


Step 4: Save the Excel File

After entering all the new user details, save the Excel file.

Ensure that your changes are saved before proceeding to the import process.

Step 5: Import the Users into Access Control

  1. Return to the Access Control system.

  2. Navigate to Configuration > Personnel.

  3. Select Import.

  4. Click OK when prompted.

  5. Browse for and select the Excel file containing the new user details.

The system will then import the user records from the selected file.