# Spreadsheet and operational table APIs for AI agents

> 10 spreadsheets & operational tables ranked by the Anchor benchmark. Leader Google Sheets API (BB). Spreadsheets and table products an agent can read and write. Cells, ranges and formulas in a workbook, or typed records in a base. Compared on read and write calls, batch limits, formulas, change events and how access to one file is scoped.

- Canonical: https://www.anchorterminal.com/categories/spreadsheets
- Markdown: https://www.anchorterminal.com/categories/spreadsheets.md (~3,300 tokens)
- Slim: https://www.anchorterminal.com/categories/spreadsheets.min.md (~530 tokens, same facts, less prose, for token-sensitive contexts)
- JSON: https://www.anchorterminal.com/categories/spreadsheets.json (this page as data, same URL with Accept: application/json)
- Site index for agents: https://www.anchorterminal.com/llms.txt (full text: https://www.anchorterminal.com/llms-full.txt)
- API: https://www.anchorterminal.com/api/v1/index.json
- Updated: 2026-10-08

Spreadsheets and table products an agent can read and write. Cells, ranges and formulas in a workbook, or typed records in a base. Compared on read and write calls, batch limits, formulas, change events and how access to one file is scoped.

- Tools ranked: 10 · agent-ready (BB or better): 3 · accept x402: 0 · hosted endpoints: 10 · desk reviews by the panel: 0
- JSON: https://www.anchorterminal.com/api/v1/tools.json (list) · https://www.anchorterminal.com/api/v1/rankings.json (ranked) · https://www.anchorterminal.com/api/v1/x402.json (payable) · https://www.anchorterminal.com/api/v1/capabilities.json (by capability)
- Grades run AA, A, BB, B, C, D, E, F · methodology: https://www.anchorterminal.com/benchmark/

- Capabilities in this category: sheets.read, sheets.write, sheets.tables, sheets.formulas, sheets.records
- https://letme.dev/sheets.read picks the top-graded tool in this list and says how to call it direct; calling through letme comes later (https://www.anchorterminal.com/letme/index.md)

## Ranking

| # | Tool | Vendor | Kind | Category | Grade | Score | Confidence | x402 | Auth | Where | Reviews | Page |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 33 | Google Sheets API | Google | HTTP API | Spreadsheets | BB | 76.3 | medium | no | OAuth | hosted | none | https://www.anchorterminal.com/tools/google-sheets-api.md |
| 37 | NocoDB | NocoDB Inc | HTTP API | Spreadsheets | BB | 75.7 | medium | no | OAuth or key | hosted | none | https://www.anchorterminal.com/tools/nocodb.md |
| 124 | Airtable | Formagrid Inc (Airtable) | HTTP API | Spreadsheets | BB | 70.9 | medium | no | OAuth or key | hosted | none | https://www.anchorterminal.com/tools/airtable.md |
| 205 | Smartsheet API + MCP | Smartsheet Inc. | HTTP API | Spreadsheets | B | 67.6 | medium | no | OAuth or key | hosted | none | https://www.anchorterminal.com/tools/smartsheet.md |
| 241 | SeaTable | SeaTable GmbH | HTTP API | Spreadsheets | B | 66.3 | medium | no | API key | hosted + local | none | https://www.anchorterminal.com/tools/seatable.md |
| 270 | Coda (Superhuman Docs) | Superhuman Platform Inc. | HTTP API | Spreadsheets | B | 64.8 | medium | no | OAuth or key | hosted | none | https://www.anchorterminal.com/tools/coda.md |
| 306 | Baserow | Baserow B.V. | HTTP API | Spreadsheets | B | 63.6 | medium | no | API key | hosted | none | https://www.anchorterminal.com/tools/baserow.md |
| 379 | Teable | Teable AI, Inc. | HTTP API | Spreadsheets | C | 61 | medium | no | OAuth or key | hosted | none | https://www.anchorterminal.com/tools/teable.md |
| 450 | Microsoft Excel (Microsoft Graph workbook API) | Microsoft | HTTP API | Spreadsheets | C | 58.5 | medium | no | OAuth | hosted | none | https://www.anchorterminal.com/tools/microsoft-excel-graph.md |
| 597 | Grist | Grist Labs Inc. | HTTP API | Spreadsheets | D | 50.1 | medium | no | OAuth or key | hosted | none | https://www.anchorterminal.com/tools/grist.md |

