Official agent skill

Add Excel

by microsoft in microsoft/power-platform-skills

Adds Excel Online (Business) connector to a Power Apps code app.

OfficialMITAuto-check: notesDocuments & Office

Install Add Excel

skills CLI
$ npx skills add microsoft/power-platform-skills --skill add-excel -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install microsoft/power-platform-skills add-excel --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/microsoft/power-platform-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/plugins/code-apps/skills/add-excel .claude/skills/add-excel && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
add-excel
GitHub stars
967
Token cost
~796 tokens
SKILL.md length
236 words
Files
1
Skills in repo
87
Repo updated
First seen
Licence
MIT

At a glance

Adds Excel Online (Business) connector to a Power Apps code app.

  • Works in 6 steps: Check Memory Bank → Gather → Add Connector → …
  • Writing Excel workbook data from OneDrive
  • Calls npm; reaches make.powerapps.com
  • Tasks that involve Excel spreadsheets

What it does

Add Excel is an agent skill from microsoft/power-platform-skills, published by the product's own GitHub organization. Adds Excel Online (Business) connector to a Power Apps code app. Use when reading or writing Excel workbook data from OneDrive or SharePoint.

Its SKILL.md is about 800 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Documents & Office, covering Excel spreadsheets and Cloud office suites. It works with Microsoft Excel, Microsoft OneDrive, Microsoft SharePoint and TypeScript. The repository describes itself as: A plugin marketplace for GitHub Copilot and other AI agents that provides Power Platform development plugins, including reusable skills, agents, and commands for building and… The licence is MIT.

When your agent uses it

  • Writing Excel workbook data from OneDrive
  • Tasks that involve Excel spreadsheets
  • Tasks that involve Cloud office suites

Example prompts

  • “/add-excel”

Requirements

  • Pre-approved tools (allowed-tools): Read, Edit, Write, Grep, Glob, Bash, LSP, TaskCreate, TaskUpdate, TaskList, TaskGet, AskUserQuestion, Skill

Workflow steps

6 steps, taken from the step headings in SKILL.md.

  1. Check Memory Bank
  2. Gather
  3. Add Connector
  4. Configure
  5. Build
  6. Update Memory Bank

What it can do on your machine

Read from SKILL.md and the folder at commit 5ef4e4f. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves these tools, so the agent can use them without asking each time:

    • Read
    • Edit
    • Write
    • Grep
    • Glob
    • Bash
    • LSP
    • TaskCreate
    • TaskUpdate
    • TaskList

    …and 3 more on the same allowed-tools line.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • npm

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Hosts in commands or code, which the agent is likely to contact:

    • make.powerapps.com

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Add Excel loads about 796 tokens when it runs. Until then it costs about 38 tokens; SKILL.md has 236 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~38
When it runs · the whole SKILL.md, loaded when a task matches
~796

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check: notes

The automated check noted patterns worth knowing about, such as sudo or a known installer.

  • NotePre-approves every shell command (allowed-tools: Bash)SKILL.md
    allowed-tools: Read, Edit, Write, Grep, Glob, Bash, LSP, TaskCreate, TaskUpdate, TaskList, TaskGet, AskUserQuestion

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from microsoft/power-platform-skills at commit 5ef4e4f, republished under its MIT licence (© microsoft). 236 words, ~796 tokens.

Download SKILL.mdSave it as .claude/skills/add-excel/SKILL.md (or your agent's skills folder).
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.
allowed-tools
Read, Edit, Write, Grep, Glob, Bash, LSP, TaskCreate, TaskUpdate, TaskList, TaskGet, AskUserQuestion, Skill
user-invocable
true
model
sonnet

📋 Shared Instructions: 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.

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):

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

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. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in plugins/code-apps/skills/add-excel of microsoft/power-platform-skills.

Open the folder on GitHubat commit 5ef4e4f

Compare with similar skills

Add Excel next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Add Excel compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Add Excel this skillmicrosoft/power-platform-skills967—~796Automated safety check: NotesMIT
aai-cli Microsoft 365aai-labs/agent-barn109—~1.2kAutomated safety check: PassApache-2.0
Sharepoint Safe HTMLpnp/sharepoint-skills131—~6.4kAutomated safety check: PassMIT
Learniurykrieger/claude-bedrock105—~6.5kAutomated safety check: NotesMIT
Microsoft ExcelCraftOS-dev/CraftBot3921 repos~3.5kAutomated safety check: PassMIT
Sync Blocker Auditorpnp/sharepoint-skills131—~3.9kAutomated safety check: PassMIT

