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.