--- sourceDocument: Australia Operational Technology Management sourceDocumentLink: https://www.servicenow.com/docs/r/australia/operational-technology Release : - australia ft:locale : - en-US ft:publication_title : - Australia Operational Technology Management ft:clusterId : - optm bundleId : - optm workflow : - Technology --- # Populating your Microsoft Excel spreadsheet with equipment model data # Populating your Microsoft Excel spreadsheet with equipment model data {#ariaid-title1} Release version: Australia Updated September 10, 2026 ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read Summarize ![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete. ## Summary of Populating your Microsoft Excel spreadsheet with equipment model data This guide explains how to create and populate a Microsoft Excel spreadsheet with existing ISA equipment model data for import into the Configuration Management Database (CMDB) within the ServiceNow AI Platform. Correctly positioning your data in the specified columns is essential for a successful upload. Show full answer Show less ## Preparing the Spreadsheet * Use the provided Excel template **Import Equipment Model -- Data Source - v2.xlsx** attached to the data source record under *Equipment Model - ISA \> Import Equip. Model - Data Source*. * An alternate download option is available via the Now Support Knowledge Base article **KB0966600**. * The template contains three worksheets: * **Blank template for data import:** For populating your equipment model data * **Data Column Descriptions:** Details on each column's purpose * **Sample Data for Import:** Example equipment model data * After populating, save the file in an accessible location to use with the Integration Hub ETL function. * Column names must remain unchanged, but you may add columns to capture additional owner-identifying fields as configured by the `snisamodel.usersearchmatchingattribute` system property. ## Populating the Spreadsheet You can import data for multiple sites within a single spreadsheet. Data should be entered according to the columns defined in the template. Key columns include: | Column | Name | Type | Description | Required | |-|-|-|-|-| | A | Path | string | Concatenated short codes representing the entity and its parents (e.g., ATL-B42-MQSTOR-Z1). This defines the hierarchy and location. | Yes | | B | Short Code | string, alphanumeric | Short description code for the entity; max length controlled by `snisamodel.shortcodevalidationmaxlength`. | No | | C | Entity Name | string | Long-form name of the entity (e.g., city, building, model number). | Yes | | D | Location | string | Location description referencing the `cmn-location` value in the CMDB. | No | | E | Assigned to | string | Email of the person responsible for the entity; additional attributes can be used based on system property settings. | No | | F | Support Group | string | Name of the group supporting maintenance and management. | No | | G | Description | string | Detailed description of the equipment model entity and its purpose. | No | | H | Process criticality | string | Indicates criticality level to industrial process (e.g., 1 = most critical). | No | | I | Company | string | Company name associated with the entity, referencing `cmn-location` in the CMDB. | No | | J | Template | string | Template used for the import; cannot be set post-import. | Yes | ## Upgrading from ISA SGC v1 to v2 If upgrading from version 1 to version 2 of the ISA Service Graph Connector, new equipment model entities with unique paths can be imported using this updated template. Existing entities require a fix script to update. Create and populate a Microsoft Excel spreadsheet with your existing ISA equipment model data. Positioning your existing data in the correct columns is crucial to the success of your upload. To create a Microsoft Excel spreadsheet that properly populates the Configuration Management Database (CMDB) in the ServiceNow AI Platform, do the following actions: 1. Prepare your spreadsheet for upload by using the Microsoft Excel spreadsheet that is attached to the data source record. To locate an empty template, do the following actions: 1. Navigate to Equipment Model - ISAImport Equip. Model - Data Source 2. Click Import Equipment Model -- Data Source - v2.xlsx {#populate-excel-spreadsheet-with-isa-equipment-model-data__ol_s5c_skf_xpb} Note: Alternately, to download the Import Equipment Model -- Data Source - v2.xlsx spreadsheet, see the [Microsoft Excel spreadsheets required for the ISA Equipment Model Excel Service Graph Connector \[KB0966600\]](https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0966600) article in the Now Support Knowledge Base. 2. Download the attached Import Equipment Model -- Data Source - v2.xlsx spreadsheet to learn more about the template and its worksheets: Note: If you're an ISA SGC user upgrading from v1 to v2, see the section named Upgrading from v1 to v2. {#populate-excel-spreadsheet-with-isa-equipment-model-data__table_igw_423_vpb__entry__2} | Worksheet name | Purpose | |-|-| | Blank template for data import | Populates your Equipment Model data for import. You can view detailed examples in the remainder of this topic. | | Data Column Descriptions | Provides descriptions of the data columns on the spreadsheet, similar to the information found in this topic. | | Sample Data for Import | Provides an example of an equipment model for import in the spreadsheet. You can view these examples in the remainder of this topic. | [Table 1. Import Equipment Model -- Data Source - v2.xlsx spreadsheet] {#populate-excel-spreadsheet-with-isa-equipment-model-data__table_igw_423_vpb} 3. After populating the Microsoft Excel spreadsheet, save it in a known location for easy access when you run the Integration Hub ETL function. Note: Column names can't be changed. You can add additional columns to support additional fields to uniquely identify owners, as designated in the sn_isa_model.user_search_matching_attribute system property. {#populate-excel-spreadsheet-with-isa-equipment-model-data__ol_kzs_bb3_vpb} ## Populating the spreadsheet {#populate-excel-spreadsheet-with-isa-equipment-model-data__section-excel-a-j} Figure 1. Sample Operational Technology data, columns A through J You can import data from multiple sites in a single spreadsheet. The example image shows data for two sites: ATL and CTL. {#populate-excel-spreadsheet-with-isa-equipment-model-data__table_mch_2cc_txb__entry__5} | Column | Name | Type | Description | Required | |-|-|-|-|-| | A | Path | string | Concatenation of the short codes of this entity and all its parent entities. For example, `ATL-B42-MQSTOR-Z1` is the concatenation of these short codes: * ATL short code for the Atlanta site. * B42 short code for Building B42. * MQSTORE short code for Model M and Q. * Z1 short code for the Zone 1 transfer storage zone for Model M and Q. {#populate-excel-spreadsheet-with-isa-equipment-model-data__ul_nch_2cc_txb} | Yes | | B | Short Code | string, alphanumeric only | Short description code for the entity. Refer to the previous Path column description for examples of short codes. The Short Code can be no longer than the maximum length that is designated in the sn_isa_model.short_code_validation_max_length system property. | No | | C | Entity Name | string | Long name of the entity. For example, a city name, a building number, or a model number. | Yes | | D | Location | string | Location of the entity. For example, you would list Atlanta Building 64 for each of the equipment models that are located there. The cmn-location value that is stored in the Configuration Management Database (CMDB) in the ServiceNow AI Platform, which uses it as a reference. | No | | E | Assigned to | string | Email address of the assigned person who owns and manages this entity record. Note: You can use additional attributes, based on the settings designated in the sn_isa_model.user_search_matching_attribute system property. | No | | F | Support Group | string | Name of the group that supports the maintenance and management of this entity. | No | | G | Description | string | Long description of this equipment model entity and its purpose. | No | | H | Process criticality | string | Measure of how critical, or important, the entity is to the industrial process. Examples are as follows: * 1 - most critical. * 2 - somewhat critical. {#populate-excel-spreadsheet-with-isa-equipment-model-data__ul_och_2cc_txb} | No | | I | Company | string | Name of the company that the entity belongs to. The cmn-location value that is stored in the CMDB in the ServiceNow AI Platform, which uses it as a reference. | No | | J | Template | string | The template used to import data. Note: After your import your data, you can't set the template. | Yes | [Table 2. Columns A through J] {#populate-excel-spreadsheet-with-isa-equipment-model-data__table_mch_2cc_txb} ## Upgrading from v1 to v2 {#populate-excel-spreadsheet-with-isa-equipment-model-data__section_hkf_53b_txb} ISA SGC users upgrading from v1 to v2 can import new ISA equipment model entities with unique paths. Use a fix script to update existing entities. *[\>]: and then