# Create a spreadsheet, table or schema

> Create a spreadsheet, table or schema: 5 companies fully do it, 5 with a limit, 10 carry the tag. Every listing in Spreadsheets & operational tables with the reason and a source.

- Canonical: https://www.anchorterminal.com/niches/spreadsheets.create-structure/
- Markdown: https://www.anchorterminal.com/niches/spreadsheets.create-structure/index.md (~1,150 tokens)
- Slim: https://www.anchorterminal.com/niches/spreadsheets.create-structure/index.min.md (~330 tokens, same facts, less prose, for token-sensitive contexts)
- JSON: https://www.anchorterminal.com/niches/spreadsheets.create-structure/index.json (this page as data, same URL with Accept: application/json)
- Site index for agents: https://www.anchorterminal.com/llms.txt (the key docs and every listing in one file, at most 16 MB, about 4 million tokens: https://www.anchorterminal.com/llms-full.txt)
- API: https://www.anchorterminal.com/api/v1/index.json
- MCP: https://www.anchorterminal.com/mcp (the whole catalogue as tools, no key)
- DNS: dig +short TXT <slug>.grade.anchorterminal.com (the grade as a DNS TXT record, for a sandbox with no HTTP where names still resolve; also top., best.<category>. and <a>.vs.<b>. under the zone, and the same under grade.letme.dev)
- Licence: CC BY 4.0, credit Anchor Terminal and link this page (https://www.anchorterminal.com/terms/#data)
- Updated: 2026-11-15

Four or more companies' docs show a full fit.

| Companies, full fit | With a limit | Carry the tag | Share of the category's work | First-hand accounts |
| --- | --- | --- | --- | --- |
| 5 | 5 | 10 | 14 | 5 |

## What counts as done

A new file or table with named, typed columns, in the stated folder, owned by the user rather than a service account, and readable by the next call.

Measured, for our own tests: created in at most three calls.

How agents ask for it: make a new spreadsheet for this; set up a base to track applicants; add a status column; copy this doc so I can test

## Does the job

The docs show it meets the test above, and nothing we read says otherwise.

- **Airtable (Formagrid Inc (doing business as Airtable))**: Create base takes a workspace id and tables with typed fields in one call, and Create table and Create field add more, all under schema.bases:write on the user's own token.
- **Grist (Grist Labs Inc.)**: POST /workspaces/{id}/docs creates a document in the named workspace, POST /docs/{id}/tables adds tables with typed columns, and /copy copies a document, on the same user credential.
- **NocoDB (NocoDB Inc (doing business as NocoDB))**: Create base in a workspace, Create table with typed fields and Create field are v3 meta endpoints on the same token used for records.
- **Smartsheet API + MCP (Smartsheet Inc.)**: POST /folders/{id}/sheets or /workspaces/{id}/sheets creates a sheet with typed columns in the named place in one call, under the user's own token, and POST /sheets/{id}/copy copies one.
- **Teable (Teable AI, Inc.)**: POST /base creates a base in a space, POST /base/{id}/table/ creates a table with typed fields, and POST /table/{id}/field adds fields, on the same token scoped by permission.

## Does the job, with a limit

It does the job, but something in the docs or a user's account will get in an agent's way. The limit is named in each row.

- **Baserow (Baserow B.V.)**: Create table needs a JWT from the account's email and password, while create field accepts a database token, so schema setup needs a second credential, the blocker the map names.
- **Coda (Superhuman Docs) (Superhuman Platform Inc. (parent of Coda Project LLC))**: POST /docs creates a doc in a folderId, optionally copied from a sourceDoc, so copying a template works. The API has no endpoint to create tables or columns, so new typed columns cannot be added.
- **Google Sheets API (Google LLC)**: spreadsheets.create makes the file and batchUpdate's addTable adds a table; placing it in a folder needs the Drive API, and acc-12 and acc-27 show service-account creation failing for storage or ownership.
- **Microsoft Excel (Microsoft Graph workbook API) (Microsoft Corporation)**: A workbook is a drive file the agent uploads into a folder, then worksheets and tables are added through the workbook API. Excel table columns carry names but no types, so typed columns are not possible.
- **SeaTable (SeaTable GmbH)**: Create Table, Insert Column and Append Columns add typed columns with the Base-Token, but creating a new base is an account operation needing an account token, not the base-scoped one an agent holds.

## What stops agents finishing

- schema changes need a different credential than row writes (Baserow JWT)
- file created in a service account's drive with no storage or not visible to the user

## Around it

Before: chat.user-request. After: spreadsheets.append-rows.

## Where this comes from

Weight 14 of 100 in Spreadsheets & operational tables: 5 of 35 accounts: Sheets create by service account and storage errors, addTable column offsets, Grist copy by API, agents wanting UI-level control of Airtable

As data: https://www.anchorterminal.com/api/v1/use-cases/spreadsheets.create-structure.json, or the MCP tool get_use_case with id spreadsheets.create-structure. Draft, read 2026-11-15 from public docs and first-hand accounts, not yet reviewed by a person.

---

Query this catalogue directly over MCP: https://www.anchorterminal.com/mcp (Streamable HTTP, no key). How: https://www.anchorterminal.com/agents/#mcp
