Airtable Import

Import a sheet from Airtable into the Xano database

Xano makes it easy to import your data from Airtable to your Xano database.

First, on the Xano database page, click "Add Table"

Select "Add Table"

Next, select "Import data."

Select "Import data"

Then, select Airtable.

Select import with Airtable.

Enter in your Airtable Access Token / API Key.

Airtable is discontinuing API keys in favor of generated access tokens. Your existing API keys will continue to work until early 2024. For new imports, we recommend generating an access token using the instructions below.

Add your Airtable Personal Access Token.

How to find your Airtable Access Token

1. Go to the Create Token page in Airtable and choose "Create New Token"

It's crucial to add the following scopes and your base, or your tables will not show.

1. Give your access token a name, and add the data.records:read and schema.bases:read scopes.

2. Add your base by clicking "Add a base" and choose Create Token.

1. Click the copy button on the box that appears to copy your new access token.

---

Once you've entered the Airtable access token, you will be able to connect to your Airtable account. Next, choose an Airtable Base to import.

Choose an Airtable Base to import

Choose which tables from your Base to import. Additionally, select which view from each table to import (or import all data from the table). Select if you want Xano to import attachments from the Base (recommended). Finally, select if you want Xano to automatically generate CRUD API endpoints for each table (you can always set these up later).

Finally, once you're ready confirm the import settings and click "Import."

Depending on how much data you are importing this may take several seconds. Airtable only allows for 100 records of data per second to be sent through their API, so please keep that in mind.

A progress cursor may show in the left navigation bar for the import. You can also monitor the progress from the Settings page in your workspace. Xano will also email you once the import is complete -- in case you need to leave and come back.

Supported Data Types

The following are supported data types that can be imported from Airtable and the data types in Xano which they will be imported as.

• count -> integer

• formula -> text

• autoNumber -> integer

• duration -> text

• barcode -> text

• rating -> integer

• currency -> decimal

• percent -> decimal

• richText -> text

• singleLineText -> text

• multilineText -> text

• phoneNumber -> text

• url -> text

• email -> email

• singleSelect -> enum (text default)

• multipleSelects -> [] enum (text default)

• number -> decimal

• checkbox -> boolean

• lastModifiedTime -> timestamp

• date -> timestamp

• multipleRecordsLinks -> [] integer (table reference)

• createdBy -> integer (table reference)

• lastModifiedBy -> integer (table reference)

• singleCollaborator -> integer (table reference)

• multipleCollaborators -> [] integer (table reference)

• multipleAttachments -> [] attachment (text default)

• Rollup -> text*

*Rollup is a formula-based data type unique to Airtable, we are only able to import a text copy of the data.