Sheet 🟡 PREVIEW (advanced) - Spreadsheets

AI spreadsheet with desktop-grade features

Preview — advanced. Sheets is functional and close to stable, but is not yet part of the supported surface. It is the most advanced preview app, alongside Mail.

Overview

Sheet is the spreadsheet application in General Bots Suite. It stores workbooks in Drive, imports and exports .xlsx and CSV, evaluates a large worksheet function library server-side, and renders a virtualised grid that scrolls over very large row counts.

Sheet is in beta, and the gap between it and a desktop spreadsheet is currently wide. The tables below mark each capability honestly:

• Available — implemented and usable today.
• Partial — present but incomplete or unreliable; the note says how.
• Planned — modelled, or exposed in the API, but not yet functional end to end.

The work to close the gap is tracked in Sheet Parity Plan. Read that page before relying on Sheet for a workbook you cannot afford to lose.

Features

Cells

Formulas

Around 170 worksheet functions are implemented server-side, including the Microsoft 365 dynamic-array family. A representative sample:

Current formula limitations

These are real and will bite immediately. Each is tracked in Sheet Parity Plan.

Charts

Filters

Sort

Import / Export

Warning — opening an .xlsx from Drive. The save-back is non-destructive: the original package is preserved and only edited cells are rewritten (issue 8). Features Sheet cannot model are not altered by an edit round-trip.

Keyboard Shortcuts

Implemented today:

Documented but not yet implemented — tracked in Sheet Parity Plan:

Sheet via Chat

The examples below show the intended conversational flow. Chat-driven sheet creation depends on the parity work in Sheet Parity Plan; treat them as the target experience rather than a description of current behaviour.

Creating a Sales Report

Calculating Totals

Generating a Chart

API Endpoints

Create Spreadsheet Request

{
    "title": "Sales Report",
    "sheets": [
        {
            "name": "Revenue",
            "rows": 20,
            "columns": 10,
            "data": {
                "A1": "Month",
                "B1": "Revenue",
                "A2": "Jan",
                "B2": 12400
            }
        }
    ]
}

Cell Update Request

{
    "cells": {
        "B16": "=SUM(B2:B15)",
        "C16": "=AVERAGE(C2:C15)"
    }
}

Spreadsheet Response

{
    "id": "sheet-789",
    "title": "Sales Report",
    "sheets": [
        {
            "name": "Revenue",
            "data": [
                ["Month", "Revenue", "Orders"],
                ["Jan", 12400, 156],
                ["Feb", 15200, 189]
            ],
            "charts": [
                {
                    "id": "chart-001",
                    "type": "bar",
                    "title": "Monthly Revenue",
                    "data_range": "A1:B15"
                }
            ]
        }
    ],
    "created_at": "2025-05-15T09:00:00Z",
    "updated_at": "2025-05-15T11:00:00Z"
}

Configuration

Current grid limits are compiled in, not configurable:

Canvas rendering of the grid remains the open part of Sheet Parity Plan issue 6.

Troubleshooting

A formula returns #ERROR!

Check it against the limitations table above first — =SUM(A1:A3)+1, =A1&B1, =A1^2 and any nested call return #ERROR! by design of the current evaluator, not because of anything wrong with your sheet. Otherwise:

1. Confirm the formula starts with =.
2. Confirm the function name is in the implemented set.
3. Check for a circular reference.

A number is treated as text

Values typed with thousands separators or currency symbols are stored as text; type the bare number or use a formula to coerce. Formatted display of stored numbers follows the cell’s format code.

Cell formatting is not shown

If a workbook opened from Drive loses its currency/date display, the cell may predate the format engine; re-applying the format from the toolbar refreshes it. Number format codes are applied server-side on load.

A worksheet cannot be reached

All worksheets are reachable through the tab bar (add/switch/delete/rename). If the tab bar does not render, reload the page; old cached pages predate it.

Import lost part of the file

See the import table above for exactly what is dropped. Pivot tables are still not modelled on import (they survive an edit round-trip byte-for-byte but do not render); rich-text runs now import but are not yet rendered in the grid.

Chart is not displayed

Charts are not rendered in the grid yet. The definition is stored and returned by the API.

See Also

• Sheet Parity Plan — current gaps and the plan to close them
• Sheets API — endpoint reference
• Suite Manual — complete user guide
• Drive — file storage for imports
• Chat App — create sheets via chat