Spreadsheet Skill
Metadata
- Trigger when: the task involves real spreadsheet creation, editing, analysis, formatting, or visual validation.
- Do not use when: a trivial one-line CSV inspection is enough and workbook integrity does not matter.
Skill Purpose
Stay as the stable entrypoint for spreadsheet work, then route into the narrowest correct lane: workbook-preserving .xlsx editing or tabular data analysis.
Instructions
- Classify the spreadsheet job first. If the task is
.xlsxcreation/editing with formulas or formatting preservation, prefer$spreadsheet-xlsx-edit. If the task is CSV/TSV or spreadsheet-backed analysis, aggregation, or reshaping, prefer$spreadsheet-tabular-analysis. Read the runnable examples under~/.codex/skills/spreadsheet/references/examples/openpyxlonly when you need a concrete pattern. - If a child lane is unavailable in the current run, continue here with the same split: use
openpyxlfor.xlsxstructure-preserving work andpandasfor tabular analysis workflows. Keep filenames stable and outputs under a sensible path such asoutput/spreadsheet/. - Validate the result. Check formulas, references, number/date formats, source citations when relevant, and render for visual review when layout matters and
sofficepluspdftoppmare available.
Non-Negotiable Acceptance Criteria
- Existing workbook formatting is preserved unless the user asked for redesign.
- Derived values stay as formulas when formulas are the right source of truth.
- Formatting and citation rules are explicit when the spreadsheet is financial or source-sensitive.
- If rendering dependencies are missing, the skill says so instead of pretending the layout was verified.
Output
- The final spreadsheet path or paths.
- Any render artifact path used for visual validation.
- A short note on formula handling, dependency installs, or validation caveats.
Next skill options(only if needed):$spreadsheet-xlsx-edit— create or edit.xlsxfiles while preserving formulas and formatting;$spreadsheet-tabular-analysis— analyze and reshape spreadsheet/CSV/TSV data with stable outputs.