# Sheets

**Ambiguous Sheets**. Organize and analyze tabular data. Your team writes formulas; your coworkers read ranges and patch cells.

Free foreverNo credit card

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.

| Row | A        | B        | C        | D       |
|-----|----------|----------|----------|---------|
| 1   | Month    | Revenue  | Expenses | Profit  |
| 2   | January  | $42,500  | $28,100  | $14,400 |
| 3   | February | $48,200  | $29,800  | $18,400 |
| 4   | March    | $51,800  | $31,200  | $20,600 |
| 5   | April    | $55,100  | $32,500  | $22,600 |
| 6   | May      | $58,900  | $33,100  | $25,800 |

### Full formula engine
SUM, VLOOKUP, IMPORTRANGE, array formulas. The formulas you know, working the same way.

| Method              | Description                                          |
|---------------------|------------------------------------------------------|
| create_sheet        | Create a new spreadsheet with optional template     |
| get_sheet_range     | Read a range of cells (e.g., Sheet1!A1:D10)       |
| sheet_update_cells  | Write values to specific cells by row and column    |
| append_sheet_values | Append rows at the first empty position in a range  |
| sheet_get_data      | Get all sheet data as structured JSON               |
| add_sheet_tab       | Add a new tab to the spreadsheet                     |
| create_chart        | 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.

## Customer Analysis

| Row | Customer    | MRR    | Segment   | Health |
|-----|-------------|--------|-----------|--------|
| 1   | Kova Corp   | $2,400 | Enterprise | Green  |
| 2   | StartupCo   | $800   | Growth     | Yellow |
| 3   | MedTech Inc | $3,200 | Enterprise | Green  |
| 4   | DesignLab   | $1,100 | Growth     | Green  |
| 5   | FastShip    | $600   | Starter    | Red    |

### 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.

Everything included

- Pivot tables

- Charts and visualizations

- Conditional formatting
  
- Import and export

## 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.

```javascript
// 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
curl -X GET "https://app.ambiguous.ai/api/sheets/sh_abc123/range?spec=Sheet1!A1:D10" \
  -H "Authorization: Bearer $API_KEY"
```

```curl
curl -X PATCH https://app.ambiguous.ai/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" }
    ]
  }'
```

## Frequently asked questions

### Which formulas does Sheets support?

The full formula engine: SUM, VLOOKUP, IMPORTRANGE, array formulas, conditional formatting, and pivot tables. Functionally equivalent to Excel and Google Sheets.

### Can I import my existing .xlsx files?

Yes. Import .xlsx files, export to .xlsx or .csv, lossless. Migrate from Excel or Google Sheets without reformatting or losing formulas.

## Start using Sheets free

Free for up to 5 teammates. All 18 apps included, no credit card required.
