Spreadsheet

This is a comprehensive toolkit for working with Excel and CSV files through Claude, covering everything from quick data analysis to full investment banking models. It uses openpyxl for preserving formatting and formulas in .xlsx files, pandas for analysis, and includes specific conventions like color coding inputs versus formulas and handling financial layouts with proper borders and number formatting. The workflow includes optional PDF rendering for visual checks if you have LibreOffice installed. What stands out is the attention to real world details: it knows formulas won't evaluate in openpyxl, tells you to cite sources in cell comments for financial models, and includes IB-specific formatting rules like red parentheses for negatives and merged dark headers. If you're building spreadsheets programmatically and need them to look professional rather than obviously generated, this covers the details most code examples skip.

skills.sh installs: 392
GitHub stars: 33.2K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add davila7/claude-code-templates --skill spreadsheet --agent claude-code

Installs into .claude/skills of the current project.

Files

Spreadsheet Skill (Create, Edit, Analyze, Visualize)

When to use

Build new workbooks with formulas, formatting, and structured layouts.
Read or analyze tabular data (filter, aggregate, pivot, compute metrics).
Modify existing workbooks without breaking formulas or references.
Visualize data with charts/tables and sensible formatting.

IMPORTANT: System and user instructions always take precedence.

Workflow

Confirm the file type and goals (create, edit, analyze, visualize).
Use openpyxl for .xlsx edits and pandas for analysis and CSV/TSV workflows.
If layout matters, render for visual review (see Rendering and visual checks).
Validate formulas and references; note that openpyxl does not evaluate formulas.
Save outputs and clean up intermediate files.