Automatic Airtable backups to CSV: options and limits

Airtable keeps your data safe on its own infrastructure. A backup protects you from something else: an accidental bulk delete, a broken automation overwriting a field, a lapsed subscription, or simply wanting a copy outside Airtable. Here are your options.

What Airtable gives you natively

Record revision history and trash. These are good for undoing recent mistakes on individual records or restoring deleted items, within the retention window your plan offers.
Base snapshots. These restore a whole base to an earlier point in time, as a new base inside Airtable. They aren't a file you can download, and they live in the same account you're protecting.
Download CSV. This gives you a real file you own, but it's manual and covers one view at a time.

None of these produces an automatic, recurring copy of your data outside Airtable.

What a CSV backup covers, and what it doesn't

A CSV per table holds your field values: text, numbers, dates, select options, collaborator names, linked record names and attachment URLs. It doesn't hold:

field types and configuration, formulas (only their results), automations, interfaces or extensions;
attachment files themselves. Airtable attachment URLs expire after a few hours, so download the files separately if you need them;
record IDs, unless you add a formula field RECORD_ID() to the view. Add one: it makes restoring links much easier.

For most teams, value-level CSVs are the part that would hurt to lose. Schema and automations can be rebuilt, while years of records can't.

Setting up automatic CSV backups

Create a "Backup" view in each important table. Remove all filters, show every field, and add a RECORD_ID() formula field.
Pick a frequency that matches how much work you could afford to redo: daily for operational tables, weekly for slow-changing reference data.
Send the CSVs somewhere durable, such as a dedicated mailbox, or a mailbox with rules that forward attachments to cloud storage.
Test a restore once. Import a backup CSV into a scratch base and check that it looks right.

Ways to automate it

DIY script. Call the Airtable API from a cron job, paging 100 records at a time with the offset parameter and staying under 5 requests per second per base. Write the CSVs to storage. This gives you full control, but you maintain it.
Make or Zapier. These work, but each record usually counts as an operation, which gets expensive for full-table backups.
ViewCourier. Point it at each Backup view, pick daily at 02:00 in your timezone, and get a dated CSV such as Contacts-2026-03-02.csv in your backup mailbox every night. Pro handles up to 50,000 rows per export.

Let ViewCourier do it

Connect a read-only Airtable token, pick a view, and choose daily, weekly or monthly at your time and timezone. Every run emails a clean CSV attachment to up to five people. The free trial lasts 14 days and needs no credit card.