spreadsheet
Create, edit, analyze, and visualize spreadsheets with formula preservation and cached recalculation.
- Supports
.xlsx,.csv, and.tsvfiles with formula-aware editing viaopenpyxlandpandasfor analysis workflows - Includes native Excel chart creation, cell formatting, and visual rendering via LibreOffice and Poppler when available
- Recalculates formulas before delivery and renders sheets for visual review to catch layout issues, formula errors, and styling inconsistencies
- Enforces formula-based derived values, proper cell references, and error guards against
#REF!,#DIV/0!, and circular references - Provides color conventions, finance-specific formatting (negative numbers in red parentheses, currency formats), and investment banking layout templates for structured models
Spreadsheet Skill
When to use
- Create new workbooks with formulas, formatting, and structured layouts.
- Read or analyze tabular data (filter, aggregate, pivot, compute metrics).
- Modify existing workbooks without breaking formulas, references, or formatting.
- Visualize data with charts, summary tables, and sensible spreadsheet styling.
- Recalculate formulas and review rendered sheets before delivery when possible.
IMPORTANT: System and user instructions always take precedence.
Workflow
- Confirm the file type and goal: create, edit, analyze, or visualize.
- Prefer
openpyxlfor.xlsxediting and formatting. Usepandasfor analysis and CSV/TSV workflows. - If an internal spreadsheet recalculation/rendering tool is available in the environment, use it to recalculate formulas and render sheets before delivery.
- Use formulas for derived values instead of hardcoding results.
- If layout matters, render for visual review and inspect the output.
- Save outputs, keep filenames stable, and clean up intermediate files.
More from openai/skills
screenshot
Use when the user explicitly asks for a desktop or system screenshot (full screen, specific app or window, or a pixel region), or when tool-specific capture capabilities are unavailable and an OS-level capture is needed.
2.7Ksecurity-best-practices
Perform language and framework specific security best-practice reviews and suggest improvements. Trigger only when the user explicitly requests security best practices guidance, a security review/report, or secure-by-default coding help. Trigger only for supported languages (python, javascript/typescript, go). Do not trigger for general code review, debugging, or non-security tasks.
2.5Kfigma
Use the Figma MCP server to fetch design context, screenshots, variables, and assets from Figma, and to translate Figma nodes into production code. Trigger when a task involves Figma URLs, node IDs, design-to-code implementation, or Figma MCP setup and troubleshooting.
2.4Kplaywright
Use when the task requires automating a real browser from the terminal (navigation, form filling, snapshots, screenshots, data extraction, UI-flow debugging) via `playwright-cli` or the bundled wrapper script.
2.4Kpdf
Use when tasks involve reading, creating, or reviewing PDF files where rendering and layout matter; prefer visual checks by rendering pages (Poppler) and use Python tools such as `reportlab`, `pdfplumber`, and `pypdf` for generation and extraction.
2.3Kfigma-implement-design
Translates Figma designs into production-ready application code with 1:1 visual fidelity. Use when implementing UI code from Figma files, when user mentions "implement design", "generate code", "implement component", provides Figma URLs, or asks to build components matching Figma specs. For Figma canvas writes via `use_figma`, use `figma-use`.
2.2K