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.

  1. Add Toolspoke to Claude Code

    Run it in your project, then /mcp to sign in

    claude mcp add --transport http toolspoke https://toolspoke.com/mcp

    The sign-in opens in your browser, and Toolspoke asks you to approve it.

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

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

Try Microsoft Excel in Claude Code

Free to start, and tool calls cost nothing on any plan.