All Collections
Access Control
Configuration and Setup
Bulk Import/Export Access Control Users
Bulk Import/Export Access Control Users

Learn how to upload/download the CSV file to/from Command

Updated over a week ago

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.

  1. In Verkada Command, go to All Products > Access.

  2. In the left panel, click Access Users and Groups.

  3. Click Manage > Import Users.

    1. (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.

    2. (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.

  4. Select the CSV File and drag and drop the file into the box.

  5. 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 protected],John,Smith,,,Admin,1233344,Admin,Standard 26-bit Wiegand,12,34567,,TRUE,
[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.

  1. In Verkada Command, go to All Products > Access.

  2. In the left panel, click Access Users and Groups.

  3. 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.

  4. Download the .csv file and extract the required user information.

Learn more

Need more help? Contact Verkada Support

Did this answer your question?