Integration

Microsoft Excel integration

Microsoft Excel workbooks through the Graph v1.0 workbook API: list worksheets, read and write cell ranges, append and read table rows, create worksheets and tables, run a recalculation, and open a workbook session so a batch of edits shares one context. Works on .xlsx files stored in the connected user's OneDrive.

Connect Microsoft Excel How integrations work

Ask it in chat

Say what should happen.
The workflow builds itself.

When this happens, do that in Microsoft Excel.Built from the 17 Microsoft Excel tools below, on the connection you add once.

Common Microsoft Excel use cases

reading a fixed header block
finding the sheet to write to
preparing a sheet for row appends
finding the table to append rows to
importing a spreadsheet into a workflow
resolving a workbook id from its file name
writing computed results back into a report
importing a structured table into a workflow
mapping positional row values onto field names
removing processed rows from a work queue sheet

What you can do with Microsoft Excel

Each of these is one operation on one endpoint, available both as a workflow step and as a tool an AI agent can call on its own. Nothing bundles several operations into one action, so what a run did stays readable afterwards.

Most endpoints run on the free plan. A few, mainly the ones that publish on your behalf, need a paid plan.

Range, 4 operations

clear_rangeClear rangePOSTClears the contents or formatting of an Excel cell range.
get_rangeGet rangeGETReads an explicit A1-style cell range from an Excel worksheet.
get_used_rangeGet used rangeGETReads the whole populated area of a worksheet without knowing its extent in advance.
update_rangeUpdate rangePATCHWrites values or formulas into an explicit Excel cell range.

Row, 3 operations

add_table_rowAdd table rowPOSTAppends rows to an Excel table without computing a target range.
delete_table_rowDelete table rowDELETEDeletes one row of an Excel table by its index.
list_table_rowsList table rowsGETReads the data rows of an Excel table.

Worksheet, 3 operations

add_worksheetAdd worksheetPOSTAdds a worksheet to an Excel workbook.
delete_worksheetDelete worksheetDELETEDeletes a worksheet from an Excel workbook.
list_worksheetsList worksheetsGETLists the worksheets of an Excel workbook with their name, position and visibility.

Session, 2 operations

close_sessionClose sessionPOSTCloses an Excel workbook session opened by create_session.
create_sessionCreate sessionPOSTOpens an Excel workbook session to group a batch of reads or writes.

Table, 2 operations

add_tableAdd tablePOSTCreates an Excel table over a cell range.
list_tablesList tablesGETLists the Excel tables defined in a workbook.

Workbook, 2 operations

list_workbooksList workbooksGETFinds the .xlsx workbooks in OneDrive and returns their drive item ids.
recalculate_workbookRecalculate workbookPOSTRecalculates the formulas of an Excel workbook.

Column, 1 operation

list_table_columnsList table columnsGETLists the columns of an Excel table, giving the header names.

Use Microsoft Excel from Claude Code, Cursor or Codex

Connect Microsoft Excel in LiveContext, create an API key in Settings, then add the LiveContext MCP server to your client. Its Microsoft Excel operations become tools the client can call, next to every other integration you connected.

Claude Code

claude mcp add --transport http livecontext https://livecontext.ai/mcp --header "X-API-Key: YOUR_API_KEY"

Codex (~/.codex/config.toml)

[mcp_servers.livecontext]
url = "https://livecontext.ai/mcp"

[mcp_servers.livecontext.http_headers]
"X-API-Key" = "YOUR_API_KEY"

Cursor, Claude Desktop and other JSON configs

{
  "mcpServers": {
    "livecontext": {
      "type": "http",
      "url": "https://livecontext.ai/mcp",
      "headers": {
        "X-API-Key": "YOUR_API_KEY"
      }
    }
  }
}

Set up the MCP server step by step

How to connect Microsoft Excel

Create your workspace
Sign up free. Nothing to install.
Connect Microsoft Excel once
Add your Microsoft Excel connection in Settings. Every tool from this integration reuses it, and secrets are encrypted at rest and visible only to you.
Describe the job in chat
The workflow builds itself in front of you and picks the endpoints it needs. Drag the steps yourself on the canvas whenever you would rather be explicit.

Microsoft Excel integration FAQ

What can you do with the Microsoft Excel integration?

LiveContext exposes 17 operations on Microsoft Excel, covering range, row, worksheet and session. Common uses include reading a fixed header block, finding the sheet to write to and preparing a sheet for row appends.