# Excel Sheet > Excel (.xlsx) manipulation via MCP server. Use for creating workbooks, formatting cells, writing formulas, building charts, pivot tables, data analysis, or any task involving Excel spreadsheets. - Skill: `practicalswan/excel-sheet` (Agent Skill, multi-file: 6 files) - Install (CLI): `npx skillmds add practicalswan/excel-sheet` - Raw SKILL.md: https://api.skillmd.com/api/skills/practicalswan/excel-sheet/raw - Safety review: pending - Works with: Claude Code, Claude.ai, OpenAI Codex - Category: Data & Analytics - Author: practicalswan (https://skillmd.com/u/practicalswan) - Updated: 2026-09-09 - Page: https://skillmd.com/skills/practicalswan/excel-sheet --- # Excel Spreadsheet Workflows > Tech Stack Target / Version: Excel desktop or `openpyxl`-based spreadsheet automation with current OOXML-compatible workflows. Use this skill when the deliverable is an `.xlsx` workbook or when spreadsheet structure matters. - Leverage native parallel subagent dispatch and 200k+ context windows where available. ## Current MCP Reality Excel MCP tooling is host-dependent. In GitHub Copilot, Excel actions may appear as grouped Office tools. In Codex or Claude, those tools may be absent entirely. Treat the included Python script as the reliable fallback. ## Activation Conditions Use symptom -> action triggers: when one matches, apply this skill and verify with the protocol below. - Creating or updating workbooks - Converting CSV data into structured Excel output - Applying formulas, formatting, charts, or pivots - Producing spreadsheet deliverables when layout matters ## Practical Workflow 1. Confirm whether the client exposes spreadsheet MCP tools. 2. If yes, inspect the actual tool names before assuming a wrapper exists. 3. If no, use the local converter or author the workbook with `openpyxl`. 4. Validate formulas and chart ranges before claiming the workbook is ready. ## MCP Fallback – Native Automation When MCP is unavailable, use native automation: `openpyxl` for `.xlsx`, CSV export for flat data, and manual formula inspection for high-risk calculations. Preserve formulas, number formats, sheet names, hidden sheets, and workbook metadata, then reopen or parse the workbook before claiming success. ## Cross-Client Portability This skill is written to stay usable across GitHub Copilot, Claude Code, and Codex. - GitHub Copilot: keep the folder in a Copilot-visible skill path or wrap the workflow in project instructions when folder discovery is unavailable. - Claude Code: keep the folder in a local skills directory or a compatible plugin source. - Codex: install or sync the folder into `$CODEX_HOME/skills/excel-sheet` and restart Codex after major changes. ## MCP Availability And Fallback Preferred MCP Server: Excel MCP - Fallback prompt: "Use the Excel Spreadsheet Workflows skill without MCP. Follow the documented local or manual fallback, show the selected tool surface, and report the verification evidence." - Use `scripts/csv-to-xlsx.py`, `openpyxl`, or desktop Excel when the spreadsheet MCP surface is missing. - Re-open the generated workbook locally to verify formulas, ranges, and frozen panes. - Do not claim an MCP operation was used when the active host does not expose it. ## Anti-Patterns - Treating source content as already clean: Formatting automation will happily preserve broken or inconsistent input. - Skipping an open-file verification pass: Documents and spreadsheets often fail in the destination app, not in the script output. - Automating irreversible edits without checkpoints: A small mapping mistake can affect an entire workbook or document. ## Verification Protocol Before claiming "skill applied successfully": 1. Pass/fail: The Excel Sheet artifact type, target format, and required output fidelity are stated before editing. 2. Pass/fail: MCP availability is checked and the native automation fallback path is named when MCP is absent. 3. Pass/fail: The produced file or formula is opened, parsed, rendered, or otherwise validated locally. 4. Pressure-test scenario: Apply the workflow to a file with formatting, metadata, or conversion edge cases and verify nothing important is lost. 5. Success metric: Zero unverified document claims; the artifact itself is the evidence. ## Workbook Checklist - [ ] Sheets are named clearly - [ ] Headers are formatted consistently - [ ] Formulas are used instead of hardcoded derived values - [ ] Charts reference the correct ranges - [ ] Frozen panes or filters are applied where useful ## References & Resources ### Documentation - [Excel Formulas Reference](./references/excel-formulas-reference.md) - Formula patterns, lookup guidance, and Power Query notes ### Scripts - [CSV to XLSX Converter](./scripts/csv-to-xlsx.py) - Local fallback for generating formatted Excel workbooks from CSV input ### Examples - [Excel Workbook Examples](./examples/excel-workbook-examples.md) - Example workbook structures and automation patterns ## Related Skills - [documentation-authoring](../documentation-authoring/SKILL.md): Use it when the workflow also needs drafting structured technical or product documents. - [notion-docs](../notion-docs/SKILL.md): Use it when the workflow also needs Notion page and database publishing workflows. - [pdf](../pdf/SKILL.md): Use it when the workflow also needs PDF extraction, generation, and layout-aware review. - [word-document](../word-document/SKILL.md): Use it when the workflow also needs Word document authoring and formatting workflows.