Similar skills

  • aai-cli Microsoft 365

    aai-labs/agent-barn

    Guides work with Outlook, OneDrive, SharePoint, Teams, Excel, To Do and Planner through aai-cli's Microsoft Graph commands, starting from which service owns the data.

    109 GitHub stars~1.2k tokensUpdated today
    Documents & OfficeAuto-check passed
  • Sharepoint Safe HTML

    pnp/sharepoint-skills

    Creates accessible, single-file HTML artifacts that render reliably in SharePoint, OneDrive, Teams, File Viewer, and embedded iframe preview surfaces.

    131 GitHub stars~6.4k tokensUpdated yesterday
    Documents & OfficeAuto-check passed
  • Learn

    iurykrieger/claude-bedrock

    Ingests an external data source into the Second Brain. An agent skill from iurykrieger/claude-bedrock.

    105 GitHub stars~6.5k tokensUpdated 5 mo ago
    Documents & OfficeAuto-check: notes
  • Microsoft Excel

    CraftOS-dev/CraftBot

    Microsoft Excel API integration with managed OAuth. An agent skill from CraftOS-dev/CraftBot.

    392 GitHub starsUsed in 1 repo~3.5k tokens
    EducationAuto-check passed
  • Sync Blocker Auditor

    pnp/sharepoint-skills

    Audits a SharePoint document library for names and paths that break OneDrive sync, File Explorer, and Teams file access.

    131 GitHub stars~3.9k tokensUpdated yesterday
    Documents & OfficeAuto-check passed
  • Teach

    ccplugins/awesome-claude-code-plugins

    Teaches the Second Brain to recognize a new external data source.

    967 GitHub stars~5.9k tokensUpdated 1 mo ago
    Documents & OfficeAuto-check: notes

More from microsoft/power-platform-skills

All 87 skills in this repo
  • Manage Firewall

    microsoft/power-platform-skills

    Official

    Inspects and configures the web application firewall (WAF) in front of a Power Pages production site.

    967 GitHub stars~4.5k tokensUpdated today
    Auto-check: notes
  • Manage Headers

    microsoft/power-platform-skills

    Official

    Inspects and configures the security headers a Power Pages site sends to browsers — Content Security Policy, frame and clickjacking protection, cross-origin sharing, cookie behavior, and related…

    967 GitHub stars~3k tokensUpdated today
    Auto-check: notes
  • Scan Code

    microsoft/power-platform-skills

    Official

    Scans a Power Pages site project for security issues in source code and dependencies.

    967 GitHub stars~3.4k tokensUpdated today
    Auto-check: notes
  • Scan Site

    microsoft/power-platform-skills

    Official

    Runs a security scan on a deployed Power Pages site, fetches the latest scan report, and produces a plain-language summary.

    967 GitHub stars~3.2k tokensUpdated today
    Auto-check: notes
  • Setup Datamodel

    microsoft/power-platform-skills

    Official

    Creates Dataverse tables, columns, and relationships for a Power Pages site based on a data model proposal.

    967 GitHub stars~4k tokensUpdated today
    Auto-check: notes
  • Add Server Logic

    microsoft/power-platform-skills

    Official

    Creates, edits, and manages Power Pages Server Logic files — server-side JavaScript that runs securely on the Power Pages runtime.

    967 GitHub stars~18k tokensUpdated today
    Auto-check: notes

Questions about Add Excel

What does Add Excel do?

Adds Excel Online (Business) connector to a Power Apps code app. Add Excel is an agent skill from microsoft/power-platform-skills, published by the product's own GitHub organization. Adds Excel Online (Business) connector to a Power Apps code app.

When should I use Add Excel?

Add Excel fits situations like: writing Excel workbook data from OneDrive; tasks that involve Excel spreadsheets; tasks that involve Cloud office suites.

How do I install Add Excel in Claude Code?

Run `npx skills add microsoft/power-platform-skills --skill add-excel -a claude-code`. Or copy the skill folder (plugins/code-apps/skills/add-excel in microsoft/power-platform-skills) into .claude/skills/add-excel in your project. Claude Code loads it when a task matches its description.

How do I install Add Excel in Codex?

Run `npx skills add microsoft/power-platform-skills --skill add-excel -a codex`. Or copy the skill folder (plugins/code-apps/skills/add-excel in microsoft/power-platform-skills) into .agents/skills/add-excel in your project. Codex loads it when a task matches its description.

Can I use Add Excel in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add microsoft/power-platform-skills --skill add-excel -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/add-excel, .gemini/skills/add-excel, .github/skills/add-excel and .opencode/skills/add-excel in your project.

What does Add Excel need to run?

Going by SKILL.md and its folder, Add Excel needs the command-line tools its instructions call (npm). Its frontmatter pre-approves these tools: Read, Edit, Write, Grep, Glob, Bash, LSP, TaskCreate, TaskUpdate, TaskList, TaskGet, AskUserQuestion, Skill.

Does Add Excel access the network?

SKILL.md names 1 domain. In commands or code: make.powerapps.com; the agent is likely to contact it when it follows the instructions. This is read from the text; nothing was executed.

Is Add Excel safe to install?

Our automated static check of SKILL.md found notes only (pre-approves every shell command (allowed-tools: bash)), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.

What licence does Add Excel use?

Add Excel is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Add Excel use?

About 796 tokens (SKILL.md is roughly 3.2k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Add Excel?

Skills that share tags, products or a category with Add Excel: aai-cli Microsoft 365 (aai-labs/agent-barn, 109 stars), Sharepoint Safe HTML (pnp/sharepoint-skills, 131 stars), Learn (iurykrieger/claude-bedrock, 105 stars) and Microsoft Excel (CraftOS-dev/CraftBot, 392 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Add Excel?

microsoft (a GitHub organization, an official publisher) maintains it in microsoft/power-platform-skills, which has 967 GitHub stars. The repository holds 87 skills in this directory. The repository was last updated on October 6, 2026.

Source: microsoft/power-platform-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.