spreadsheet

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.