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

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia Operational Technology Management

ft:clusterId :

    - optm

bundleId :

    - optm

workflow :

    - Technology


---

# Add a custom column to the staging table

# Add a custom column to the staging table {#ariaid-title1}

Release version: Australia  
Updated June 29, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Add a custom column to the SG OT Excel Stagings table to store an additional value imported from the Microsoft Excel spreadsheet.

## Before you begin

Role required: ot_excel_import_user

## Procedure

1. Create a column in the SG OT Excel Staging table.
   1. Navigate to AllSystem DefinitionTables.
   2. Find and select the SG OT Excel Staging table record.  
      Tip:  
      Use the filter conditions to help you locate the SG OT Excel Staging table record. For example, you can set a filter of \[Label\] \[contains\] \[SG OT Excel\].
   3. On the Columns tab, select New.
   4. In the Type field, select String.
   5. In the Column label field, enter a label for the new column.  
      The Column name field value is generated from the column label.
   6. In the Max length field, enter the maximum number of characters for the column.  
      For example, <kbd class="ph userinput">100</kbd>.
   7. Select Submit.

   {#add-custom-column-staging-table__substeps_nk2_ws2_tjc}  
   After refreshing the SG OT Excel Staging table record, the new column appears under the Columns tab.
2. Add the column to the SG OT Excel Stagings table.
   1. Open the SG OT Excel Stagings table by navigating to All.
   2. In the Filter field, add <kbd class="ph userinput">sg_ot_excel_staging.list</kbd> then press the Enter key.
   3. Select the Personalize List ![]() icon.
   4. Under Available, locate and select the column you created.
   5. Use the Add arrow to add the column to Selected.
   6. Select OK.
   {#add-custom-column-staging-table__substeps_uy5_bt2_tjc}

## Result

The column you created is now available in the SG OT Excel Stagings table.

## What to do next

Add a matching column to the SG-OT Excel Staging Import \[sn_otsm_sgc_sg_ot_excel_pre_import\] table so the imported value has a source field to map from. For more information, see [Add a matching column to the pre-import table](https://servicenow-prod.fluidtopics.net/kFT~PdA2aJB7s6S5VBSaQA "Add a column to the SG-OT Excel Pre Import table that matches the custom column on the staging table, giving the imported value a source field for mapping.").
* **[Add a matching column to the pre-import table](https://servicenow-prod.fluidtopics.net/kFT~PdA2aJB7s6S5VBSaQA)**   
  Add a column to the SG-OT Excel Pre Import table that matches the custom column on the staging table, giving the imported value a source field for mapping.
* **[Map the custom field in the transform map](https://servicenow-prod.fluidtopics.net/As87YDY5Xg2Ez0qFSR7OXQ)**   
  Map the custom source field on the pre-import table to the target field on the sta table so the imported value transforms into the correct staging column.

*[\>]: and then