---
sourceDocument: Yokohama Build workflows
sourceDocumentLink: https://www.servicenow.com/docs/r/yokohama/build-workflows

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Build workflows

ft:clusterId :

    - crworkflow

bundleId :

    - crworkflow

workflow :

    - Creator


---

# Manage decision tables in Excel

# Manage decision tables in Excel {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read

Summarize  
![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI  
This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.  

## Summary of Manage Decision Tables in Excel

This guide explains how to manage decision tables using Excel in the ServiceNow AI Platform.
It enables users to export decision tables, modify them in Excel, and then import the changes back into Workflow Studio, enhancing efficiency for larger tables and allowing collaboration among team members.
Show full answer Show less  

## Key Features

* **Exporting:** Decision tables can be exported to Excel in .xlsx format, containing two worksheets: the table and instructions for building decision rows.
* **Editing:** Users can add, remove, or reorder decision rules within the Condition and Result columns, while retaining headers and avoiding modifications outside these columns.
* **Importing:** Post-editing, the modified Excel file can be imported back into Workflow Studio, validating changes and providing error feedback if necessary.
* **History Tracking:** Access export and import history through the History sidebar, including user details and timestamps for each action.

## Key Outcomes

By managing decision tables in Excel, users can efficiently handle large datasets, delegate tasks among team members, and maintain a clear history of changes. Successful imports update the decision table, while failed imports provide detailed error descriptions, facilitating quick corrections. Note that certain limitations exist, such as unsupported localization and specific conditions under which modification is not allowed.  
If you have large decision tables to build or want to enhance decision tables outside of the ServiceNow AI Platform, manage them in Excel. Export a decision table to an Excel file, edit the downloaded file to add and edit rows, and then import the file back into Workflow Studio.

## Exporting a decision table to Excel {#manage-decision-tables-ms-excel__section_ip1_xjz_ztb}

After creating and saving inputs, condition columns, and result columns, export a decision table to Excel in .xlsx format by selecting Export. The exported file contains two
worksheets: One with the decision table and the other with instructions on how to build decision rows and prevent import errors.

Editing your decision tables in Excel can help you build large tables more quickly. It also
gives you the ability to assign the structural setup to a developer, and then delegate rule
authoring to someone else, who could fill it out in Excel.  
Note:  
If you have any advanced rows in your decision table when you export to Excel, these rows are read-only and cannot be edited in Excel. You can edit the rest of the table in Excel and import it back into Workflow Studio.

## Modifying the decision table in Excel {#manage-decision-tables-ms-excel__section_q1f_p1z_ztb}

After you export a decision table to Excel, you can add, remove, edit, or reorder decision rules. Follow these directions to build your decision table.

* Build conditions using the operator and value columns.
  * In each Operator cell, choose the relevant operator from the drop-down list. The operator list is specific to the condition column field type.
  * In each Value cell, enter or select the condition value, following the format guidance from the instructions sheet.
  * When building date, due date, date/time, reference, or choice conditions, you can select a value from the drop-down list.
  {#manage-decision-tables-ms-excel__ul_sgh_pky_ztb}
* Specify result values.
  * In each Result cell, enter the result value.
  * For reference or choice results, select a result value from the drop-down list.
  {#manage-decision-tables-ms-excel__ul_snh_nkt_25b}
{#manage-decision-tables-ms-excel__ul_ytj_hhy_ztb}  
Consider the following limitations when modifying a decision table in Excel.

* Use Excel to add, remove, or edit decision rules, but do not use Excel to add or modify condition columns or result columns.
* Edit only cells in the Condition and Result columns. During the import, any data entered to the right of these columns are ignored.
* Retain the headers in the exported file, and do not modify them in any way.
* Modify only the original exported file in Excel. Do not copy and paste the contents of an exported file into a new Excel file. However, the original file can be renamed.
* Ensure that there are no empty rows. Any entry after five consecutive empty rows is ignored.
{#manage-decision-tables-ms-excel__ul_yfv_tkt_25b}

## Importing an Excel file into Workflow Studio {#manage-decision-tables-ms-excel__section_alq_l1z_ztb}

Note:  
The import option is only available after you export the decision table to Excel.  
During the import process, all the modifications in the Excel file are validated before your changes are imported to Workflow Studio. The following outcomes are possible while attempting to import.

* Successful import: The Excel file import is successful. The Import window closes automatically, and your decision table is updated with the imported data. Save your changes before continuing.
* Failed import: The Excel file import has failed. Download the Error.xlsx file that contains the detailed description about the errors and how to fix them. After fixing the errors, follow the import process and import the corrected error file.
{#manage-decision-tables-ms-excel__ul_prm_5py_ztb}

## View export and import history {#manage-decision-tables-ms-excel__section_apy_sff_15b}

View the export and import history of a decision table in the History sidebar. Each entry
displays the name of the user who imported or exported the file and the timestamp.  
You can download the relevant Excel file based on the history type: The exported file (Export Successful), the imported file (Import Successful), or the error file (Import Failed). History records are not created when you select Cancel in the import window.  
Note:  
The `glide.ui.export.choice_list_max_characters` property sets the maximum number of characters that will be included from a condition field type when exporting to Microsoft Excel, as well as the maximum number of characters displayed in the list view condition builder in Core UI. This property is of type integer and has a default value of 80. To use this property, add it to the System Property \[sys_properties\] table. It's important to note that this property does not affect the length of condition field values in tables.

## Limitations {#manage-decision-tables-ms-excel__section_rcl_21z_ztb}

The following are scenarios when you cannot modify a decision table in Excel.

* Decision table does not contain a conditions column.
* Decision table has unsaved changes.
* Decision table has condition columns with unsupported field types.
* Decision table has a condition column that is related to an inactive input.
{#manage-decision-tables-ms-excel__ul_fm5_pry_ztb}  
Note:  
The Localization Framework is integrated in decision tables. However, because the Edit in Excel feature doesn't support localization, you cannot use this feature in any instance that doesn't use English.