Sheets
SheetsAmbiguous Sheets. Organize and analyze tabular data. Your team writes formulas; your coworkers read ranges and patch cells.
Build spreadsheets with formulas, charts, and pivot tables. Your AI coworkers can read specific ranges and update individual cells without touching the rest of your data. Import .xlsx files from Excel or Google Sheets, and export back losslessly whenever you need to.
Features
Open a spreadsheet, write formulas, build charts, share with your team. Real-time collaboration is the default. Every spreadsheet is multi-user from creation. Export to .xlsx or .csv when you need to share outside the workspace.
Full formula engine
SUM, VLOOKUP, IMPORTRANGE, array formulas. The formulas you know, working the same way.
Real-time collaboration
Multiple cursors, live edits, presence indicators. See who's changing what, human or coworker.
Included from day one
The rest of the Sheets feature set. Every item ships in every workspace, for your team and your AI coworkers alike.
Pivot tables
Drag-and-drop pivot builder. Summarize thousands of rows into actionable tables in seconds.
Charts and visualizations
Bar, line, pie, scatter. Built from your data in one click. Embed in Docs or Slides.
Conditional formatting
Highlight cells by value, color-code status columns, surface outliers at a glance.
Import and export
Open .xlsx files, export to .xlsx or .csv. Lossless. Migrate from Excel or Google Sheets without reformatting.
One product, two ways in
Your agent reads ranges and patches cells via MCP or REST. No round-tripping the whole sheet. Fetch A1:D10, update three cells, done. Agents can write formulas too.
// Read a range and patch cells via MCP
const range = await mcp.callTool("sheets.range", {
sheetId: "sh_abc123",
range: "Sheet1!A1:D10"
});
await mcp.callTool("sheets.patch", {
sheetId: "sh_abc123",
updates: [
{ cell: "B2", value: "=SUM(C2:C10)" },
{ cell: "D2", value: "Approved" }
]
});curl -X GET "https://app.ambi.cc/api/sheets/sh_abc123/range?spec=Sheet1!A1:D10" \
-H "Authorization: Bearer $API_KEY"curl -X PATCH https://app.ambi.cc/api/sheets/sh_abc123/cells \
-H "Authorization: Bearer $API_KEY" \
-H "Content-Type: application/json" \
-d '{
"updates": [
{ "cell": "B2", "value": "=SUM(C2:C10)" },
{ "cell": "D2", "value": "Approved" }
]
}'What your agent can do in Sheets
Every action your team takes in Sheets, your agent can do the same way.
| Method | Description |
|---|---|
| sheets.create | Create a new spreadsheet with optional template |
| sheets.getRange | Read a range of cells (e.g., Sheet1!A1:D10) |
| sheets.updateCells | Write values to specific cells by row and column |
| sheets.appendValues | Append rows at the first empty position in a range |
| sheets.getData | Get all sheet data as structured JSON |
| sheets.addTab | Add a new tab to the spreadsheet |
| sheets.createChart | Create a chart visualization from cell data |
Imports and exports
Functionally equivalent to Microsoft Excel and Google Sheets.
Import .xlsx, export .xlsx / .csv. Lossless. IMPORTRANGE across sheets. Range-fetch + diff-based PATCH for agents, no round-tripping the whole sheet.
Get started
Frequently asked questions
The full formula engine: SUM, VLOOKUP, IMPORTRANGE, array formulas, conditional formatting, and pivot tables. Functionally equivalent to Excel and Google Sheets.
Yes. Import .xlsx files, export to .xlsx or .csv, lossless. Migrate from Excel or Google Sheets without reformatting or losing formulas.
