# Import Airtable to NocoDB

> Part of the NocoDB documentation (Product docs > Bases). Index of all pages: https://nocodb.com/llms.txt. Any docs page is available as Markdown by adding `.md` to its URL.

URL: https://nocodb.com/docs/product/bases/import-base-from-airtable
Last updated: 2026-10-03

Import a complete Airtable base into NocoDB in a few minutes.

## Before you begin

You need a valid Airtable [Personal Access Token](#create-personal-access-token) and a [Shared Base ID / URL](#retrieve-share-base-id--url).

## Access import modal

You can open the **Import from Airtable** modal in two ways.

**From the base context menu:**

1. In the sidebar, click the base name. The context menu opens.
2. Select **Import data** → **Airtable Base**.

<img alt="import data" src={__img0} placeholder="blur" />

**From the base dashboard:**

1. On the base dashboard, click **Import Data**.
2. Select **Airtable**.

<img alt="import data" src={__img1} placeholder="blur" />

## Configure and import

1. Enter your [Personal Access Token](#create-personal-access-token).
2. Enter your [Shared Base ID / URL](#retrieve-share-base-id--url).
3. Select a **Data Source** (Default or an external connection).
4. If necessary, configure the [Advanced Settings](#advanced-settings).
5. Click **Import Base**.

<img alt="import data" src={__img2} placeholder="blur" />

When the import is complete, the **Airtable Base Imported** confirmation shows. To see the import log, click **Show Details**. To start work in the base, click **Go to base**.

<img alt="import data" src={__img3} placeholder="blur" />
<img alt="import data" src={__img4} placeholder="blur" />

### Advanced settings

| Setting                       | What it does                                                                                  |
| ----------------------------- | --------------------------------------------------------------------------------------------- |
| **Import data**               | When off, NocoDB imports only the schema (tables and views), without records.                 |
| **Import secondary views**    | When off, NocoDB imports only the primary grid view of each table.                            |
| **Import rollup columns**     | Turns the import of Rollup fields on or off.                                                  |
| **Import lookup columns**     | Turns the import of Lookup fields on or off.                                                  |
| **Import attachment columns** | Turns the import of Attachment fields on or off.                                              |
| **Import formula columns**    | NocoDB does not support the import of Formula fields at this time. The setting is greyed out. |

## Import report

The import does not stop at the first item that it cannot copy. NocoDB imports these items one at a time:

* links
* lookups
* views
* the fields, filters, sorts and groups of each view

When an item does not import, NocoDB records it and continues with the other items. Only a table that NocoDB cannot create stops the import.

At the end, the import shows the number of items in each of these categories:

| Category         | Meaning                                                                        |
| ---------------- | ------------------------------------------------------------------------------ |
| **skipped**      | NocoDB did not import the item.                                                |
| **approximated** | NocoDB imported the item, but it works differently from the Airtable original. |
| **failed**       | NocoDB tried to import the item, and the import was rejected.                  |

Click **Download report** to save these items as a CSV file, with one row for each item. Each row gives the kind, category, table, view, field, Airtable field type and reason.

The report shortens a long list. The counts still include all items. The full list is in the import log, under **Show Details**.

## Get Airtable Credentials

### Create Personal Access Token

1. Go to the [Airtable Create Tokens](https://airtable.com/create/tokens) page.
2. Click **Create token**.
3. Type a name for the token.
4. Add the necessary access scope. The minimum scope is `data.records:read`.
5. Select the base that you want to import.
6. Click **Create token**.
7. Copy the token.

For more information, refer to the [Airtable Personal Access Token guide](https://airtable.com/developers/web/guides/personal-access-tokens).

<img alt="image" src={__img5} placeholder="blur" />
<img alt="image" src={__img6} placeholder="blur" />
<img alt="image" src={__img7} placeholder="blur" />

### Retrieve Share Base ID / URL

1. In Airtable, open the **Share** menu of your base.
2. Open the **Share Publicly** tab.
3. Turn on **Turn on full base access**.
4. Copy the shared base URL.

For more information, refer to [Airtable's share link guide](https://support.airtable.com/hc/en-us/articles/205752117-Creating-a-base-share-link-or-a-view-share-link#basesharelink).

<img alt="Shared base" src={__img8} placeholder="blur" />

---

## Related pages

- [Create Base](https://nocodb.com/docs/product/bases/create-base.md): Create a NocoDB base from scratch, from a template or with AI.
- [Folders](https://nocodb.com/docs/product/bases/folders.md): Organize tables, documents, and dashboards into collapsible folders in the NocoDB base sidebar.
- [Base Collaboration](https://nocodb.com/docs/product/bases/base-collaboration.md): Invite members and teams to a NocoDB base, manage their base roles, and remove their access.
- [Share Base](https://nocodb.com/docs/product/bases/share-base.md): Share a NocoDB base with a public read-only link, set a custom URL, and embed the base in an iframe.
- [Base Snapshots](https://nocodb.com/docs/product/bases/snapshots.md): Create, restore and delete point-in-time snapshots of a NocoDB base.
- [Base Trash ☁](https://nocodb.com/docs/product/bases/base-trash.md): Use NocoDB Base Trash to view, restore, and permanently delete deleted records, tables, views, fields, dashboards, widgets, workflows, scripts, and extensions.
- [Trash Settings ☁](https://nocodb.com/docs/product/bases/trash-settings.md): Set the trash retention period for each table in a NocoDB base, or turn off trash for a table.
- [Private Base](https://nocodb.com/docs/product/bases/private-base.md): Set up a Private Base in NocoDB and control who can access it, separate from workspace roles.