All Collections
Access Control
Configuration and Setup
Import and Export Credentials with CSV Files
Import and Export Credentials with CSV Files

Learn how to import and export credentials that live in Verkada Command

Updated over a week ago

Users and their corresponding access credentials live in Verkada Command. Access Control Managers and Admins can import credentials into Command in bulk with an uploaded .csv [or comma-separated value (CSV)] file, or export credentials from Command to a downloaded .csv file. Learn more about Roles and Permissions for Access Control.

Note: Through the User Import flow, you can still import a single card credential per user as well as a license plate and entry code. To import more credentials, please use the import credential flow as described below.

Import credential details and associated access user

When Access Control Managers and Admins import credentials into Command in bulk with an uploaded .csv file, the file must contain a row for each credential to be imported, including the credential details and the access user that the credential should be associated with.

Note: You can create new credentials or modify existing credentials for users who already exist in Command. To create new access users in Command, use bulk access user import.

Format your .csv file

To achieve a successful import, we highly recommend that your .csv file match the required format below:

  • The file should be a .csv file with UTF-8 encoding.

  • The file size should not exceed 250,000 rows.

  • You cannot create a user cannot during the credential import process. Credentials are matched to already existing users in Command.

  • One “key” column should be included in the import to map the user to an already existing user in Command. There are 3 “key” columns in hierarchical order:

    • User ID

    • External ID

    • Email Address

  • The import file CSV column headers should match the expected column headers, as defined in column headers below.

  • Each row should contain a single unique credential. Avoid importing multiple credentials per row.

Import credentials

Once you have formatted your file, you can import the credentials:

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

  2. On the left navigation, click Access Users and Groups .

  3. At the top right, click the Import dropdown and select Import Credentials.

  4. When you enter the credential information, the Card Type should match the list of supported card types, as listed under Accepted Formats.

  5. On Import Credentials, you can download a template that includes formatted column headers and sample credential rows.

  6. Drag and drop or upload the formatted .csv file for import.

  7. (Optional) Choose to reassign credentials. An already-existing credential from Command is then reassigned to match the CSV file input.

    1. If you choose not to reassign a credential, the row shows an error if a duplicate credential is found (already assigned to an existing user).

    2. Only reassign credentials if you want your CSV file to be the source of truth.

    3. Click Import Credentials.

  8. Under Review Columns:

    1. If any errors are recognized in the columns, this page prompts you to review your file and fix the errors.

    2. Fix errors and re-upload the .csv file.

    3. Click Next.

  9. Under Review Rows:

    1. If any errors are recognized in the rows, this page prompts you to review your file and fix the errors.

    2. Fix errors and re-upload the .csv file.

    3. Click Next.

  10. Click Proceed with Import if no errors exist on the rows or columns. If you choose to ignore the review suggestions, the rows fail on the import.

  11. After the import is complete:

    1. You should receive an email confirmation on the number of rows that passed and the number of rows that failed.

    2. You should receive a .csv file of the failed rows with a reason for the failure.

    3. Fix the failed rows and re-import these credentials to successfully import all desired credentials.

Export users and their corresponding credentials

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

  2. On the left navigation, click Access Users and Groups .

  3. At the top right, click Export and select Export Credentials.

A .csv file should export immediately where you can find it in your designated Downloads folder.

Column headers for your file

Your .csv file contains the following credentials:

User Credential

Description

First Name

First name in Command.

Last Name

Last name in Command.

User ID

Verkada-managed unique ID associated with the user.

External ID

Customer-managed unique ID associated with the user.

Employee ID

Customer-managed ID associated with the user.

Note: Employee ID uniqueness is not enforced.

Email

Email address associated with the user.

Card Type

Card type associated with the user. See supported card formats.

Facility Code

Facility code associated with the credential (if applicable).

Card Number

Numeric card number associated with the credential (if applicable).

Card Number Hex

Hexadecimal card number associated with the credential (if applicable).

License Plate

User license plate number (if applicable) is also listed as a credential for the user.

Entry Code

Unique access entry code (if applicable) is also listed as a credential for the user.

Credential Status

Verkada has introduced a Credential Status column.

  • If the credential is currently associated with a user, it is marked as an active credential.

  • If the credential is suspended, it is marked as inactive.

  • If a user is suspended, the credential is still active.

Modified

Shows the date and time the credential was last updated.

Related resources


Need more help? Contact Verkada Support

Did this answer your question?