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
npx skills add AceDataCloud/Skills --skill microsoft-excel -a claude-codeWhat 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:B3without 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
Sheet1ofbudget.xlsxin OneDrive - Append a row to
Table1with 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-code2Manually: put the files in place
~/.claude/skills/microsoft-excel/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/microsoft-excel/
1Skills CLI (Vercel)
npx skills add AceDataCloud/Skills --skill microsoft-excel -a codex2Manually: put the files in place
.agents/skills/microsoft-excel/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add AceDataCloud/Skills --skill microsoft-excel -a cursor2Manually: put the files in place
.cursor/skills/microsoft-excel/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install AceDataCloud/Skills skills/microsoft-excel2Manually: put the files in place
.github/skills/microsoft-excel/SKILL.md1Skills CLI (Vercel)
npx skills add AceDataCloud/Skills --skill microsoft-excel -a gemini-cli2Platform CLI
gemini skills install https://github.com/AceDataCloud/Skills --path skills/microsoft-excelManually: put the files in place
.devin/skills/microsoft-excel/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add AceDataCloud/Skills --skill microsoft-excel -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
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