# Import Airtable to NocoDB

> Part of the NocoDB documentation (Product docs > Projects). 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/projects/import-project-from-airtable
Last updated: 2026-10-09

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

## Before you begin

You need a [shared base or shared view URL](#retrieve-share-base-id--url) from Airtable. To import the records of a shared base, you also need an Airtable [Personal Access Token](#create-personal-access-token). A shared view URL does not need a token.

## Access import modal

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

**From the project context menu:**

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

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

**From the project dashboard:**

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

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

## Configure and import

1. In **Personal Access Token**, enter your [token](#create-personal-access-token). For a shared view URL, leave this field empty.
2. In **Shared base or view URL**, enter your [Airtable link](#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 Project**.

<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 from a shared view

A shared view URL imports one table: the table that the view is on. Airtable usually hides the table name in a view share. When it does, the imported table takes the name of the view. NocoDB imports the records that the view shows, in the order of the view, and leaves out the records that the view hides.

Airtable does not send the linked tables with a shared view. So NocoDB imports these fields as plain fields that hold the values that Airtable shows:

| Airtable field             | Imported as                                    |
| -------------------------- | ---------------------------------------------- |
| **Link to another record** | Single line text                               |
| **Lookup**                 | Long text                                      |
| **Rollup**, **Count**      | A field of the result type, with static values |
| **Formula**                | A field of the result type, with static values |

A shared gallery, kanban or calendar view imports as a Grid view.

The [import report](#import-report) lists each of these as **approximated**. When Airtable does not send all the records of the view, the report lists the missing records as **skipped**.

## 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 project 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 project access**.
4. Copy the shared base URL.

To use a shared view URL instead, create a share link for the view in Airtable and copy it. Refer to [Import from a shared view](#import-from-a-shared-view) for what a view share brings across.

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 Project](https://nocodb.com/docs/product/projects/create-project.md): Create a NocoDB project from scratch, from a template or with AI.
- [Folders](https://nocodb.com/docs/product/projects/folders.md): Organize tables, documents, and dashboards into collapsible folders in the NocoDB project sidebar.
- [Project Collaboration](https://nocodb.com/docs/product/projects/project-collaboration.md): Invite members and teams to a NocoDB project, manage their project roles, and remove their access.
- [Share Project](https://nocodb.com/docs/product/projects/share-project.md): Share a NocoDB project with a public read-only link, set a custom URL, and embed the project in an iframe.
- [Project Snapshots](https://nocodb.com/docs/product/projects/snapshots.md): Create, restore and delete point-in-time snapshots of a NocoDB project.
- [Project Trash ☁](https://nocodb.com/docs/product/projects/project-trash.md): Use NocoDB Project 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/projects/trash-settings.md): Set the trash retention period for each table in a NocoDB project, or turn off trash for a table.
- [Private Project](https://nocodb.com/docs/product/projects/private-project.md): Set up a Private Project in NocoDB and control who can access it, separate from workspace roles.