LogoLogo
API Documentation
Current Version
Current Version
  • DecisionRules Documentation
  • DecisionRules Academy
  • API
    • API Introduction
    • API Keys
      • Solver API Keys
      • Management API keys
      • BI API keys
    • Rule Solver API
    • Management API
      • Rule Migration Strategies
      • Deprecated Endpoints
    • Console Logs API
    • Business Intelligence API
      • Deprecated Endpoints
    • Datacenters & Locations
      • Global Cloud
      • Regional Cloud
    • Apache Kafka Solver API
    • Endpoint Settings
    • Archive
      • Rule Flow Solver API (DEPRECATED)
  • AI Assistant
    • About Assistant
    • Assistant Setup
      • Gemini Assistant
  • RULES
    • Rules Introduction
    • Rule List
    • Rule Mode
    • Common Rule Features
      • Input & Output Model
        • Simple Editor
        • JSON Editor
      • Test Bench
      • Rule Alias
      • Rule State
      • Versioning
      • Rule Variables
      • Execution Strategy
      • Rule Dependencies
      • Rule Export & Import
        • Rule Export
        • Rule Import
        • Managing Decision Table in Excel/Google Sheets
        • Deprecated Formats: XLSX v.1 and CSV
      • Tags
      • Rule Comparison
        • Decision Table Comparison
        • Decision Tree Comparison
        • Scripting Rule Comparison
      • Rule Lock
      • Teamwork Indicator
      • Event Timeline
    • Data Types & Functions
      • Supported Data Types
      • Operators and Functions
        • Basic operators
        • Date operators
        • Functions
          • Logical Functions
          • Math Functions
          • Date and Time Functions
          • Text Functions
          • Data Functions
          • Array Functions
          • Integration functions
          • Functions and JSON
    • Decision Table
      • Table Designer
        • Table Operations
          • Filter Values
          • Valid Values
          • Sorting
      • Binding to Model
    • Decision Tree
      • Tree Designer
    • Workflow
      • Workflow Designer
      • Workflow Nodes Overview
      • Workflow Limits
    • Scripting Rule
      • Custom functions in Scripting Rules
      • Calling external API within ScriptingRules
      • Use Rule Variables in Scripting Rules
      • Call Embedded Rules in Scripting Rules
      • Tips
    • Rule Flow
      • Rule Flow Designer
      • Rule Flow Mapping
      • Rule States in Rule Flow
      • Warnings & Errors
      • Rule Flow Limits
  • SPACE
    • Space Introduction
    • Space Info
    • Dashboard
    • Access
    • API Keys
    • Audit Logs
  • Organization
    • Organization Introduction
    • Organization List
    • Members
    • Teams
    • Spaces
    • Space Roles
    • Policies
    • Statistics
    • Settings
  • Profile
    • Profile Introduction
    • General
    • Dashboard
    • Plans
    • Add-ons
    • Limits
      • Plan Limits Explained
    • Subscriptions
    • Invoices
  • Access
    • Sign Up & Login
    • Invitations & Permissions
    • Single Sign-On (SSO)
  • Business Intelligence
    • Audit Logs
    • Power BI Connectivity
      • Create a Power BI Report
      • Connect Power BI to Business Intelligence API
      • Connecting from Power BI (deprecated)
      • Connect DecisionRules to Power BI Using Our Custom Connector
  • OTHER DEPLOYMENT OPTIONS
    • Regional Cloud
      • Region Specific API URLs
    • Docker & On-Premise
      • Environment Variables
      • Redis Connection Modes
      • DecisionRules Application
        • Minimal Requirements
        • DecisionRules Server
        • DecisionRules Client
        • DecisionRules Business Intelligence
        • Networking Between Docker Containers
      • Setup Single Sign-On (SSO)
        • Set up Microsoft Entra ID SSO
        • Set up Google SSO
      • Docker Showcase App
        • Showcase
        • Showcase + Business Intelligence
      • AWS Setup
        • AWS ECS/Fargate
        • Cache - Amazon ElastiCache
      • Microsoft Azure Setup
        • Database - Azure CosmosDB
        • Cache - Azure Cache for Redis
        • Azure Container Apps
      • Azure Red Hat OpenShift
      • Google Kubernetes Engine (GKE)
      • Kubernetes Setup
        • Kubernetes Setup with Business Intelligence
      • Logging options
      • CD/CI Pipelines
        • Azure DevOps CICD Pipelines
        • Using Migration script (old way)
      • Offline License
      • White Labeling
  • SDK and Integrations
    • Languages / Frameworks
      • SQL Server
      • Oracle PL/SQL
      • PostgreSQL
      • JavaScript
      • Java Spring Example
      • PHP Library
      • Python Library
      • .NET Library
      • Google Tag Manager
    • Excel Add-in
  • Terms & Conditions
    • Terms and Conditions
    • Privacy Policy
    • Service Level Agreement
      • Community Support
      • Standard Cloud (SaaS)
      • Silver SLA
      • Gold SLA
      • Custom SLA
    • Sub-Processor List
  • Product Updates
    • Release Notes
      • Public Cloud
      • On-Premise / Private Cloud
    • Major Updates
      • Changes in Version 1.19.0 (10/2024)
      • Changes in Version 1.20.0 (4/2025)
    • Roadmap
