---
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


---

# Using the Service Graph Connector for Microsoft Excel through import tasks

# Using the Service Graph Connector for Microsoft Excel through import tasks {#ariaid-title1}

Release version: Yokohama  
Updated July 14, 2025  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
With the Service Graph Connector for Microsoft Excel, you can create import tasks that handle the upload, validation, and import of staging records for your OT device data into the Configuration Management Database (CMDB).

## Import task overview {#use-excel-sgc-through-import-tasks__section_kp3_l5h_zfc}

Users assigned the OT Excel Import User \[ot_excel_import_user\] role can create import tasks in the Industrial Workspace. Import tasks handle the following tasks.

* Upload the populated Microsoft Excel spreadsheet into staging table.
* Validate the staging records created from the Microsoft Excel spreadsheet.
* Import the valid staging records into the CMDB.
* Optionally, create remediation tasks for invalid staging records.
{#use-excel-sgc-through-import-tasks__ul_lp3_l5h_zfc}
* **[Create an import task](https://servicenow-prod.fluidtopics.net/mkZa498OKLzyS9pZLuHquQ)**   
  Create an import task for the Service Graph Connector for Microsoft Excel to handle the import of Operational Technology (OT) device data from your Microsoft Excel spreadsheet.
* **[Validate imported staging records](https://servicenow-prod.fluidtopics.net/TDD2sKQFi_MA1bSe3azPDg)**   
  Validate the imported staging records from your import task to find missing, duplicate, and invalid data.
* **[Trigger a CMDB import for valid staging records](https://servicenow-prod.fluidtopics.net/Rbprwb9lMnln8MfS6AYZGA)**   
  Trigger a Configuration Management Database (CMDB) import for your valid staging records to directly import them into the CMDB
* **[Create a remediation task for invalid staging records](https://servicenow-prod.fluidtopics.net/4C4P0Zcpt~jyqo_IAPbOPQ)**   
  After running validations for the Operational Technology (OT) device data imported with the Service Graph Connector for Microsoft Excel, optionally create a remediation task to resolve invalid staging records.