Airtable to Xano

Why migrate from Airtable to Xano?

Scalability & Limits

At the time this document was last updated, Airtable's published pricing models offer a maximum of 500,000 records per base, and 1,000 GB of file storage.

Xano's database does not have a record limit, or a limit on file storage. We can scale infinitely to meet your data needs.

Performance & Capability

Airtable themselves say that it is not intended to use their platform for an application backend.

For this reason, it is important to note that Airtable is not intended to be a backend hosting service/real-time database like Heroku, Parse, Firebase, or MongoDB. Instead, Airtable is primarily designed for use cases where all users will be directly interacting within the Airtable UI. From Troubleshooting Airtable base performance

Airtable says this is because as the volume of requests to your Airtable base increases, it may not be able to perform as expected under such load.

Xano is built from the ground up to be a capable, scalable, and secure backend solution.

---

Migrating Airtable data to Xano

1

Head to the database and click

2

In the new table menu, choose Import Data > Import From Airtable

3

Provide your Airtable personal access token

You can generate a personal access token in Airtable by heading to your account settings, and from there visiting the Developer Hub.

Choose Personal Access Tokens from the left-side navigation, and create a token with the following scopes:

data:base.read
schema:base.read

4

Select the tables and/or views you want to import into Xano, and confirm your selection

---

Rebuilding Automations

While there is no direct migration of your Airtable automations to Xano, we want to make it as easy as possible to rebuild. Please see the table and linked resources below for common Airtable -> Xano functionality translations. Click on the Xano Function name to be taken to Xano's documentation, or review the video examples provided.

Airtable Function	Xano Function	Video Example
Create Record	Add Record	Video Example
Update record	Edit record	Video Example
Find records	Query all records	Video Example
Conditional logic	Conditional statement	Video Example
Repeating group	For each loop	Video Example
At scheduled time	Background task	Video Example
Link to another record	Table reference	Video Example
Lookup	Addons	Video Example