Skip to content

Exporting Data

Downloading CSV File

Downloading tables as CSV files is the easiest way to export your data from Airtable. You can download data from one table at a time, and Airtable will only download data visible in the active view. To download your data:

  1. Navigate to a table in your base.
  2. Select the view would like to download.
  3. Select the name of the view in the “View Ribbon” (next to “Hide Fields”).
  4. Select “Download CSV”.
  5. Repeat for other tables in your base.

Airtable Sync

Airtable Sync lets users sync records between bases. Sync essentially embeds a shared view from a source table to a destination table.

Airtable Sync is unavailable on free plans, and its functionality is limited for Team plans. Business and Enterprise plans have access to two-way syncing and multi-source syncing.

Airtable API

If you would like to set up an automated backup or download entire bases at a time, this can be done through the Airtable API

Airtable's API uses JSON objects to represent Airtable records. Through the REST API, you get records, with a limit of 5 requests per second per base. Airtable's official API client is a JavaScript library, and there are community built API clients for Ruby, .NET, and Python.

API access is authenticated using Personal Access Tokens, which can be created in Airtable's “Builder Hub”. Monthly rate limits vary by plan level, starting with 1,000 calls per month on the free plan.

For a detailed description of using the Airtable API to export bases, see William K. Dewey's "Using Airtable to download and parse Digital Humanities Data".

Further Reading

This tutorial is licensed under Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0).