---
sourceDocument: Zurich IT Operations Management
sourceDocumentLink: https://www.servicenow.com/docs/r/zurich/it-operations-management

 Release :

    - zurich

ft:locale :

    - en-US

ft:publication_title :

    - Zurich IT Operations Management

ft:clusterId :

    - itom

bundleId :

    - itom

workflow :

    - Technology


---

# Use bulk certificate upload

# Use bulk certificate upload {#ariaid-title1}

Release version: Zurich  
Updated September 10, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
In Certificate Inventory and Management version 1.2.0 and later, you can import up to 5000 SSL certificates in bulk using a single .xlsx file.

## Before you begin

Role required: pki_user or pki_admin  
The default admin is assigned both the pki_user and pki_admin roles. The users with the following roles have access to bulk certificate upload.

* sn_disco_certmgmt.pki_user
* sn_disco_certmgmt.pki_admin
{#run-cert-inventory-mgmt-bulk-url__ul_jmz_klg_j1c}

## Procedure

1. Navigate to AllCertificate ManagementBulk Upload Certificates.
2. From the Bulk Upload page, select Download Template File (.xlsx) link to download the sample_cmdb_ci_certificate.xlsx file.
3. Open the downloaded sample_cmdb_ci_certificate.xlsx file.
4. Refer to the values in the sample rows as a guide and add the SSL certificate's properties into the corresponding columns.  
   Each entry in the Excel sheet corresponds to a CI certificate. For a description of each field in the sample_cmdb_ci_certificate.xlsx field, see [.](https://www.servicenow.com/docs/yW_HY6AUdWMG~OqtdcScIg "The bulk certificate upload Excel template contains fields that map to the fields in the Unique Certificate [cmdb_ci_certificate] table. You can import up to 5000 SSL certificates in bulk using the Excel file.")  
   Note:  
   * For maintaining the certificate's chain relationship, every certificate must have the fingerprint of its root certificate in the root_issuer column and the fingerprint of its issuer in the issuer column.
   * For self-signed certificates, both root_issuer and issuer must have the value of the certificate's fingerprint.
5. Delete the sample rows and then save the sample_cmdb_ci_certificate.xlsx file.
6. Navigate back to the Bulk Upload Certificates form.
7. Select Browse File and choose the updated sample_cmdb_ci_certificate.xlsx file.
8. Select Upload.

## Result

If any errors occur while uploading, a warning message and link to the error logs appears. Only users with the admin role can view these logs. Errors can occur when a mandatory field is left empty or a valid_from epoch value is
greater than that of valid_to.

After the file is successfully uploaded, you can see a success message displayed with a View All redirect link. You can view a list of the certificates that were added to the Unique Certificate
\[cmdb_ci_certificate\] table.

*[\>]: and then