Skip to main content
skill CX Codex

microsoft-excel — Claude Code skill: live Excel in OneDrive

Reads and edits Excel workbooks that live in OneDrive or SharePoint through the Microsoft Graph workbook API. Needs an OAuth token in $MICROSOFT_EXCEL_TOKEN.

Apache-2.0 187 installs ★ 17 updated 2026-10-25

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add AceDataCloud/Skills --skill microsoft-excel -a claude-code
Open on GitHub

What microsoft-excel does

The skill talks to cloud workbooks over the Graph workbook API, calling it with curl piped into jq from Bash. It looks the file up in OneDrive first and keeps its id as ITEM_ID. From there you can list worksheets and pull a used range or something like A1:C5.

Writes go through PATCH on a range address, with a 2-D array whose shape matches the address. New table rows land in tables/Table1/rows/add. The skill asks for confirmation before changing anything. Errors arrive as an object holding code and message, and the message is shown as it came.

Your bearer token sits in $MICROSOFT_EXCEL_TOKEN. A 401 means it expired and the connector has to be reinstalled; 403 on a write means the grant is read-only. A local .xlsx dropped into the chat is a different job — parse it directly instead. Long edit runs can pass the workbook-session-id header, a few cells are fine without it.

What it helps with

  • read a used range from a OneDrive workbook
  • append a row to Table1
  • patch cells A2:B3 without downloading the file
  • list worksheets to find where the numbers live
  • resolve a filename to its ITEM_ID

Example prompts for the agent

  • Show me the used range on Sheet1 of budget.xlsx in OneDrive
  • Append a row to Table1 with 2026-06-21, Acme and 4200
  • List the worksheets and tell me which one holds the quarterly figures

How to install microsoft-excel

1Skills CLI (Vercel)

npx skills add AceDataCloud/Skills --skill microsoft-excel -a claude-code

2Manually: put the files in place

~/.claude/skills/microsoft-excel/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/microsoft-excel/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about microsoft-excel

How do I install microsoft-excel in Claude Code?

Run npx skills add AceDataCloud/Skills --skill microsoft-excel -a claude-code. The skill lands in ~/.claude/skills/microsoft-excel/SKILL.md.

What does microsoft-excel do?

It reads and edits live Excel workbooks stored in OneDrive or SharePoint: ranges, cells, table rows, worksheet lists. Calls are plain curl plus jq against Microsoft Graph.

Does it work on a local .xlsx file?

No. It targets a drive item in OneDrive or SharePoint, so it needs that file's ITEM_ID. A spreadsheet uploaded into the chat is parsed directly instead.

Source text

SKILL.md · Apache-2.0
---
name: microsoft-excel
description: Read and edit live Excel workbooks stored in OneDrive / SharePoint via the Microsoft Graph workbook API. Use when the user mentions an Excel file, a spreadsheet on OneDrive, reading a range or table, appending rows, updating cells, or listing worksheets in a cloud .xlsx.
when_to_use: |
  Trigger when the user wants to read or write a cloud Excel workbook
  (one that lives in their OneDrive / SharePoint) — read a used range,
  read/update cells, add rows to a table, list worksheets. The
  connector grants `Files.ReadWrite` (or `Files.Read` read-only). Find
  the file id first via OneDrive search; confirm before writes.
connections: [microsoft/excel]
allowed_tools: [Bash]
license: Apache-2.0
metadata:
  author: acedatacloud
  version: "1.0"
---

Drive **live Excel workbooks** via the Microsoft Graph workbook API with
`curl + jq`. The user's OAuth bearer token is in `$MICROSOFT_EXCEL_TOKEN`; every
call needs `Authorization: Bearer $MICROSOFT_EXCEL_TOKEN`. Base URL:
`https://graph.microsoft.com/v1.0`. The workbook API operates on a **drive item**
(an .xlsx in OneDrive/SharePoint), so you need its `ITEM_ID`.

Failures are `{"error":{"code","message"}}` — show `message` verbatim. `401` =
token expired (re-install). `403` on a write = the user granted read-only.

```bash
G="https://graph.microsoft.com/v1.0"; AUTH="Authorization: Bearer $MICROSOFT_EXCEL_TOKEN"
# Find the workbook by name (then take .id as ITEM_ID)
curl -sS -H "$AUTH" "$G/me/drive/root/search(q='budget.xlsx')" \
  | jq '.value[] | {id, name, webUrl}'
# Worksheets in the workbook
curl -sS -H "$AUTH" "$G/me/drive/items/ITEM_ID/workbook/worksheets" \
  | jq '.value[] | {id, name, position}'
```

## Read & write ranges

```bash
ITEM="ITEM_ID"; WS="Sheet1"
# Used range (values + formulas + formats)
curl -sS -H "$AUTH" \
  "$G/me/drive/items/$ITEM/workbook/worksheets/$WS/usedRange" \
  | jq '{address, values: .values}'

# Read a specific range
curl -sS -H "$AUTH" \
  "$G/me/drive/items/$ITEM/workbook/worksheets/$WS/range(address='A1:C5')" | jq '.values'

# Update a range (confirm first). values is a 2-D array matching the address shape.
curl -sS -X PATCH -H "$AUTH" -H "Content-Type: application/json" \
  -d '{"values":[["Q3",1200],["Q4",1580]]}' \
  "$G/me/drive/items/$ITEM/workbook/worksheets/$WS/range(address='A2:B3')" | jq '.address'
```

## Append a row to a table

```bash
curl -sS -X POST -H "$AUTH" -H "Content-Type: application/json" \
  -d '{"values":[["2026-06-21","Acme",4200]]}' \
  "$G/me/drive/items/$ITEM/workbook/tables/Table1/rows/add" | jq '.index'
```

## Gotchas

- This is for **cloud** workbooks (OneDrive/SharePoint). A local .xlsx the user
  uploaded into chat is a different job (parse the file directly), not this skill.
- Range `address` is a string like `Sheet1!A1:C5` or just `A1:C5` when scoped to a
  worksheet; `values` must be a 2-D array matching its dimensions.
- For long-running edits Graph supports a **workbook session** header
  (`workbook-session-id`); for a few cells the default sessionless mode is fine.

© acedatacloud · Apache-2.0 · AceDataCloud/Skills

Similar skills

All skills for Office documents →

From the same set67

The whole set →

More in the catalog

Project sponsors

Companies that keep this analytics open