Spreadsheet

Create spreadsheets with cell data, formulas, and formatting.

Updated 16 Sep 20261 min read

Send "type": "spreadsheet".

Create spreadsheets with cell data, formulas, and formatting.

Also available as the MCP tool render_spreadsheet. The same payload works through either surface.

Fields

data

cellDatastringrequired

JSON string of all cell values keyed by A1, B1, etc. Include formulas in cells that need them.

formulasstring

JSON string listing cells that contain formulas (e.g., {"D2":"=B2*C2"})

rowsintegerrequired

Total number of rows

colsintegerrequired

Total number of columns

formattingstring

JSON string for cell formatting. Use {"A1":{"fontWeight":"bold"}} for headers.

cellFormatsstring

JSON string mapping cells to a display format: "number", "currency", "percentage", or "date". e.g. {"B2":"number","C2":"currency"}. Use for numeric/money/percent/date columns.

cellFormatOptionsstring

JSON string of per-cell format options: {"B2":{"decimals":2},"C2":{"currency":"USD","decimals":2}}. Pairs with cellFormats.

Example

{
  "type": "spreadsheet",
  "data": {
    "cellData": "string",
    "formulas": "string",
    "rows": 0,
    "cols": 0,
    "formatting": "string",
    "cellFormats": "string",
    "cellFormatOptions": "string"
  }
}

Was this page helpful?