Excel Spreadsheet Workflows
Use this skill when the deliverable is an .xlsx workbook or when spreadsheet structure matters.
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
- 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.
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 - Formula patterns, lookup guidance, and Power Query notes
Scripts
- CSV to XLSX Converter - Local fallback for generating formatted Excel workbooks from CSV input
Examples
- Excel Workbook Examples - Example workbook structures and automation patterns
Related Skills
| Skill | Relationship |
|---|---|
| microsoft-development | Microsoft docs and ecosystem context |
| powerbi-modeling | Shape workbook exports for Power BI ingestion or review |
| word-document | Move spreadsheet output into formal reports |
| powerpoint-ppt | Move charts and summary data into slide decks |