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