---
title: Importing and exporting a lookup table
slug: how-tos/importing-and-exporting-a-lookup-table
createdAt: 2026-10-30T09:00:00.000Z
---

*Available from version 8.3 and later.*

Import a lookup table from an Excel (`.xlsx`) or CSV (`.csv`) file, and export a lookup table to an Excel workbook.

## Import a file

Importing needs the `MANAGE_LOOKUP_TABLES` privilege and the lookup tables feature in your license. An import always writes a whole table: it either creates a new table or replaces every row and column of an existing one.

- **New table**: on the **Lookup tables** page, open the dropdown next to **Create lookup table** and click **Import**.
- **Existing table**: select the table and click **Import** at the top of the panel. Save or cancel your changes first.

:::hint{type="warning"}
Importing into an existing table replaces every row and column of the table. It cannot be undone, so export the table first if you need a copy.
:::

1. Under **Excel or CSV file**, click **Browse** and select the file.
2. Leave **The first row holds the column names** selected if the file has a header row. Clear it if the first row is data.
3. Click **Upload**.
4. For a new table, enter its **Name**.
5. Review the columns. Historian detects each column's type from the values in the file. For each column you can:
   - clear **Include** to leave it out,
   - change its name,
   - change its type.
6. Click **Next**. Historian shows how many rows will be imported and a preview of them.
7. Click **Confirm**.

If a cell does not match the type of its column, Historian lists the problems with their row numbers and you cannot confirm. Change the column type, or correct the file and import it again.

### File rules

- The file can be at most 16 MiB and hold at most 500,000 rows.
- From an Excel file, Historian reads the first sheet.
- A CSV file can use a comma or a semicolon as separator. Historian picks the one used most in the first line.
- An empty cell imports as an empty value.
- A **Boolean** column accepts `true`, `yes` and `1`, and `false`, `no` and `0`, in any case. Excel boolean cells work as well.
- Without a header row, the columns of a new table are named Column 1, Column 2, and so on. Importing into an existing table keeps its column names.

## Export a table

Exporting needs the `READ_LOOKUP_TABLES` privilege.

1. Click **Lookup tables** in the main menu and select the table.
2. Click **Export** at the top of the panel.

Historian downloads the saved rows as an Excel file named after the table. Unsaved changes are not included.
