basestash

How to recover deleted Airtable records (and what to do when you can’t)

July 11, 2026 · Basestash

Someone deleted the wrong thing in Airtable. Depending on what was deleted and how long ago, recovery ranges from two clicks to impossible. Here is the decision tree, fastest option first.

1. Check the trash (deleted less than 7 days ago)

Deleted records go to the base trash and stay there for 7 days. Open the base, click the history icon (clock, top-right, next to Share), choose Trash, find the records, click Restore. Deleted fields and tables can also surface here. This is the happy path — if you’re inside the window, you’re done.

A whole deleted base has a longer grace period: it sits in the workspace trash for 30 days (up to 180 on some Enterprise configurations).

2. Check revision history (older than 7 days, record still exists)

If a record wasn’t deleted but changed — a field overwritten, wrong value pasted — expand the record and read its revision history in the right panel. How far back it goes depends on your plan: 2 weeks on Free, 1 year on Team, 2 years on Business, 3 on Enterprise Scale. Two catches: revision history shows changes per record (you copy values back manually, there’s no bulk revert), and it is deleted along with the record — it can’t resurrect something that’s already gone from trash.

3. Restore from an Airtable snapshot (destructive — read first)

Base history → Snapshots lists point-in-time copies of the whole base. The catch is big: restoring a snapshot replaces the entire base (as a new base rolled back to that moment). Every change made after the snapshot — by everyone, in every table — has to be reconciled by hand. Restoring one deleted record this way means rolling back thousands of others. It works, but it’s a last resort, and snapshot retention follows the same plan limits as revision history.

4. Restore from your backup

If you run a real backup, none of the windows above matter. With Basestash, you open the snapshot taken before the deletion, search for the record, and click restore — it’s recreated in Airtable with its field values, without touching anything else in the base. Snapshots are browsable, so you can confirm it’s the right record before restoring, and schedules run hourly to monthly so the gap between “lost” and “last copy” is as small as you want it.

5. If none of that works

Rebuild from side channels: CSV exports you may have taken, synced views in other bases, automation logs, connected tools (Zapier/Make run histories often contain the record payloads they processed), or email notifications. Painful, partial, but sometimes enough.

The uncomfortable summary

Airtable gives you 7 days of trash and a plan-limited revision history, and its own snapshot restore is all-or-nothing. That’s genuinely decent for an oops-just-now — and genuinely thin for a business that notices problems weeks later. If the data matters, put an independent backup on it before the next deletion, not after.

Basestash backs up your Airtable bases on a schedule, keeps every snapshot browsable, and restores lost records in one click.

Start your free 14-day trial