Select Page
How to View Airtable Data Offline or Locally

How to View Airtable Data Offline or Locally

On2Air Help CenterOn2Air Help Center > On2Air BackupsOn2Air Backups Start a free trial

Sometimes, you may need to use Airtable when you don’t have an internet connection, bad service, or are offline. While there is no specific Offline feature in Airtable, you can view your data offline by using On2Air Backups and your storage provider, such as Google Drive, Dropbox, or Box.

In this tutorial, you’ll learn how to set up your Airtable data and files to quickly view data while you’re offline.

What is On2Air Backups?

On2Air Backups creates automated backups of your Airtable data and sends the data to your storage drive in Google Drive, Dropbox, and Box.

In this tutorial

Why Our Customers Use On2Air Backups

Many of our customers create an automated Airtable backup with On2Air Backups for one or more of the following reasons:

  • Backup Best Practices (3-2-1 backup structure)
  • Compliance
  • Protect their own data
  • Protect their client’s data
  • Data redundancy
  • Company growth with more users editing Airtable data
  • Full Revision history
  • Failsafe if access to Airtable is lost
  • Ability to always have your data, no matter the software used
  • If ever needed to move to a software solution other than Airtable

Data backups aren’t meant to be an afterthought, they are deemed an essential element for ensuring cybersecurity in businesses and organization.

Can I view my Backup files offline?

You can view your Airtable data in a backed up version of your Base, table, and attachments in your storage drive. The files should be used only as a reference for viewing data, not editing data. Any changes you make in your CSV file are not synced back into Airtable.

⭐
IMPORTANT: Before being able to use the files offline, you must first make each CSV file “Available Offline” in your storage provider. See instructions below.

On2Air Backups creates the backup files as CSV files and each table from your Airtable base is its own CSV file. You’ll need to make each CSV file available offline, essentially making each Table from your base offline. You can pick and choose which Tables you need to use offline.

Regarding Linked Records - We display the Linked Record as a Record ID. We are unable to create automatic links from a record to an attachment.

To see which record is related, you can create a Lookup field in your table to see the actual linked record name.

You won’t be able to to click to get to the linked record like you do in Airtable. You will need to open the other Linked table file and search via Record ID.

How to view Airtable data offline

First, you’ll need to install On2Air Backups and connect it to Airtable.

In the On2Air Backups Trial, we allow 1 Airtable Base, 10 Tables, 100 Records per table, and 25 Attachments (total). After the trial creates a backup to your storage drive, it deactivates. You do not have to upgrade to use the Offline option. You just won’t have your entire Airtable base backed up.

To enable an automated backup schedule and to backup your entire Airtable base(s), upgrade to a plan . Once you’ve upgraded, you’ll then need to set the Schedule and Reactivate the backup.

1. Install the On2Air Backups Extension in your Airtable Base

  • First, open your Airtable base and click Extensions
image
  • Click Add an extension
image
  • Type On2Air in the search box and choose On2Air Backups
image
  • Click Add Extension to add it to your Airtable base
image
  • You’ll now click Create New Account to create an On2Air account. You’ll go through the account creation process.

If you’ve ever added On2Air Backups to other bases in your Airtable workspace, Select your On2Air account.

image

2. Connect Your Airtable Account

Now, you’ll need to connect your Airtable account

  • Click the Configure Airtable API button
image
‣

You can label the Connection whatever you would like

  • Next, Activate the Airtable Connection toggle
  • Click Save Changes
  • Close out the popup and click the Configure Airtable API button again. This will refresh the app to accept your token.
image

Final

image