Import Airtable base to Baserow

Baserow allows you to import data as a new database into an existing workspace within minutes.

If you’re familiar with Airtable databases, diving into a new platform can seem daunting. But, there’s no need to be overwhelmed! There are easy ways to transition.

Create a new database from Airtable import

Prerequisites

You need to retrieve your base share link from Airtable.

  1. In Airtable, click on the Share button in the top right corner after opening your base.
  2. Next, choose the Base tab.
  3. Click on the Share publicly button in the share modal.
  4. Enable shared base link (read-only) to turn on full base access.
  5. Copy generated shared base URL.

If you’re unable to find it, see Airtable’s help and support documentation for detailed guidelines on creating a base share link or a view share link.

Create a new database from Airtable import

To import your Airtable base, go to your Workspace

  1. Click the + Create new button in the workspace you want to add the database to
  2. Select Database from the dropdown option
  3. Switch to the Import from Airtable tab
  4. Get the shared link to your entire Airtable base.
  5. Copy the shared base public link and paste it into the Baserow input field.
  6. Click Import from Airtable.

Import Airtable base to Baserow

Data import process

We have extensively tested the import feature with various types of bases and configurations. When you import your data into Baserow, your tables, fields, and data will be imported seamlessly. All the rows in your table will be automatically filled with data.

Airtable views consist of combinations of sorts, filters, hidden columns, and other elements. While most of your data will be imported, there are several aspects of your Airtable database and tables that will not be imported.

  1. Views - Views and their respective settings will need to be remade in Baserow.
  2. Filter settings will not be imported
  3. Sort settings will not be imported
  4. Group settings will not be imported
  5. Color formatting settings will not be imported
  6. Hidden field settings will not be imported
  7. Row height - settings will not be imported

There are only minor differences between most of the field types in Baserow and Airtable. To help you manage these differences, refer to the following table:

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

Some additional notes on this:

  • Duration fields will be imported as a whole number and can be converted to respective duration field by simply changing the field type to duration and selecting the same duration setting as it was in Airtable.
  • Percentages will be imported as zeroes.
  • Currencies are treated as whole numbers without decimals and without the currency symbol
  • Numbers will not have their formatting imported
  • Dates set to Date (local) and Date (friendly) will be imported as Date ISO
  • Single and Multi-select fields options colors may slightly differ from Airtables
  • Long text fields will not have the rich text formatting imported

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 numbers.

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

Additionally to fields, the following items will not be imported:

  • Row comments
  • Row revision history
  • Field descriptions
  • Access control settings

You can also add a database from a template or create a database from scratch.


Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions—we’re ready to assist you.

   Ask the Baserow community

   Contact support for questions about Baserow or help with your account.