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

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu Operational Technology Management

ft:clusterId :

    - optm

bundleId :

    - optm

workflow :

    - Technology


---

# Service Graph Connector for Microsoft Excel

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

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

The Service Graph Connector for Microsoft Excel function enables you to import your existing Operational Technology data from a populated Microsoft Excel flat-file spreadsheet. You use it in the Integration Hub Extract Transform Load (ETL) to upload this data to the Configuration Management Database (CMDB).

Before you can run the import process, you must populate the Microsoft Excel spreadsheet with your existing Operational Technology data. When you import your Microsoft Excel spreadsheet using the Integration Hub ETL, it creates the correct configuration item (CI) records in the Configuration Management Database (CMDB). To learn more, see [Operation Technology (OT) extension classes](https://www.servicenow.com/docs/access?context=cmdb-ci-class-models-operation-technology&version=xanadu&pubname=xanadu-servicenow-platform&ft:locale=en-US).
* **[Configuring Service Graph Connector for Microsoft Excel](https://servicenow-prod.fluidtopics.net/hsW3D3I0h0juJijq9WqfOw)**   
  Configure the Service Graph Connector for Microsoft Excel to import your existing Operational Technology data from a populated Microsoft Excel flat-file spreadsheet.
* **[Easy import](https://servicenow-prod.fluidtopics.net/BzuK~HxVeO9I2MNzPcZl2Q)**   
  Easy import is a simplified import process that enables you to import only the columns that you want.
* **[Managing Validations](https://servicenow-prod.fluidtopics.net/5pvzRy9yD6w4lcYvwg3PLQ)**   
  Validation enables you to review and manage the imported data in the staging table.
* **[Schedule the time interval to import data](https://servicenow-prod.fluidtopics.net/3Q4M7VphpBhYi~28bl_Qpw)**   
  Schedule the time interval to import the data from the staging table to the CMDB.
* **[Import your Microsoft Excel spreadsheet using the staging table](https://servicenow-prod.fluidtopics.net/Vf6IYbUliUiu_yd4EBIj4A)**   
  Import your Microsoft Excel spreadsheet into the staging table using easy import to create the required data in the staging table from the spreadsheet.
* **[Add a custom field mapping in the staging table for Service Graph](https://servicenow-prod.fluidtopics.net/tjuukxT9NVyBukeeLVhdmQ)**   
  Add a custom field to the staging table and map the custom field from the staging table to the CI field through Excel SGC.
* **[Add a custom implementation for device classification](https://servicenow-prod.fluidtopics.net/VkDuW7vMZwiwN6~nN8ZMuA)**   
  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/UD9QBV3dzPyvctv5LQBQRw)**   
  Customize the validation for your OT devices.
* **[Test the Excel Service Graph connector](https://servicenow-prod.fluidtopics.net/~oe0_H10LaSvLLH3Wzcpiw)**   
  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](https://servicenow-prod.fluidtopics.net/bSJJ3vdkj9N10rDyfkxMAw)**   
  As an admin, view the script includes related to the Service Graph Connector.
* **[Access system properties used by the Service Graph Connector](https://servicenow-prod.fluidtopics.net/hsJDViCNYWUlf~tlqDenVw)**   
  As an admin, view system properties related to the Service Graph Connector.

**Related topics**   

* [IntegrationHub](https://www.servicenow.com/docs/access?context=integrationhub&version=xanadu&pubname=xanadu-integrate-applications&ft:locale=en-US)
* [IntegrationHub ETL](https://www.servicenow.com/docs/access?context=integrationhub-etl&version=xanadu&pubname=xanadu-servicenow-platform&ft:locale=en-US)