---
sourceDocument: Yokohama Operational Technology Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/operational-technology

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Operational Technology Management

ft:clusterId :

    - optm

bundleId :

    - optm

workflow :

    - Technology


---

# Configuring the Service Graph Connector for Microsoft Excel

# Configuring the Service Graph Connector for Microsoft Excel {#ariaid-title1}

Release version: Yokohama  
Updated July 17, 2025  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Configure the Service Graph Connector for Microsoft Excel to import your existing Operational Technology data from a populated Microsoft Excel flat-file spreadsheet.
Use the Service Graph Connector for Microsoft Excel Excel guided setup and complete tasks in sequence to configure the Service Graph Connector for Microsoft Excel

Navigate to AllIndustrial Workspace AdminGuided Setup, open the following guided setups, and complete the tasks.

For more information on using guided setup, see [Guided Setup](https://www.servicenow.com/docs/access?context=guided-setup&version=yokohama&pubname=yokohama-platform-user-interface&ft:locale=en-US).
* **[Assign Pre-import OT Worksheet Entry Review roles](https://servicenow-prod.fluidtopics.net/jXHM6Bqd38kQvNJ~RB3cEQ)**   
  Assign roles to the users  or user groups so that you can manage the Service Graph Connector for Microsoft Excel staging table and ETL.
* **[Review class mappings](https://servicenow-prod.fluidtopics.net/rfj2O0viH2Y0pKGg9wpUFA)**   
  Review and update the class mappings available for the Service Graph Connector for Microsoft Excel.
* **[Review the system properties used by the Service Graph Connector for Microsoft Excel](https://servicenow-prod.fluidtopics.net/aipPFWMsJv3YkSZ2mlR_FA)**   
  As an OT Admin or CMDB Integration Admin, view system properties related to the Service Graph Connector for Microsoft Excel.
* **[Add a custom field mapping in the staging table for Service Graph Connector for Microsoft Excel](https://servicenow-prod.fluidtopics.net/ZRPrDwotgFbvfcFN~D1UEg)**   
  With the Service Graph Connector for Microsoft Excel, add a custom field to the staging table and map the custom field to the configuration item (CI) field.
* **[Add a custom implementation for device classification](https://servicenow-prod.fluidtopics.net/ZDabBak8bcoGCDSqscbW6g)**   
  Customize the base system classification of an device based on the type, os_version, and firmware_version.
* **[Add a custom validation for devices](https://servicenow-prod.fluidtopics.net/CwlWXnlz4rthpxNbMVqDug)**   
  Customize the validation for your OT devices.
* **[Test the Service Graph Connector for Microsoft Excel](https://servicenow-prod.fluidtopics.net/2Bo9NQnUA1vjjew9ACdlsQ)**   
  The troubleshooting actions can help resolve common issues when importing your Operational Technology devices or data. Access the System Log to troubleshoot for these errors.
* **[View script includes used by the Service Graph Connector for Microsoft Excel](https://servicenow-prod.fluidtopics.net/d4Mtjs6iiA~Gl_7h5lA9zQ)**   
  As an admin, view the script includes related to the Service Graph Connector for Microsoft Excel

*[\>]: and then