# Spreadsheet

> Create spreadsheets with cell data, formulas, and formatting.

Source: https://mockflow.com/developers/reference/item-types/spreadsheet

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

- `cellData` (string, required): JSON string of all cell values keyed by A1, B1, etc. Include formulas in cells that need them.
- `formulas` (string): JSON string listing cells that contain formulas (e.g., {"D2":"=B2*C2"})
- `rows` (integer, required): Total number of rows
- `cols` (integer, required): Total number of columns
- `formatting` (string): JSON string for cell formatting. Use {"A1":{"fontWeight":"bold"}} for headers.
- `cellFormats` (string): 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.
- `cellFormatOptions` (string): JSON string of per-cell format options: {"B2":{"decimals":2},"C2":{"currency":"USD","decimals":2}}. Pairs with cellFormats.

## Example

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