---
title: "Lookup Tables"
slug: "lookup-tables"
updated: 2025-07-16T04:01:47Z
published: 2025-07-16T04:01:47Z
canonical: "help.symphonysummitai.com/lookup-tables"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.symphonysummitai.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Lookup Tables

**Lookup tables** allow recipes to efficiently store, reference, and manage commonly used data in a tabular format with entry rows and value columns, similar to a cross-reference table.

The **Lookup Tables** page lets you manually create, update, delete, and parse tables.

The **Lookup Tables** connector lets you build recipes that create, update, delete, and retrieve entry rows, or delete entire tables.F

/

Figure:

> [!NOTE]
> Note:
> 
> Lookup tables have the following limitations:
> 
> - Maximum of 10 columns per table.
> - Up to 100,000 entries per table.
>   - The Get all entries action retrieves only the first 10,000 entries.
>   - Tables with more than 50,000 entries cannot be downloaded as a CSV file.
>   - When using Recipe Lifecycle Management, only 10,000 entries can be exported or imported.

#### To create a new Lookup Table, perform the following steps:

- Navigate to **Integration Hub** > **Users** > **Tools** > **Lookup Tables**.
- Click **+ New table**.
- Click the **Edit** (pencil) icon, enter a name for the **Lookup Table**, and click ✓ **Save** icon.
- Perform one of the following:

Figure:
  1. Click I**mport CSV to upload a CSV file** with a header row that defines the column names and table structure.
  2. Click **Add** entries manually to enter data directly into the table.
  3. Click ✓ **Save** to save the Lookup Table.

#### To Add and Update Lookup Table Data:

You can Add or Update entries in a **Lookup Table** using one of the following methods:

- Import a CSV file
- Add entries manually, one at a time
- Use a recipe action to programmatically insert or update data

**Import a CSV file:**

To import a CSV file into a Lookup table, perform the following steps:

1. Navigate to **Tools** > **Lookup Tables** and click + **New table**.
2. Click **Import CSV**.
3. In the **Specify** action section, select one of the following options:

\

Figure
  1. Add row entries: Adds the CSV rows as new entries. Existing entries remain unchanged.
  2. Replace existing data: Overwrites existing entries with the data from the uploaded CSV file.
4. Drag and drop a CSV file into the **Select CSV file** field, or click **Upload from device** and select a CSV file.
5. Select the **Do not import the first row (header)** checkbox if the first row of the file should be excluded from the import.
6. Click **Import CSV** to complete the upload.

**Add or edit entries manually:**

1. Click **Add entry**.
2. Enter values in each column of the new row.
3. Click **✓ Save** to save the entry.

/

Figure:

**Use Recipe Actions:**

To automatically add and update entries, use the Add entry, Add entries, and Update entry recipe actions from the Lookup Tables.

The Lookup Tables connector lets you interact with Lookup tables through the following recipe actions:

- Add entry
- Add entries
- Lookup entry
- Search entries
- Get all entries
- Update entry
- Delete entry
- Delete multiple entries
- Truncate table