Google Sheets importer

This article is an overview of a feature that allows you to import an entire Google Sheets file as a new base or import one into an existing base. Note that once you have imported data into Airtable, any changes made within Airtable will not be reflected back to the original Google sheet you used for importing. If you'd like to see how new rows added to a Google Sheet can be automatically added to a table in your base via automations — check out this support article.

Import a Google Sheets file

There are three ways to import an Excel file in Airtable:

1. Import a file as a new table in a new base.
2. Import a file to an existing table.
3. Import a file to an existing base as a new table.

Import a file as a new table in a new base

Starting from the Airtable home screen, select the option to “Add a base." Next, click the "Google Sheets" option in the "Getting started" section on the right side of the screen.

If you've already begun building and creating in this base and happened to leave the "Getting started" sidebar open, then clicking this button will create a new base. You'll have the open to save or discard the current base you are working in.

Import a file to an existing table

If you already have a table set up where you would like to import the file, then click the drop-down icon next to the name of the table where you'd like the information to be added. You'll then click the "Import data" option and click "Microsoft Excel."

Once you select the Sheet a new base will be created. Each sheet in your Google Sheet workbook will be converted to a table in your Airtable base. And, we’ll automatically try to convert data into Airtable field types.

Import a file to an existing base as a new table

You can also add a new table to an existing base by clicking the "+Add or import" button to the right of the last table in your base.

Import wizard

Any of the three options highlighted above will open up an import pop-over where you can select a file from your local device or other file sources.

After selecting a file to import, you'll see the option to choose where this file will be imported. Even though you may have already chosen to import the file as a new table, you'll have the option to switch to an existing table and vice versa.

After clicking the "Next" button, you will then see a preview of how your data will appear in Airtable as a grid view. Here, you can make adjustments that will automatically show up in the preview window.

In the GIF above, you'll see that you can:

• Manually adjust field types
• Choose which fields (columns) to import
• Adjust other settings (auto-select fields types and/or use first rows as headers)

If it's your first time importing, then click around and adjust all of the options to see how the import will change. Since this is just a preview of the import, you can't break anything in the base, so don't fear!

How data is converted from Sheets to Airtable

When you import a Google Sheet, each sheet in the workbook will be converted to its own table. The sheet name will be converted to the table name. For each sheet, the first row will be treated as field names (similar to our CSV import feature). If that row is empty, a fallback field name will be automatically generated.

Supported cell types and formatting

In Google Sheets, each cell can have a specific type that may or may not have a similar field type in Airtable. Our importer will make a best effort attempt to convert cells to the Airtable field counterpart. Below is an outline of how we handle various cell type conversions when you import a file into Airtable.

FAQs

Can I import data from a Google Sheet into an existing table within my base?

Yes, you can! One workflow to accomplish this is to first convert your Google Sheet into a CSV, then use the CSV Import extension to import your new CSV. You could also copy and paste the data from your Google Sheet by following the directions in this article.

What is the file size limit per import?

Currently, the file size is limited to 5MB.