Import Airtable to NocoDB

NocoDB allows a complete import of your Airtable to any MySQL, Postgres, SQLite and SQL server databases within minutes.

Get Airtable Credentials

Retrieve API Key

• Copy your Airtable API Key from Airtable Accounts page

  

Retrieve Share Base ID / URL

See here for detailed procedures.

1. Open Share menu in your Project / Base

2. Open tab Share Publicly

3. Enable Turn on full base access

4. Copy generated shared base URL

Import Airtable to NocoDB

Below are 3 simple steps

1. Go to your Project, Open Add / Import menu and click Airtable.

2. Input API key & Shared Base ID / URL (retrieved from Get Airtable Credentials above).

• <1> API Key
• <2> Share Base ID
• <3> Configuration option
  • Import Data: disable this option to import only table & view schema's
  • Import Secondary Views: disable this option to import only primary grid view per table
  • Import Rollup Columns: disable this option to skip Rollup column import
  • Import Lookup Columns: disable this option to skip Lookup column import
  • Import Attachments Columns: disable this option to skip Attachment column import
  • Import Formula Columns: disable this option to skip Formula (computation) column import

3. Click Import and you will see the status
4. Wait until Go To Dashboard button is activated on the modal. Import details are captured in log window.