# 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-09-28

A complete import of your Airtable base to NocoDB within minutes

## Before you begin

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

## Access import modal

There are two ways to open the **Import from Airtable** modal:

**From the base context menu:**

1. Click on the base name in the sidebar to open the context menu.
2. Select **Import data** → **Airtable Base**.

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

**From the base dashboard:**

1. Click **Import Data** on the base dashboard.
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. Configure [Advanced Settings](#advanced-settings) if needed.
5. Click **Import Base**.

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

Once the import completes, you'll see the **Airtable Base Imported** confirmation. Click **Show Details** to view the import log, or **Go to base** to start working.

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

### Advanced settings

* **Import data** — When disabled, only the schema (tables and views) is imported without actual records.
* **Import secondary views** — When disabled, only the primary grid view for each table is imported.
* **Import rollup columns** — Toggle import of Rollup fields.
* **Import lookup columns** — Toggle import of Lookup fields.
* **Import attachment columns** — Toggle import of Attachment fields.
* **Import formula columns** — Formula field import is currently not supported (greyed out).

## Import report

The import does not stop at the first thing it cannot reproduce. Links, lookups, views, and each view's fields, filters, sorts and groups are imported one at a time, and anything that does not come across is recorded while the rest of the import carries on. Only a table that cannot be created at all ends the import.

When the import finishes it reports how many items were **skipped** (not imported at all), **approximated** (imported, but behaving differently from the Airtable original) and **failed** (attempted and rejected). **Download report** saves those items as a CSV with one row each, giving the kind, category, table, view, field, Airtable field type and the reason.

A long list is shortened in the report. The counts still cover every item, and the full list is in the import log under **Show Details**.

## Get Airtable Credentials

### Create Personal Access Token

1. Visit the [Airtable Create Tokens](https://airtable.com/create/tokens) page and click **Create token**.
2. Enter a name for your token.
3. Add the required access scope — minimum `data.records:read`.
4. Select the base you want to import.
5. Click **Create token** and copy the generated token.

For more details, see 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 for your base.
2. Open the **Share Publicly** tab.
3. Enable **Turn on full base access**.
4. Copy the generated shared base URL.

For more details, see [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): Learn how to create a base in NocoDB.
- [Folders](https://nocodb.com/docs/product/bases/folders.md): Organize tables, documents, and dashboards into collapsible folders in the base sidebar.
- [Base Collaboration](https://nocodb.com/docs/product/bases/base-collaboration.md): This article explains how to invite members or teams to your base, manage their roles, and remove them when needed.
- [Share Base](https://nocodb.com/docs/product/bases/share-base.md): Procedures to share a base & generating embedded iframe
- [Base Snapshots](https://nocodb.com/docs/product/bases/snapshots.md): Procedures to create and manage snapshots
- [Base Trash ☁](https://nocodb.com/docs/product/bases/base-trash.md): View, restore, and permanently delete trashed items — records, tables, views, fields, dashboards, widgets, workflows, scripts, and extensions — from a single base-level Trash.
- [Trash Settings ☁](https://nocodb.com/docs/product/bases/trash-settings.md): Configure per-table trash retention and disable trash on a per-table basis.
- [Private Base](https://nocodb.com/docs/product/bases/private-base.md): Learn how to configure and manage access to Private Bases in NocoDB.