Xano makes it easy to import your data from Airtable to your Xano database.
First, on the Xano database page, click "Add Table"
Click "Add Table"
Next, go to the "Import" tab and select Airtable.
After selecting "Add Table", go to the "Import" tab and select Airtable.
Enter in your Airtable API Key. This is found by going to your Account page in Airtable then clicking "Generate API Key." Once generated, copy the key and paste it into Xano.
Paste in your Airtable API Key.
How to find your Airtable API Key
Go to the Account page in Airtable. This is found by clicking on your user icon in the top right corner and clicking on "Account" in the drop down.
In Airtable, access your Account page by clicking your user icon in the top right corner, then selecting "Account."
Once on your Account page in Airtable, locate the Generate API Key button and click it to generate your API Key. (You may have one generated already, in that case, you may copy the existing one or re-generate a new one if you'd like).
On the Account page in Airtable, click Generate API Key.
Once you've entered in the Airtable API Key you will be able to connect to your Airtable account. You can choose a Base, table, and view to import from Airtable.
Choose a Base to import from Airtable.
Choose a table to import from Airtable.
Choose a View to import from Airtable.
Finally, confirm the import settings and click "Import."
Confirm the Import settings and select "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.
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
forumla -> 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.