Import access control user information
To more efficiently add or modify multiple access users simultaneously, you can upload a comma-separated value (CSV) file (that contains user information) to Command.
Note: Bulk importing requires Access Admin permissions.
In Verkada Command, go to All Products > Access.
In the left panel, click Access Users and Groups.
Click Manage > Import Users.
(Optional) Click Manage > Export Users to download the CSV of your existing users as a base for your import file. The format used in the export file is not the same as the import file. Use this option when you want to modify existing users.
(Optional) Click Manage > Import Users > Download to download the template CSV file and enter user information. The exact headers (case-sensitive) that are present in the template must be used in your uploaded CSV file.
Select the CSV File and drag and drop the file into the box.
Once uploaded, any errors or warnings regarding the upload of the file display. Errors must be fixed before the import can complete. If no errors are present, you can click Begin Import.
Note: If you attempt to modify existing users, check the Overwrite Existing Users box. This modifies any users with emails matching those present in the CSV file, while ignoring entries in the CSV without an email.
Required fields
At least one of the following fields is required to be populated for every row in the CSV file:
firstName
lastName
email
Note: The email field is required for users to access the Verkada Pass app and users who are assigned Access Admin and Access Manager roles.
Import card numbers
These fields are also required to import card numbers:
cardFormat
facilityCode (if the card format requires one)
cardNumber
Note: If the card format is Mifare or DESFire, you also need to add a cardNumberHex column after the cardNumber column.
Import a user with Bluetooth and Remote Unlock
When you import a user with remote unlock or Bluetooth unlock enabled, it automatically sends that user an invitation email to download the Verkada Pass app.
Add access groups for the user
You can populate the groups field with the names of all groups you'd like to add the user to.
Note: The groups must exist in Verkada Command before you can import. The group name given in the CSV must exactly match the group name in Command.
Additional fields to import users
A description of all other fields is shown below:
Note: Once the import is complete, the expected time for the configuration to be pushed to the Access Controller is around 5 minutes.
Sample CSV file
Below is a sample CSV file. We recommend that you take note of the headers used. As noted above, the fields must exactly match in your CSV file.
email,firstName,lastName,startDateTime,endDateTime,roles,entryCode,groups,cardFormat,facilityCode,cardNumber,cardNumberHex,mobile,photoUrl
[email protected],John,Smith,,,Admin,1233344,Admin,Standard 26-bit Wiegand,12,34567,,TRUE,https://www.example.com/johnsmith.jp
[email protected],Jane,Doe,,,,,Contractor,HID 37-bit,1412,213045,,TRUE,
[email protected],Chris,Green,,,,56789014,,HID 37-bit No Facility Code,,12005826123,,TRUE,
[email protected],Amy,Burch,,,,,,Casi Rusco 40-Bit,,89762389989,,FALSE,
,Fardeen,Contreras,,,,,,HID Corporate 1000-35,354,243548,,FALSE,
ashanti.[email protected],,,,,,,,HID Corporate 1000-48,939,980273,,FALSE,
darragh.mile[email protected],Darragh,Miles,,,,,,DESFire CSN,,,B90AC39F824,TRUE,
[email protected],Ayesha,Findlay,,,,,,MiFare 4-Byte (32 bit) CSN,,,2E87BA89,TRUE,
,Steph,Curry,,,,,,MDC Custom 64-bit,121,12,,TRUE,
Export access control user information
You can export access user information, including access credentials to a CSV file.
In Verkada Command, go to All Products > Access.
In the left panel, click Access Users and Groups.
Click Manage > Export Users. This pulls all the configurations for each user, places them into a .csv file, and it sends an email with this file to the email you are logged into.
Note: The exported .csv is emailed to the email address you are logged into (for your organization), where the link is only valid for one (1) hour.
Download the .csv file and extract the required user information.
Learn more
Need more help? Contact Verkada Support