The use of Baserow as a database for organizations is growing in popularity due to how easy it is to integrate data across teams and keep workflows in sync in an intuitive and centralized manner.
Migrating an Airtable base to Baserow might sound daunting, but it is actually a very simple process. Baserow’s powerful import tool makes the transition from Airtable simple.
In this article, we will walk you through the general workflow as well as the specific preparation steps to make this process as seamless as possible.
To migrate your Airtable base to a Baserow workspace, you need:
We tested the import feature with various types of bases and configurations. When you import your data in Baserow, your tables, fields and data will be imported. The data for all of your rows in a table will be automatically filled.
Airtable views are combinations of sorts, filters, workspaces, hidden columns, and other elements. Thus, although most of your data will be imported, the table views will not be imported. You can manually create the views after the import.
There are only slight differences between most of the field types in Baserow and Airtable. This table details the differences in field types and how to manage them:
|Airtable Column Type||Corresponding Baserow Field Type|
|Single line text||Single line text|
|Long text||Long text|
|Single select||Single select|
|Multiple select||Multiple select|
|Phone number||Phone number|
|Link to another record||Link to table|
|Created time||Created on|
|Last modified time||Last modified|
The following Airtable field types will not be imported into Baserow. Before importing the data, you have the option of changing the field type. These fields can be modified in Airtable and imported into Baserow as text or number.
Now let’s get into how to migrate from Airtable to Baserow.
Create an account or log in to your existing Baserow account. We will then create a workspace.
Baserow is organised into workspaces. A workspace is a workspace where you can store multiple databases and invite collaborators. Each workspace has users invited to become members.
On the Dashboard page where you can see an overview of all your workspaces and databases, click the ‘+ Create workspace’ button. This button will also be visible on the sidebar:
The simplest way to move your Airtable data over to Baserow is with the import feature. You need to have a shared link to your entire Airtable base to import your base.
A database is a collection of tables, each containing rows and columns. A Baserow database can include multiple tables containing information for different projects.
Within your Airtable, click the ‘Share’ button in the top right corner. Then, choose the ‘Base All records’ option. In the ‘Share publicly’ modal, toggle on the ‘Enable shared base link (read-only)’ button to turn on full base access.
Copy the public link to your clipboard:
The next step is to bring your Airtable data into Baserow.
Navigate to your Baserow workspace. From the right-hand sidebar in Baserow, click the ’+ Create new’ link. Then click ‘Database’.
Next, select the ‘Import from Airtable (beta)’ tab. Paste the Airtable public link you copied earlier into the input field then, click the ‘Import from Airtable’ button.
The import will create a database and a table within the database.
You can view the import progress as the base schema is downloaded. For more detailed instructions view this article about importing from Airtable.
The Baserow import feature is still in beta. We encourage you to try it out, experiment with it, and let us know if you have any feedback about it.
An imported Airtable base is added as a new database to a workspace. This may be a limitation if you want to add the data to an existing Baserow database.
Another way to move your Airtable data over to Baserow is via file import. Baserow allows you to import tables or rows into an existing database from CSV, XML, or JSON files.
For more detailed instructions, view this article about importing files into Baserow.
That’s it! You’ll now start to see your table populate in real time with your new rows. Once imported, you can search for your data from anywhere in your database and add new field types by clicking the + icon in the table.
What’s your story? Tell us how you use Baserow
Today we are releasing Baserow 1.17 with huge performance improvements for high volumes of data, calendar view, ARM images & more…!
Want to write a post in collaboration with us?How to contribute?