Connect Microsoft Excel to Claude Code
Read and update cloud Excel workbooks, append table rows, and create and export charts. Add Toolspoke to Claude Code once and it can use 15 Microsoft Excel actions. Your Microsoft Excel credential stays in Toolspoke, and you choose which actions Claude Code may call.
Set it up in Claude Code
Three steps, the first one once for every toolkit you will ever add.
Add Toolspoke to Claude Code
Run it in your project, then /mcp to sign in
claude mcp add --transport http toolspoke https://toolspoke.com/mcpThe sign-in opens in your browser, and Toolspoke asks you to approve it.
Install Microsoft Excel and connect it
Add Microsoft Excel to a project in your Toolspoke workspace.
Press connect and sign in to Microsoft Excel. Toolspoke keeps the token encrypted and refreshes it when it expires, so there is nothing to copy and nothing to rotate by hand.
Choose what Claude Code may do
All 15 actions start on. Switch off any of the 5 actions that change something in Microsoft Excel, and Claude Code gets a refusal if it tries.
What you can ask Claude Code for
A few of the Microsoft Excel actions that only read, so they are safe to try first.
- Return the signed-in user’s business OneDrive id and drive type
- List the root folder of a drive
- List a folder’s files and subfolders
- Resolve a workbook’s file metadata and web link
What Claude Code can do in Microsoft Excel
10 actions read, 4 write and one deletes or permanently changes something.
Reads
Get my drive
Return the signed-in user’s business OneDrive id and drive type. This checks Files.ReadWrite access; it does not prove a specific workbook is accessible. Use a work or school Microsoft account.
List files
List the root folder of a drive. Pick an .xlsx file; browse folder ids with list_folder. Results include non-workbooks. Follow @odata.nextLink with skip_token; do not treat one page as the full drive.
List folder
List a folder’s files and subfolders. Choose an .xlsx workbook, or recurse using returned folder ids. Follow @odata.nextLink with skip_token.
Get file
Resolve a workbook’s file metadata and web link. This does not read its cells. Workbook actions require an existing Office Open XML workbook in business OneDrive or SharePoint; .xls and local files are unsupported.
List worksheets
List worksheets in the workbook, including their ids and names. Use those identifiers in range and chart calls.
Read range
Read values, formulas and number formats from an explicit bounded A1 range. Read in small chunks for large worksheets.
List tables
List the workbook’s named tables. A table, rather than an arbitrary range, is required for append_rows.
List rows
Read table rows with their indices and values. Page using skip and limit; an incomplete page is not the whole table.
List charts
List charts in a worksheet, returning ids and names for image export.
Get chart image
Render a chart as a base64 PNG in value. Use a saved read-only script to fetch it and call create_artifact with format png and content set to value, then share the artifact link. Do not paste the base64 into chat. Work/school accounts only.
Writes
Add worksheet
Add a new worksheet to an existing workbook. Does not create a workbook file.
Add table
Create a table over an existing worksheet range. This structures existing cells rather than appending new data.
Append rows
Append rows to the end of an existing table. Read its columns first and match their order and count. This call is not idempotent: after a timeout, inspect the table before retrying to avoid duplicate rows.
Add chart
Create a chart from an existing bounded data range in this worksheet. Include headings when useful. Export it with get_chart_image; email delivery uses a separate mail toolkit.
Deletes or permanently changes
Update range
Overwrite values, formulas or number formats in a bounded A1 range. Supply only the fields to change, matching the range dimensions; null skips a cell. Existing cells can be overwritten, so this requires destructive action permission.
Microsoft Excel in Claude Code: questions
Does Claude Code see my Microsoft Excel credential?
No. The credential is stored encrypted in Toolspoke, and the gateway adds it to each call. Claude Code only ever talks to Toolspoke, and the dashboard shows the last four characters of the credential and nothing more.
Can I stop Claude Code from changing things in Microsoft Excel?
Yes. Each of the 15 actions can be switched off for a project. Turn off the 5 that change something and Claude Code can only read.
Will 15 actions crowd Claude Code's context?
No. Toolspoke shows Claude Code five bridge tools, plus a guide where a toolkit has one, and Claude Code searches for the Microsoft Excel action it needs when it needs it. Adding more toolkits does not add more tools to its list.
Can I add it once for every project?
Yes. Add --scope user to the command and Claude Code keeps Toolspoke in every project on this machine. Without it, the server is added to the project you ran the command in.
What does it cost?
Tool calls are free on every plan, and a Microsoft Excel call does not run in a sandbox, so it bills nothing.
Microsoft Excel in your other apps
Try Microsoft Excel in Claude Code
Free to start, and tool calls cost nothing on any plan.