Configuring the Service Graph Connector for Microsoft Excel

---
title: Configuring the Service Graph Connector for Microsoft Excel
description: Configure the Service Graph Connector for Microsoft Excel to import your existing Operational Technology data from a populated Microsoft Excel flat-file spreadsheet.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/operational-technology/operational-technology-manager/configuring-service-graph-connector-for-excel.html
release: australia
product: Operational Technology Manager
classification: operational-technology-manager
topic_type: concept
last_updated: "2026-09-10"
reading_time_minutes: 1
breadcrumb: [Service Graph Connector for Microsoft Excel, Use, Operational Technology Manager, Operational Technology]
---

# Configuring the Service Graph Connector for Microsoft Excel

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 **All** > **Industrial Workspace Admin** > **Guided Setup**, open the following guided setups, and complete the tasks.

For more information on using guided setup, see [Guided Setup](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/platform-user-interface/guided-setup.md).

-   **[Assign Pre-import OT Worksheet Entry Review roles](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/operational-technology/operational-technology-manager/assign-pre-import-ot-worksheet-entry-review-tool-for-sgc-import-roles.md)**  
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://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/operational-technology/operational-technology-manager/review-class-mappings-sgc-excel.md)**  
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://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/operational-technology/operational-technology-manager/access-system-properties-used-by-service-graph-connector.md)**  
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://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/operational-technology/operational-technology-manager/add-new-column-mappings-excel-service-graph.md)**  
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://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/operational-technology/operational-technology-manager/adding-custom-implementation-for-asset-classification.md)**  
Customize the base system classification of an device based on the type, os\_version, and firmware\_version.
-   **[Add a custom validation for devices](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/operational-technology/operational-technology-manager/add-custom-validation-for-devices.md)**  
Customize the validation for your OT devices.
-   **[Add a custom column to the staging table](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/operational-technology/operational-technology-manager/add-custom-column-staging-table.md)**  
Add a custom column to the SG OT Excel Stagings \(sg\_ot\_excel\_staging\) table to store an additional value imported from the Microsoft Excel spreadsheet.
-   **[Testing the Service Graph Connector for Microsoft Excel](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/operational-technology/operational-technology-manager/excel-service-graph-connector-troubleshooting.md)**  
These 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://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/operational-technology/operational-technology-manager/view-script-includes-used-by-service-graph-connector.md)**  
As an admin, view the script includes related to the Service Graph Connector for Microsoft Excel

**Parent Topic:**[Service Graph Connector for Microsoft Excel](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/operational-technology/operational-technology-manager/service-graph-connector-for-OT-excel.md)