File format — Docs

{
  "format": "metagrid-v2",
  "version": 2,
  "workbook": { "type": "list" | "grid" | "table", … },
  "names": { "spend": { "id": 12, "r": 0, "c": 1 } },
  "queries": [{ "id": 1, "name": "items", "url": "https://…", "key": "", "auth": "auto", "targetId": 1, "targetR": 1, "targetC": 0 }],
  "access": {
    "ownerId": "",
    "owner": "ada@acme.com",
    "users": [{ "email": "ada@acme.com", "name": "Ada", "userId": "" }],
    "groups": { "eng": ["ada@acme.com", "backend"], "backend": ["bob@acme.com"] }
  }
}

Export always writes this shape.
Import JSON expects this shape (plus structure field defaults applied on load).
Cloud rows store the same object under subsheet_sheets.data.
Access: users roster (defaults to the current account). groups map proper-case name → members (default Admin). Workbook see / edit / manage lists are the default for Everyone vs Admin (see: ["*"], edit/manage: ["Admin"]). Per-structure lists override. A present empty list means nobody; omitting a key inherits.
Excel import does not produce a different format — it builds a normal workbook tree (list of grids), then you export JSON if you want a portable file.
Display formats (optional, display-only):
- cellFmt — map of cell store keys → format code (grids, tables, lists).
- colFormat — table column default format code.
- colStyle / rowStyle / valueStyle — font/alignment for a field.
- colCondFmt / rowCondFmt / valueCondFmt — color scale + duplicates highlight.
- valueFormat — list value-column default format code.
Codes are Excel-style strings such as #,##0.00, $#,##0.00, 0.00%, 0.00E+00, m/d/yyyy, yyyy-mm-dd (shown as YYYY-MM-DD in the ISO date option). Resolution: cell → column/list default → Text (stored as General). Values in cells stay raw.
File cells (attachments in one cell):
```
{ file: true, name, mime, size, data?, formMap?, formFields? }
```
- data — data URL when inlined (omitted or null if too large)
- formMap — PDF field name → formula/ref string
- formFields — optional list of discovered PDF field names
Not a structure type (no type key) — same pattern as checkboxes { cb }.