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
- Confirm whether the client exposes spreadsheet MCP tools.
- If yes, inspect the actual tool names before assuming a wrapper exists.
- If no, use the local converter or author the workbook with
openpyxl.
- 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":
- Pass/fail: The Excel Sheet artifact type, target format, and required output fidelity are stated before editing.
- Pass/fail: MCP availability is checked and the native automation fallback path is named when MCP is absent.
- Pass/fail: The produced file or formula is opened, parsed, rendered, or otherwise validated locally.
- Pressure-test scenario: Apply the workflow to a file with formatting, metadata, or conversion edge cases and verify nothing important is lost.
- Success metric: Zero unverified document claims; the artifact itself is the evidence.
Workbook Checklist
References & Resources
Documentation
Scripts
Examples
Related Skills
- documentation-authoring: Use it when the workflow also needs drafting structured technical or product documents.
- notion-docs: Use it when the workflow also needs Notion page and database publishing workflows.
- pdf: Use it when the workflow also needs PDF extraction, generation, and layout-aware review.
- word-document: Use it when the workflow also needs Word document authoring and formatting workflows.
1---
2name: excel-sheet
3version: "2.0"
4last_updated: 2026-09-08
5tags: [spreadsheet, sheet, documents, automation, productivity]
6description: "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."
7metadata:
8 source: https://skillmd.com/skills/practicalswan/excel-sheet
9---
10
11# Excel Spreadsheet Workflows
12
13> Tech Stack Target / Version: Excel desktop or `openpyxl`-based spreadsheet automation with current OOXML-compatible workflows.
14
15Use this skill when the deliverable is an `.xlsx` workbook or when spreadsheet structure matters.
16
17- Leverage native parallel subagent dispatch and 200k+ context windows where available.
18
19
20## Current MCP Reality
21
22Excel 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.
23
24## Activation Conditions
25
26Use symptom -> action triggers: when one matches, apply this skill and verify with the protocol below.
27
28- Creating or updating workbooks
29- Converting CSV data into structured Excel output
30- Applying formulas, formatting, charts, or pivots
31- Producing spreadsheet deliverables when layout matters
32
33## Practical Workflow
34
351. Confirm whether the client exposes spreadsheet MCP tools.
362. If yes, inspect the actual tool names before assuming a wrapper exists.
373. If no, use the local converter or author the workbook with `openpyxl`.
384. Validate formulas and chart ranges before claiming the workbook is ready.
39
40## MCP Fallback – Native Automation
41
42When 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.
43
44<!-- MCP:START -->
45
46<!-- PORTABILITY:START -->
47## Cross-Client Portability
48
49This skill is written to stay usable across GitHub Copilot, Claude Code, and Codex.
50
51- GitHub Copilot: keep the folder in a Copilot-visible skill path or wrap the
52 workflow in project instructions when folder discovery is unavailable.
53- Claude Code: keep the folder in a local skills directory or a compatible plugin source.
54- Codex: install or sync the folder into
55 `$CODEX_HOME/skills/excel-sheet` and restart Codex after major changes.
56
57<!-- PORTABILITY:END -->
58
59## MCP Availability And Fallback
60
61Preferred MCP Server: Excel MCP
62
63- 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."
64- Use `scripts/csv-to-xlsx.py`, `openpyxl`, or desktop Excel when the spreadsheet MCP surface is missing.
65- Re-open the generated workbook locally to verify formulas, ranges, and frozen panes.
66- Do not claim an MCP operation was used when the active host does not expose it.
67
68<!-- MCP:END -->
69
70## Anti-Patterns
71
72- Treating source content as already clean: Formatting automation will happily preserve broken or inconsistent input.
73- Skipping an open-file verification pass: Documents and spreadsheets often fail in the destination app, not in the script output.
74- Automating irreversible edits without checkpoints: A small mapping mistake can affect an entire workbook or document.
75
76## Verification Protocol
77
78Before claiming "skill applied successfully":
79
801. Pass/fail: The Excel Sheet artifact type, target format, and required output fidelity are stated before editing.
812. Pass/fail: MCP availability is checked and the native automation fallback path is named when MCP is absent.
823. Pass/fail: The produced file or formula is opened, parsed, rendered, or otherwise validated locally.
834. Pressure-test scenario: Apply the workflow to a file with formatting, metadata, or conversion edge cases and verify nothing important is lost.
845. Success metric: Zero unverified document claims; the artifact itself is the evidence.
85
86## Workbook Checklist
87
88- [ ] Sheets are named clearly
89- [ ] Headers are formatted consistently
90- [ ] Formulas are used instead of hardcoded derived values
91- [ ] Charts reference the correct ranges
92- [ ] Frozen panes or filters are applied where useful
93
94## References & Resources
95
96### Documentation
97- [Excel Formulas Reference](./references/excel-formulas-reference.md) - Formula patterns, lookup guidance, and Power Query notes
98
99### Scripts
100- [CSV to XLSX Converter](./scripts/csv-to-xlsx.py) - Local fallback for generating formatted Excel workbooks from CSV input
101
102### Examples
103- [Excel Workbook Examples](./examples/excel-workbook-examples.md) - Example workbook structures and automation patterns
104
105## Related Skills
106
107- [documentation-authoring](../documentation-authoring/SKILL.md): Use it when the workflow also needs drafting structured technical or product documents.
108- [notion-docs](../notion-docs/SKILL.md): Use it when the workflow also needs Notion page and database publishing workflows.
109- [pdf](../pdf/SKILL.md): Use it when the workflow also needs PDF extraction, generation, and layout-aware review.
110- [word-document](../word-document/SKILL.md): Use it when the workflow also needs Word document authoring and formatting workflows.