Guides · Free tool
Airtable record counter and field audit
See how many records each table has, how close the base is to the record limit of each Airtable plan, and which fields are actually filled in. No signup.
Airtable record limits by plan
Record limits are per base and cumulative across all tables: two tables of 25,000 records count as 50,000.
| Plan | Records per base | API calls per month |
|---|---|---|
| Free | 1,000 | 1,000 per workspace |
| Team | 50,000 | 100,000 per workspace |
| Business | 125,000 | No monthly cap |
| Enterprise Scale | 500,000+ | No monthly cap |
Source: Airtable's plans overview and API call limits help articles. When a base reaches its limit, Airtable keeps your data but blocks new records until you upgrade or delete records.
What the field audit shows
- For every field: how many records have a value, as a count and a percentage.
- Fields that are empty in every record are flagged. They are good candidates to hide or delete when you clean up a base.
- Airtable's API leaves out empty values, so an unticked checkbox counts as empty.
How many API calls does this use?
Airtable returns at most 100 records per request, so counting takes one call per 100 records plus one for the schema. A base with 1,000 records uses about 11 calls. On the Free plan (1,000 calls per month) that matters for big bases, so the tool shows the count as it goes and you can close the tab at any time.
Archive old records before you hit the limit
A common way to stay under the record limit is to export old records to CSV and delete them from Airtable. ViewCourier emails any view as a CSV attachment on a schedule (daily, weekly or monthly), so an "Older than 1 year" view lands in your inbox as a file before you clean up.
Start 14-day free trial Read: automatic Airtable CSV backups
Also free: export every table to CSV in one ZIP · export the base schema as a data dictionary.
FAQ
Where does Airtable show the record count?
The record count of the current view is at the bottom left of the grid, and workspace owners can see records per base under Workspace settings, Usage. Neither gives you a per-table breakdown for the whole base or tells you which fields are unused, which is what this tool adds.
Do records in all tables count towards the limit?
Yes. The limit applies to the base as a whole, so the tool adds up every table.
Does the tool change anything in my base?
No. It only needs read scopes, and it only sends GET requests.
Is my token safe?
Requests go directly from your browser to Airtable's API; check your browser's network tab. Nothing is saved after you close the page.