spreadsheet

--- name: "spreadsheet" description: "Use when tasks involve creating, editing, analyzing, or formatting spreadsheets (`.xlsx`, `.csv`, `.tsv`) with formula-aware workflows, cached recalculation, and visual review." --- # 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 1. Confirm the file type and goal: create, edit, analyze, or visualize. 2. Prefer `openpyxl` for `.xlsx` editing and formatting. Use `pandas` for analysis and CSV/TSV workflows. 3. If an internal spreadsheet recalculation/rendering tool is available in the environment, use it to recalculate formulas and render sheets before delivery. 4. Use formulas for derived values instead of hardcoding results. 5. If layout matters, render for visual review and inspect the output. 6. Save outputs, keep filenames stable, and clean up intermediate files. ## Temp and output conventions - Use `tmp/spreadsheets/` for intermediate files; delete them 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`. - Use `openpyxl.chart` for native Excel charts when needed. - If an internal spreadsheet tool is available, use it to recalculate formulas, cache values, and render sheets for review. ## Recalculation and visual review - Recalculate formulas before delivery whenever possible so cached values are present [... prompt truncated for preview ...]