---
schema_version: "1"
id: 6038336b9681c4e7a5d0cac1008b944df1a7160c2e559fe09f15791b517cfdf1
title: Add CSV Data to Decision Tables
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/ind/264-0-0/bre_upload_csv_dt.md
canonical_url: https://help.salesforce.com/s/articleView?id=ind.bre_upload_csv_dt.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 090778f8ad68f46cf0d5cc8c28bdb606f6fbd95f717e02e1389f0abbd1f21994
description: When you use CSV as the source data for your decision table, you can configure only the input and output columns for the mapping. You can upload the CSV data for your decision table only after you finish creating a decision table.
products:
  - Industry Solutions
  - Cross Cloud
release: "264"
---
# Add CSV Data to Decision Tables

When you use CSV as the source data for your decision table, you can configure only the input and output columns for the mapping. You can upload the CSV data for your decision table only after you finish creating a decision table.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions for clouds that have Business Rules Engine enabled</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d21996e69">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d21996e69 ">To create, edit, and activate a decision table:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d21996e69 ">Rule Engine Designer</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d21996e69 ">To run decision tables:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d21996e69 ">
              <p>Rule Engine Designer </p>
              <p style="margin-bottom:0;">OR</p>
              <p style="margin-bottom:0;">Rule Engine Runtime</p>
            </td>

          </tr>
        </tbody>
      </table>

With a CSV-based decision table, you can maintain multiple versions of the decision table, and assign ranks to them. Also, expression sets read multiple results only from CSV-based decision tables that return multiple outputs.

1. From the App Launcher (![App explorer icon.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-business_rules_engine-264-0-0-production-enus/b2d6dd5c-c231-428b-abbf-3dd2cd51a11f/business_rules_engine/images/app_explorer.png)), find and select **Business Rules Engine**.
2. Click the app navigation menu, and select **Lookup Tables**.
3. Select the decision table that you created by using CSV as the source.
4. From the Table tab, click **Upload CSV**.
    
    The Add Data to Decision Table dialog box appears.
5. Select the CSV file from your computer.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-business_rules_engine-264-0-0-production-enus/b2d6dd5c-c231-428b-abbf-3dd2cd51a11f/images/icon_note.png)
    
    Note The first row in your CSV file must be column names or headers.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-business_rules_engine-264-0-0-production-enus/b2d6dd5c-c231-428b-abbf-3dd2cd51a11f/images/icon_note.png)
    
    Note Empty cells in your CSV file are stored as null values for most column types. Empty cells in Boolean columns default to false. The literal text "null" is not a valid cell value. Leave the cell empty to store a null value. For more information, see [How Null Values Work in Decision Tables](https://help.salesforce.com/s/articleView?id=ind.bre_null_values_dt.htm&release=264.0.0&type=5 "How decision tables treat null and blank input cells depends on the table type. In standard decision tables, use the Consider Null Values for Lookup option to control how rows with null values are matched during lookup. In advanced decision tables, Consider Null Values for Lookup isn't supported. Blank cells in optional input columns always act as wildcards and match any supplied value.").
    
    ![Warning](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-business_rules_engine-264-0-0-production-enus/b2d6dd5c-c231-428b-abbf-3dd2cd51a11f/images/icon_warning.png)
    
    Warning Due to some technical limitations with popular CSV editing tools, very large numeric values are converted into scientific notation. For example, if your file contains the value 619903629728, it's converted to 6.19904E+11 when the file is saved. When the file is then imported into Business Rules Engine, it causes formatting issues, resulting in failed lookups. To avoid this, follow safe editing best practices as outlined here.
    
    - Configure your CSV editor to treat numbers as text.
    - If your editor has a setting to disable scientific notation conversion for very large numbers, use the setting.
    - Consider using a specialized editor such as EmEditor, which is designed for avoiding such issues. This is especially useful for large edits.
    - For minor edits, consider using simple apps such as Notepad, which saves your content as text.
6. To add the data from the CSV file to your decision table, click **Add Data**.
    
    To view the data rows in your decision table, refresh the page. You can verify the status of the CSV upload by checking the CSV Upload Status field in the Table tab.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-business_rules_engine-264-0-0-production-enus/b2d6dd5c-c231-428b-abbf-3dd2cd51a11f/images/icon_note.png)
    
    Note Only Salesforce admins and users with the Rule Engine Designer permission set who own the associated decision matrix can edit the decision table. Users with general Read/Write access can't make edits unless they’re the owner.