Agent skill · data analytics · davila7
spreadsheet
Use when tasks involve creating, editing, analyzing, or formatting spreadsheets (`.xlsx`, `.csv`, `.tsv`) using Python (`openpyxl`, `pandas`), especially when formulas, references, and formatting need to be preserved and verified.
Why this skill is useful
Provides specific commands and workflows for manipulating spreadsheets with Python libraries that the AI wouldn't reliably generate on its own.
What it needs
Requires libreoffice, matplotlib, openpyxl, pandas, poppler installed locally. About 3k tokens when loaded. Last updated 2026-08-06. 30,138 stars on the source repository.
What this skill does
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 1. Confirm the file type and goals (create, edit, analyze, visualize). 2. Use openpyxl for .xlsx edits and pandas for analysis and CSV/TSV workflows. 3. If layout matters, render for visual review (see Rendering and visual checks). 4. Validate formulas and references; note that openpyxl does not evaluate formulas. 5. Save outputs and clean up intermediate files. Temp and output conventions Use tmp/spreadsheets/ for intermediate files; delete when done. Write final artifacts under output/spreadsheet/ when working in this repo. Keep filenames stable and descriptive. Primary tooling Use openpyxl for creating/editing .xlsx files and preserving formatting. Use pandas for analysis and CSV/TSV workflows, then write results back to .xlsx or .csv. If you need charts, prefer openpyxl.chart for native Excel charts. Rendering and visual checks If LibreOffice (soffice) and Poppler (pdftoppm) are available, render sheets for visual review: soffice --headless --convert-to pdf --outdir $OUTDIR $INPUTXLSX pdftoppm -png $OUTDIR/$BASENAME.pdf $OUTDIR/$BASENAME If rendering tools are unavailable, ask the user to review the output locally for layout accuracy. Dependencies (install if missing) Prefer uv for dependency management. Python packages: If uv is unavailable: Optional (chart-heavy or PDF review workflows): If uv is unavailable: System tools (for rendering): If installation isn't possible in this environment, tell the user which dependency is missing and how to install it locally. Environment No required environment variables. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills davila7/spreadsheet