How To Export In Airtable
Last Updated: January 27, 2021
Do you want to access your data in Airtable offline? Or do you want to open it in a different spreadsheet app? Either way, you can choose to export one of your tables as a CSV file. If you’re not familiar with Airtable’s features, don’t worry, we’re here to help you. Follow our guide below to learn how to export your Airtable data to CSV.
Airtable is an app with features of a spreadsheet and database that can help you manage projects, schedule tasks, and store important information in a single platform. As long as you have an internet connection, you can access and edit all your work from your phone or computer.
But what if you need to view your projects when you don’t have a stable connection? Can you access your tables and data while you’re offline?
Unfortunately, Airtable doesn’t have an offline mode. However, you can choose to export your tables as CSV files beforehand and open them on other spreadsheet apps when you need to.
To help you, we have here a quick guide on how to export data in Airtable. Without further ado, let’s get started.
How to export a grid view to CSV on Airtable
Although Airtable doesn’t have a feature where users can access their data offline, you can choose to export your tables to CSV and view them on another spreadsheet app. You can also use this feature to save a backup for your data on the platform.
On your computer:
- Open the Airtable desktop app or web browser client and sign-in to your account.
- Select a workspace and open one of your bases.
- Choose a table and select one of your grid views.
- Open the view menu (three-dot icon) and click “Download CSV.”
Note: Exporting a table doesn’t include comments on your records, field descriptions, and application content.
After exporting your table to CSV, you can now access and view your data on another spreadsheet app like Excel or Google Sheets. All you have to do is import the file to the app, and you’re good to go. You can even view your data while you’re offline.
Please note that you can only export one table at a time. So if you want to get a whole base on your project, you have to download each table as CSV. In addition to that, you need to export any attachments on your table separately.
Unfortunately for mobile users out there, the feature to export a table isn’t available on the Airtable app on Android. However, you can use desktop view on your mobile web browser to visit Airtable and export your data.
How to import Airtable data to Google Sheets with Coupler
If you don’t mind using third-party apps to import your table, you can use Coupler.io to share your Airtable data to your Google Sheets. All you have to do is install the add-on and use the Sharable view link on Airtable to import your data.
Follow our step-by-step tutorial below:
- Visit Google Sheets on your favorite web browser and sign-in to your account.
- Start a new spreadsheet or open an existing one.
- Click Add-ons > Get add-ons.
- Search for Coupler.io and click the Install button. If prompted, sign-in to the app with your Google account.
- On the left side of your screen, click “Add importer” and select Airtable as the data source. If you can’t see the app window, click Add-ons > Coupler.io > Open dashboard.
- Change the title, and enter the Share view link on the empty field under “Source.”
- Scroll down and click “Save & Run.”
Once the app finishes importing your data, you can find it as a new sheet on your document. If you don’t want to import the table every time you make some changes, you can enable “Automatic data refresh” on your Coupler add-on settings.
To sum it all up
To view and access your Airtable project offline, you can choose to export each of your tables as CSV and open the files on another spreadsheet app like Excel or Google Sheets. Please remember that exporting doesn’t include comments on your records, descriptions, and app content.
If you don’t want to download CSV files manually or don’t mind using third-party apps to transfer data, you can use add-ons on Google Sheets to import your tables directly from Airtable.
That’s all from our guide about exporting data on Airtable. For the latest tips, tricks, and tutorials, click the bookmark button, and visit us regularly for our daily posts and updates.