Skip to main content

Import Data from Airtable

You can import data from Airtable into AITable to quickly start using AITable to grow your business.

Install the widget​

To install importing widget, open widget center and click the widget.


Using the widget​

When using the widget, you need to provide the API key, base ID, table ID and view ID (optional) of your Airtable account. Base ID, table ID and view ID (optional) can usually be obtained from the Airtable link.

The following are detailed instructions telling you how to obtain the information needed:

  1. How to get API key: You can look through Airtable's official documentation or click to this website Airtable Account to directly get it.


  1. How to get the base ID: In addition to the link, you can also click the website Airtable Rest API to get it. Firstly, you need to select the base from which you want to import, and then the instruction page will show you a specific base ID to copy.


  1. How to get the table ID: In addition to the URL link, you can also click this website Airtable Rest API to get it. Firstly, select the table you want to import, and then the instruction page will show you a specific table ID to copy.

  1. How to get view ID: If you want to import the data from a particular view, you need to fill in the view ID of Airtable. Similarly, you can get it from the URL link. Usually, the view ID is the string beginning with viw in the URL, as follows:


Common problems​

1. Authentication failed​

  • unauthorized, invalid authentication token
  • authentication_required

The error messages above indicate you provide invalid API key. The solution is to check if the API key used is the same as the API key provided on the Airtable Account page.


2. Permission issues​

  • invalid_permissions
  • Invalid_permissions (field or table operation limits)

The error messages above indicate you don't have related permission to import data. The solution is to check if your account is configured with all permissions needed to import the table.


3. Data souce problems​

  • NOT FOUND
  • BASE NOT FOUND
  • MODEL ID NOT FOUND
  • TABLE NOT FOUND：Could not find table tblxxxxxxxx in application appxxxxxxxx
  • VIEW NAME NOT FOUND

The error messages above indicate corresponding base, table or view are not found. The solution is to check if the base ID, view ID, table ID used are correct.


4. Field types supported for importing​

  • Attachment
  • Single line text
  • Long text
  • Multiple select
  • Number
  • Rating.Default rating symbol is star.
  • Checkbox
  • Date.Default format is 'YYYY/MM/DD'
  • URL
  • Currency
  • Percent, with retained 2 decimal places.
  • Phone number
  • Email
  • Single select
  • Formula
  • User
  • Lookup
  • Rollup
Last updated on