Skip to main content
skill CX Codex

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

Install into Claude Code · Plugin marketplace All methods and platforms ↓
/plugin marketplace add microsoft/power-platform-skills
/plugin install code-apps-preview@power-platform-skills
Open on GitHub

What 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 app CLI
  • scaffold AddRowIntoTable TypeScript 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-skills

This 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-code

3Manually: put the files in place

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

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

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

Similar skills

All skills for Office documents →

From the same set157

The whole set →
add-onedrive add-onedrive adds OneDrive for Business connector to a Power Apps code app and configures file operations. CX Codex +1 ★ 1,167repo stars browse-flows browse-flows explores Power Automate environments and flows inside Claude Code. Useful when you need to inspect existing cloud flows, view triggers, or pick a flow for debugging. CX Codex +1 ★ 1,167repo stars canvas-create-functionality The canvas-create-functionality subagent records app users, tasks, requirements, and observable outcomes before Canvas screens are designed. Use it to shape the requested functionality first. CX Codex ★ 1,167repo stars route-environments route-environments is a Claude Code skill that checks Power Platform environment routing and shows where new makers land when they open the platform. CX Codex +1 ★ 1,167repo stars canvas-create-builder canvas-create-builder is a Claude Code subagent that writes a single Power Apps screen YAML file from approved designs. The coordinator agent runs it after layout and data bindings are verified. CX Codex ★ 1,167repo stars add-datasource add-datasource — a router skill that asks what your Power Apps code app should do, then hands the job to the right connector skill. Useful when you need data but aren't sure which connector fits. CX Codex +1 ★ 1,167repo stars manage-desktop-flows manage-desktop-flows manages Power Automate Desktop RPA flows and machine groups in Claude Code. Triggers attended or unattended tasks directly from chat. CX Codex +1 ★ 1,167repo stars investigate-process investigate-process investigates broad Process Mining questions through hypotheses, comparisons, and specialist analysis. Use it when one metric cannot explain the finding. CX Codex +1 ★ 1,167repo stars

More in the catalog

Project sponsors

Companies that keep this analytics open