---
title: Creating a lookup table
slug: how-tos/creating-a-lookup-table
createdAt: 2026-10-30T09:00:00.000Z
---

*Available from version 8.3 and later.*

You need the `MANAGE_LOOKUP_TABLES` privilege and the lookup tables feature in your license.

## Create the table

1. Click **Lookup tables** in the main menu.
2. Click **Create lookup table**.
3. Enter a **Name** (unique within the organization) and, optionally, a **Description**.
4. Under **Add column**, enter a **Column name**, choose its type (**String**, **Number** or **Boolean**) and click the plus button. Repeat for every column.
5. Use the arrow buttons to change the order of the columns, and the delete button to remove one.
6. Click **Save**.

A table needs at least one column. The column names `row` and `params` are reserved.

After saving, the table opens on its **Table** tab.

## Add and edit rows

1. Select the lookup table and click **Edit**.
2. On the **Table** tab, click **Add row**.
3. Double-click a cell, or select it and start typing, to enter a value. A **Boolean** cell is a checkbox.
4. Click **Save** to write all changes at once, or **Cancel** to discard them.

Changes to rows are not saved until you click **Save**. Until then, the table shows a notice that row changes are not saved yet.

## Change the columns

Click **Edit** and open the **Settings** tab.

- **Rename a column**: change its name. The column keeps its values.
- **Add a column**: use **Add column**. The new column is empty in every row.
- **Remove a column**: click its delete button. Historian asks you to confirm. Its values are cleared from every row when you save.

For a manual table, the type of a saved column cannot be changed. On a synced table you can change it, see [Syncing a lookup table from an external database](https://docs.factry.io/how-tos/syncing-a-lookup-table-from-an-external-database). To change it on a manual table, export the table and import the file again with the new column type (see [Importing and exporting a lookup table](https://docs.factry.io/how-tos/importing-and-exporting-a-lookup-table)).

## Delete a lookup table

Select the lookup table and click **Delete** at the bottom of the panel.

The delete dialog lists every resource that depends on the table, directly or through another resource. Type the name of the lookup table to confirm. Confirming deletes the table and all of them. The **Referenced by** section on the **Settings** tab lists what uses the table.
