tutorials
Back to overview

How to Migrate from Airtable to Baserow in one Click

Airtable to baserow

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.

What you need

To migrate your Airtable base to a Baserow group, you need:

How data is imported

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, groups, 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
Attachment File
Single select Single select
Multiple select Multiple select
Checkbox Boolean
URL URL
Date Date
Phone number Phone number
Email Email
Number Number
Currency Number
Percent Number
Duration Number
Rating Rating
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.

  • Formula
  • Lookup
  • Last modified by
  • Created by
  • Button
  • Barcode
  • User
  • Rollup
  • Count
  • Auto number

Now let’s get into how to migrate from Airtable to Baserow.

Create a group

Create an account or log in to your existing Baserow account. We will then create a group.

Baserow is organised into groups. A group is a workspace where you can store multiple databases and invite collaborators. Each group has users invited to become members.

On the Dashboard page where you can see an overview of all your groups and databases, click the ‘+ Create group’ button. This button will also be visible on the sidebar:

enter image description here

Create a new database from Airtable base import

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:

enter image description here

Import to Baserow

The next step is to bring your Airtable data into Baserow.

Navigate to your Baserow group. 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.

enter image description here

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.

Import into an existing database

An imported Airtable base is added as a new database to a group. 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.

  1. Navigate to your view in Airtable and click the view’s name. Select Download CSV from the dropdown menu.
  2. Navigate to your Baserow database or table and select Import from the menu. Choose your .csv file from your computer when prompted. Baserow will create tables in your database as well as rows in the view once imported.
  3. Your Airtable data will probably have several fields associated, such as email address, sales stage, contract value, etc. If prompted, choose the appropriate types for each field to map them over; otherwise, Baserow will recognise and match most attribute types automatically. If you no longer need a particular column, you can also opt not to import it.

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.

release
November 3, 2022 by Bram Wiepjes
1.13 release of Baserow

Today we are announcing Baserow 1.13 with two new security features as a part of Baserow Enterprise: role-based access control and single sign-on.

info
May 21, 2020 by Bram Wiepjes
Best Airtable alternatives
info
July 14, 2022 by Hiram
The no-code landscape