Powered by GitBook
On this page
  • Managing Decision Tables Outside the App
  • File Structure of XLSX Format
  • Settings
  • Mandatory Elements
  • Optional Elements
  • Settings Example:
  • Rule Variables
  • Table
  • Columns Settings
  • Rows Settings
  • Table Content
  • Valid Values
  • Final Notes

Was this helpful?

  1. RULES
  2. Common Rule Features
  3. Rule Export & Import

Managing Decision Table in Excel/Google Sheets

Last updated 7 months ago

Was this helpful?

As of release 1.19.0:

The following description applies to the second version of XLSX export. Version 1, which can still be accessed via the Deprecated → XLSX v.1 menu, is now outdated. While version 1 remains usable for imports, it lacks support for some of the newer features. We highly recommend switching to version 2.

For more information on deprecated formats, refer to the .

Managing Decision Tables Outside the App

You can manage decision tables outside of the DecisionRules application for easier, faster, and clearer editing. We recommend using Microsoft Excel or Google Sheets, as they support the XLSX format.

Other formats like ODT or simple XLS are not compatible.

There are two ways to create decision tables in XLSX format:

  1. Create an XLSX file from scratch, following the exact format outlined here.

  2. Start with a basic table in DecisionRules, export it, and then edit it.

We recommend the second option for ease of use.

File Structure of XLSX Format

Imported and exported files require both mandatory and optional structural elements. The file contains four sheets:

Settings

Mandatory Elements

  • Export Version: Always set to 2.

  • Name: The name of the decision table.

Optional Elements

  • Rule ID: The unique ID for the rule, automatically generated if not provided during import.

  • Created: The creation date in ISO 8601 format, automatically generated if not provided.

  • Note: A description of the table.

Settings Example:

Rule Variables

Table

This sheet contains the decision table itself.

Columns Settings

Each column requires three mandatory headers:

  • Column Title: The name of the column.

Optional Element:

  • Column Value: This field, located under the column title, maps the column to a value such as input, output, or variables. While optional in the XLSX file, it is essential for table solving, and columns must be mapped once the table is imported.

Rows Settings

Each row includes several options:

Time zones must be specified for both from and to, even if only one limit is needed.

Table Content

Each row for each column contains two parts:

Valid Values

  • Column Name: This optional field is for user convenience, so you don't have to memorize which alias corresponds to which column.

To add valid values for a column, enter the column alias and column name, then list the values one under the other:

Final Notes

Managing Decision Tables in Excel or Google Sheets offers a structured approach with specific settings for version control, rule variables, columns, rows, and valid values. XLSX version 2, the recommended format, supports advanced features that are not available in version 1. Adhering to the correct structure ensures smooth imports, consistent decision-making rules, and easier integration of validation for input and output variables.

Rule Alias: An; only English letters, numbers, and hyphens ("-") are allowed.

Version: The of the rule.

Status: The decision table's , either published or pending.

Input Model: Describes the for the decision table, where each variable is defined as an object with attributes or substructures.

Output Model: Describes the expected for the decision table.

Tags: An array of , which can be an empty array or a list of strings if provided.

There are no mandatory elements in this section; you can define the here if needed. This section includes two columns: variable name and value, just as in the application.

Column Alias: for the column, which can contain only English letters, numbers, and hyphens.

Column Type: Must be set to condition, calculation, or output. For more information on column types and their order, refer to the section.

Active: Defines whether the row is . Accepts Yes or No values; if left empty, the default is No.

Time Validation: Specifies the time range during which the. This accepts an object in the format {"from":"YYYY-MM-DD HH:MM Z", "to":"YYYY-MM-DD HH:MM Z"}, where Z represents the time zone in the ±HH:MM format.

Operator: The table . Available operators can be selected from a dropdown list. Calculation columns must use the function operator.

Value: The cell value of the table. For restrictions on cell values, refer to the and

This sheet defines for each column. It includes two headers:

Column Alias: Maps the column to the valid value. The alias must match the alias used in the . If the app cannot locate the column with this alias, those valid values will not be applied. This field is case-sensitive.

When you import the table into the app, will appear in the column settings, and cells containing invalid values will be flagged:

dedicated section
alias for the rule
version number
status
input variables
output variables
rule tags
rule variables
operator
Supported Data Types
Operators sections
valid values
valid values
Table sheet
The unique identifier
table designer
activated or deactivated
row is valid
Settings in the xlsx file
Rule variables in the xlsx file
Rule variables in the app
Table in the Table sheet of xlsx file
The table in the DecisionRules app
A column defined in xlsx
The same column in the app
Row settings xlsx
Row settings app
Operators and values condition columns xlsx
Operators and values condition columns app
Column alias in the Table sheet
Valid values for the column
Invalid value