add-excel — Claude Code skill: what it does, how to install
add-excel attaches the Excel Online (Business) connector to Power Apps code apps to read and write workbook tables in OneDrive or SharePoint.
MIT ★ 1,167 updated 2026-10-29
/plugin marketplace add microsoft/power-platform-skills
/plugin install code-apps-preview@power-platform-skillsWhat add-excel does
The skill manages the end-to-end process of bringing Excel Online into a Power Apps code app. It prompts you for the storage location, workbook filename, and specific table names. Next, it looks up the connection ID using /list-connections and attaches the tabular data source with pa app add data-source.
On the TypeScript side, it prepares calls to ExcelOnlineBusinessService. Rows inserted via AddRowIntoTable require a flat key-value object mapped to column headers rather than a wrapped items payload. Without an existing Excel connection in the target environment, the registration command fails until you create one in make.powerapps.com.
After scaffolding the service logic, the skill executes npm run build to catch type errors before recording the setup in memory-bank.md.
What it helps with
- attach an Excel table from personal OneDrive to a Power Apps code app
- bind SharePoint document library workbooks using the
pa appCLI - scaffold
AddRowIntoTableTypeScript calls with flat payload structures - verify TypeScript compilation after adding tabular data sources
Example prompts for the agent
- Connect the Customers table from sales.xlsx in my OneDrive to this Power App
- Add the Excel Online data source from SharePoint site sites/marketing for table Leads
- Configure inserting rows into the Orders Excel table using ExcelOnlineBusinessService
How to install add-excel
1Plugin marketplace
/plugin marketplace add microsoft/power-platform-skills/plugin install code-apps-preview@power-platform-skillsThis installs the whole code-apps-preview plugin with all its skills
2Skills CLI (Vercel)
npx skills add microsoft/power-platform-skills --skill add-excel -a claude-code3Manually: put the files in place
~/.claude/skills/add-excel/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/add-excel/
1Skills CLI (Vercel)
npx skills add microsoft/power-platform-skills --skill add-excel -a codex2Manually: put the files in place
.agents/skills/add-excel/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add microsoft/power-platform-skills --skill add-excel -a cursor2Manually: put the files in place
.cursor/skills/add-excel/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install microsoft/power-platform-skills plugins/code-apps/skills/add-excel2Manually: put the files in place
.github/skills/add-excel/SKILL.md1Skills CLI (Vercel)
npx skills add microsoft/power-platform-skills --skill add-excel -a gemini-cli2Platform CLI
gemini skills install https://github.com/microsoft/power-platform-skills --path plugins/code-apps/skills/add-excelManually: put the files in place
.devin/skills/add-excel/SKILL.mdThe legacy .windsurf/skills/ path still works
Claude.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 add-excel
How to install add-excel in Claude Code?
Run npx skills add microsoft/power-platform-skills --skill add-excel -a claude-code in your terminal. Alternatively, add the marketplace with /plugin marketplace add microsoft/power-platform-skills and install via /plugin install code-apps-preview@power-platform-skills.
What does add-excel do?
It guides the integration of Excel Online tables into Power Apps code apps, running CLI registration commands and writing typed code to query or update rows.
How should row data be structured for AddRowIntoTable?
The body argument must be a flat dictionary where keys directly match workbook column headers. Do not wrap the properties inside an items object.
Source text
SKILL.md · MIT
---
name: add-excel
description: Adds Excel Online (Business) connector to a Power Apps code app. Use when reading or writing Excel workbook data from OneDrive or SharePoint.
user-invocable: true
allowed-tools: Read, Edit, Write, Grep, Glob, Bash, LSP, TaskCreate, TaskUpdate, TaskList, TaskGet, AskUserQuestion, Skill
model: sonnet
---
**📋 Shared Instructions: [shared-instructions.md](${PLUGIN_ROOT}/shared/shared-instructions.md)** - Cross-cutting concerns.
# Add Excel Online
## Workflow
1. Check Memory Bank → 2. Gather → 3. Add Connector → 4. Configure → 5. Build → 6. Update Memory Bank
---
### Step 1: Check Memory Bank
Check for `memory-bank.md` per [shared-instructions.md](${PLUGIN_ROOT}/shared/shared-instructions.md).
### Step 2: Gather
Ask the user:
1. Where is the workbook? (OneDrive or SharePoint)
2. Workbook file name
3. Which table(s) in the workbook to access
### Step 3: Add Connector
**First, find the connection ID** (see [connector-reference.md](${PLUGIN_ROOT}/shared/connector-reference.md)):
Run the `/list-connections` skill. Find the Excel Online (Business) connection in the output. If none exists, direct the user to create one using the environment-specific Connections URL — construct it from the active environment ID in context (from `power.config.json` or a prior step): `https://make.powerapps.com/environments/<environment-id>/connections` → **+ New connection** → search for the connector → Create.
Excel Online is a tabular datasource -- requires `-c` (connection ID), `-d` (drive), and `--table` (table name in workbook):
```bash
# OneDrive workbook
pa app add data-source --connector excelonlinebusiness -c <connection-id> -d 'me' --table 'Table1'
# SharePoint workbook -- dataset is the document library path
pa app add data-source --connector excelonlinebusiness -c <connection-id> -d 'sites/your-site' --table 'Table1'
```
Run for each table the user needs.
### Step 4: Configure
**AddRowIntoTable** -- adds a row to an Excel table:
```typescript
// OneDrive workbook
await ExcelOnlineBusinessService.AddRowIntoTable({
source: "me",
drive: "me",
file: "MyWorkbook.xlsx",
table: "Table1",
body: { column1: "value1", column2: "value2" } // Flat object, NO "items" wrapper
});
// SharePoint workbook
await ExcelOnlineBusinessService.AddRowIntoTable({
source: "sites/your-site",
drive: "drive-id",
file: "SharedWorkbook.xlsx",
table: "Table1",
body: { column1: "value1", column2: "value2" }
});
```
**Key points:**
- `source: "me"` and `drive: "me"` for OneDrive personal files
- For SharePoint, use the site path and drive ID
- The `body` is a flat key-value object matching column headers -- do NOT wrap in `{ items: ... }`
Use `Grep` to find specific methods in `src/generated/services/ExcelOnlineBusinessService.ts` (generated files can be very large -- see [connector-reference.md](${PLUGIN_ROOT}/shared/connector-reference.md#inspecting-large-generated-files)).
### Step 5: Build
```bash
npm run build
```
Fix TypeScript errors before proceeding. Do NOT deploy yet.
### Step 6: Update Memory Bank
Update `memory-bank.md` with: connector added, workbook/table configured, build status.
© Microsoft · MIT · microsoft/power-platform-skills