Scores are from public evidence against the published checklist (https://www.anchorterminal.com/benchmark/), with Performance and Task success pending. p95 latency and context cost come from our probes, which haven't run yet.

## Summaries

### 33. Google Sheets API, BB (76.3)

REST API from Google for reading and writing Google Sheets spreadsheets, covering cell values, ranges, formulas, formatting, tables and comments. Access is by OAuth 2.0, and a six-tool MCP server is in Developer Preview. Batch updates apply atomically and count as one request, and the drive.file scope limits an app to files the user picks. Quotas are 300 reads and 300 writes a minute per project, reads are by range with no row filter or paging, and a person must complete OAuth consent first.

- Page: https://www.anchorterminal.com/tools/google-sheets-api · Markdown: https://www.anchorterminal.com/tools/google-sheets-api.md · JSON: https://www.anchorterminal.com/api/v1/tools/google-sheets-api.json
- Capabilities: sheets.read, sheets.write, sheets.formulas, sheets.tables · endpoint: `https://sheets.googleapis.com/v4`

### 37. NocoDB, BB (75.7)

NocoDB is a database of typed records in bases, tables and views, run on NocoDB Cloud or self-hosted. Agents reach it through a REST API and a built-in MCP server, using scoped API tokens or OAuth. API tokens and MCP connections are limited by permission category and by base, and an MCP connection registers only the tools it is allowed. The v3 REST API has a public OpenAPI file. Requests are capped at 5 a second per user, REST writes take 10 records a call, and the Free plan stops at 1,000 API calls a month.

- Page: https://www.anchorterminal.com/tools/nocodb · Markdown: https://www.anchorterminal.com/tools/nocodb.md · JSON: https://www.anchorterminal.com/api/v1/tools/nocodb.json
- Capabilities: sheets.records, sheets.read, sheets.write, sheets.tables, sheets.formulas · endpoint: `https://app.nocodb.com`

### 124. Airtable, BB (70.9)

Airtable is a hosted database of typed records organised in bases, tables and views. Agents reach it through a REST Web API and an official hosted MCP server, using personal access tokens or OAuth. Tokens are limited by scope and by base, and the official MCP server at mcp.airtable.com covers records, schema, interfaces and automations in 40 tools. The REST API allows 5 requests a second per base with a 30-second lockout after a 429, writes take 10 records a call, and the Free plan stops at 1,000 calls a month.

- Page: https://www.anchorterminal.com/tools/airtable · Markdown: https://www.anchorterminal.com/tools/airtable.md · JSON: https://www.anchorterminal.com/api/v1/tools/airtable.json
- Capabilities: sheets.records, sheets.read, sheets.write, sheets.tables, sheets.formulas · endpoint: `https://api.airtable.com`

### 205. Smartsheet API + MCP, B (67.6)

Smartsheet is a hosted work management product built on sheets with typed columns, rows, formulas, reports and dashboards. Agents reach it through a REST API (187 operations) and a hosted MCP server, both limited to Business plans and above. The REST API has a public OpenAPI 3.0.3 spec with 187 operations, Markdown docs and llms.txt, and the hosted MCP server loads its 83 documented tools by toolset. API access needs a Business plan or higher, and the status page lists eight incidents marked major or critical between 15 July and 21 September 2026.

- Page: https://www.anchorterminal.com/tools/smartsheet · Markdown: https://www.anchorterminal.com/tools/smartsheet.md · JSON: https://www.anchorterminal.com/api/v1/tools/smartsheet.json
- Capabilities: sheets.read, sheets.write, sheets.records, sheets.formulas, automation.workflows · endpoint: `https://api.smartsheet.com/2.0`

### 241. SeaTable, B (66.3)

SeaTable is a database of typed rows in tables and bases, sold as a cloud service hosted in Germany and as server software. Agents reach it through a REST API with per-base tokens and an official MCP server. API tokens are limited to one base and to read-only or read-write, and the official MCP server marks every tool as read-only or destructive. The Free plan allows 3,000 API calls a month in total, and base calls are capped at 200 a minute. The status page showed the base API degraded for 0.77 per cent of 30 days.

- Page: https://www.anchorterminal.com/tools/seatable · Markdown: https://www.anchorterminal.com/tools/seatable.md · JSON: https://www.anchorterminal.com/api/v1/tools/seatable.json
- Capabilities: sheets.records, sheets.read, sheets.write, sheets.tables, sheets.formulas · endpoint: `https://cloud.seatable.io`

### 270. Coda (Superhuman Docs), B (64.8)

Coda, renamed Superhuman Docs in July 2026, is a document workspace whose pages hold typed tables, formulas and automations. Agents reach it through a REST API with a public OpenAPI description, or a hosted MCP server in beta. API tokens can be limited to one doc or one table and to read or write, and the OpenAPI description covers 125 operations with 429 on almost all. Writes are queued and answered with 202, so each needs a status check. The REST API has no idempotency keys or official client libraries, and the MCP server is in beta.

- Page: https://www.anchorterminal.com/tools/coda · Markdown: https://www.anchorterminal.com/tools/coda.md · JSON: https://www.anchorterminal.com/api/v1/tools/coda.json
- Capabilities: sheets.read, sheets.write, sheets.tables, sheets.records, sheets.formulas, work.docs · endpoint: `https://coda.io/apis/v1`

### 306. Baserow, B (63.6)

Baserow is an open-source database of typed rows in tables, sold as a hosted cloud and as software to self-host. Agents reach it through a REST API with database tokens and a built-in MCP server. Database tokens are limited to chosen tables and to create, read, update or delete, and the REST API has a public OpenAPI description with batch calls of 200 rows. The MCP server authenticates with a key in its URL, runs over SSE only and has no read-only mode. Cloud requests are capped at 10 at a time.

- Page: https://www.anchorterminal.com/tools/baserow · Markdown: https://www.anchorterminal.com/tools/baserow.md · JSON: https://www.anchorterminal.com/api/v1/tools/baserow.json
- Capabilities: sheets.records, sheets.read, sheets.write, sheets.tables, sheets.formulas · endpoint: `https://api.baserow.io`

### 379. Teable, C (61)

Teable is an open-source table product on PostgreSQL with records, views, formulas and automations, sold as a hosted cloud and as software to self-host. Agents reach it through a REST API with scoped tokens or OAuth, and an official CLI. Personal access tokens and OAuth tokens carry per-action scopes, and tokens can be limited to chosen spaces and projects. The public OpenAPI file covers 841 operations. Error responses beyond 200 and 201 are missing from that file, no idempotency keys were found, and the cloud allows 10 requests a second on every plan.

- Page: https://www.anchorterminal.com/tools/teable · Markdown: https://www.anchorterminal.com/tools/teable.md · JSON: https://www.anchorterminal.com/api/v1/tools/teable.json
- Capabilities: sheets.read, sheets.write, sheets.records, sheets.tables, sheets.formulas · endpoint: `https://app.teable.ai/api`

### 450. Microsoft Excel (Microsoft Graph workbook API), C (58.5)

Workbook endpoints of Microsoft Graph for Excel files stored in OneDrive for work or school and SharePoint. Calls read and write ranges, tables, charts and named items, and run Excel worksheet functions on a file in place. Ranges, tables, charts and 366 worksheet function endpoints are reachable over REST with a public OpenAPI, and a non-persistent session lets an agent test changes without saving them. The reference pages list delegated permissions only, with Files.ReadWrite as the least privileged scope, and writes take no idempotency key.

- Page: https://www.anchorterminal.com/tools/microsoft-excel-graph · Markdown: https://www.anchorterminal.com/tools/microsoft-excel-graph.md · JSON: https://www.anchorterminal.com/api/v1/tools/microsoft-excel-graph.json
- Capabilities: sheets.read, sheets.write, sheets.tables, sheets.formulas · endpoint: `https://graph.microsoft.com/v1.0`

### 597. Grist, D (50.1)

Grist is a spreadsheet-database hybrid from Grist Labs with typed columns and Python formulas, sold as a hosted service and as open-source software to self-host. Agents reach it through a REST API and an MCP server with OAuth. OAuth tokens carry seven scopes, can be limited to chosen documents and expire after an hour, and the REST API has a public OpenAPI file with an add-or-update call. No status page, SLA terms, DPA or security.txt was found, and the docs say the hosted service has no SOC 2 or ISO 27001 audit.

- Page: https://www.anchorterminal.com/tools/grist · Markdown: https://www.anchorterminal.com/tools/grist.md · JSON: https://www.anchorterminal.com/api/v1/tools/grist.json
- Capabilities: sheets.records, sheets.read, sheets.write, sheets.tables, sheets.formulas · endpoint: `https://docs.getgrist.com/api`

## How we test this category

The same workbook of one thousand rows in each listing. The same tasks run through its API (read a range, append rows, update cells in a batch, add a formula column, filter records). We check limits, consistency after writes and change notifications. In this run listings are graded from public evidence against the published checklist. This test hasn't run yet, so Task success is pending and the grades here come from the categories assessed from public evidence.