In this article we will show how to automatically export Airtable to Google Sheets in just a few clicks. Simply follow the steps below:
Open an Airtable base, then select one of the tables along the tabs. For this example we have a Product catalog base, and we select the Furniture table to export.
Next, we click the icon next to the label Views, which includes the name of the table. For this example it is labeled All furniture. Click it.
A drop-down list will appear when you click it. Select Download as CSV.
A warning will appear regarding Attachment links expiring. Click Okay.
The file will be downloaded to your computer. Open the folder where it is located.
Go to Google Sheets and either open a spreadsheet or create a new one. Afterwards, click FIle then select Import.
The Import file box will appear. Click the UPLOAD tab.
Drag the Airtable CSV file we exported earlier to the blank space below the Upload tab of the Import file box.
The initial Import file box will be replaced by a smaller box containing import settings. These are the Import location and the Separator type.
The Import location sets where the data from the Airtable CSV file will be added to. We will select Insert new sheet(s) to tell Google Sheets to insert the data as a new sheet to the active spreadsheet.
We then set the separator type. Since the Airtable CSV file uses commas to delineate the cells, we set this to Comma.
Here are the settings we will use for this example. You can check our tutorial on importing CSV to Google Sheets for more details about the import options. (link)
The data will now be inserted. You are free to edit the data depending on what you need.
We hope this article has helped you and given you a better understanding on how to export Airtable to Google Sheets. You might also like our articles on how to connect Snowflake to Google Sheets and connect Salesforce to Google Sheets.
To optimize your workflow, we recommend reading our guide on how to export an email address from Google Sheets.
