Excel workbooks
Select both an operation and a business scenario before authoring. Choosing
CREATE or EDIT does not finish scenario selection. User requirements and an
existing template or house style take precedence over these defaults.
Set SKILL_DIR to the absolute directory containing this file. Read only the
common guidance, applicable scenario, and operation needed for the task.
Layer 1 — Common workbook rules
- Preserve the source. Read-only analysis must not save, restyle, or recalculate
the original. Perform edits and application checks on separate copies.
- Use live Excel formulas for derived workbook outputs; keep source records and
adjustable inputs identifiable. Do not replace formulas with cached answers.
- Preserve unrelated sheets, formulas, styles, controls, and package features.
A narrow edit is not permission to rebuild or redesign the workbook.
- For new workbooks or requested formatting, read
common presentation. For narrow edits, apply it only
to changed cells without overriding the supplied layout.
- For imports, new editable inputs or authorized input changes, read
source data and input contracts before
populating cells. Keep data types, source assumptions and current narrative coherent.
- For new reader-facing analytical reports/dashboards or authorized chart changes,
read analytical charts during planning. Choose charts for
the question, not a fixed count; preserve data-only and narrow-edit scope.
Layer 2 — Business scenario
| Requested work product |
Read before planning the workbook |
| Financial model, revenue/cost budget, forecast, valuation, financial statements, scenario/sensitivity analysis, or financial management report |
Finance, even if the request never says "finance" |
| Operational tracker, inventory, roster, ordinary data table, or other non-financial spreadsheet |
Common presentation only; do not impose financial colors or extra model tabs |
| One-cell update, formula repair, or template filling in an existing financial file |
Preserve the existing structure and house style; use only the finance rules relevant to the requested change |
| Read-only extraction or analysis |
Read and analyze; do not redesign the source |
For mixed workbooks, apply the finance layer to the financial model/report
areas, not every unrelated table. Finance guidance is bundled here: do not stop
at a generic spreadsheet route or require an external skill search to find it.
Examples:
- "Build next quarter's revenue, costs and hiring scenarios" → finance + CREATE.
- "Make a stock-count tracker" → common presentation + CREATE, not finance.
- "Change the tax-rate input in this workbook" → EDIT; keep its other tabs and
layout, rather than adding an executive-summary sheet.
Layer 3 — Operation and implementation
| Operation |
Read |
Tools |
| Create a new XLSX |
Create |
Prefer a suitable high-level library; raw OOXML remains available |
| Edit, fill a template, or repair formulas |
Edit |
Unpack → targeted XML changes → pack |
| Read or analyze XLSX/XLSM/CSV/TSV |
Read and analyze |
xlsx_reader.py, then analysis tools as needed |
| Apply or change formatting |
Common presentation and Edit for existing files |
Append/reuse styles; change only intended cells |
| Check a created or edited workbook |
Validate |
Static checks, application checks, and task/scenario review |
For new financial work using openpyxl, read high-level primitives
when choosing construction helpers. Check the calculation environment before
substantial formula authoring, then build, view and revise inside the same attempt.
Read OOXML details only when directly changing
package relationships, cell types, strings, or style definitions. Style indices
are workbook-local; never copy an index from an example into an unrelated file.
Package organization
references/common/ owns reusable data and presentation rules; domains/ owns
applicable business conventions; operations/ owns the requested workflow;
implementation/ owns library/package details. The links above are direct entry
points; load only applicable files. Keep scripts/, templates/ and dependency
paths unchanged when following these guides.
Finish
Use the selected scenario's requirements while building, not as optional
polish after the workbook is complete. Run the applicable checks in VALIDATE
and fix discovered defects. A formula scanner's exit code is not a certificate
of financial accuracy, presentation quality, or usability. State unavailable
checks honestly and deliver only the files the user requested.
1---2name: xlsx3description: Create, read, edit, format, and validate Excel spreadsheets. Use for XLSX files, spreadsheet formulas, tables, and financial models, budgets, forecasts, scenarios, or management reports delivered in Excel. Select both the file operation and the business scenario; financial workbooks also load the finance reference. Read CSV/TSV data without changing the source.4license: MIT5metadata:6 source: https://skillmd.com/skills/vm0-ai/xlsx7---89# Excel workbooks1011Select **both an operation and a business scenario** before authoring. Choosing12CREATE or EDIT does not finish scenario selection. User requirements and an13existing template or house style take precedence over these defaults.1415Set `SKILL_DIR` to the absolute directory containing this file. Read only the16common guidance, applicable scenario, and operation needed for the task.1718## Layer 1 — Common workbook rules1920- Preserve the source. Read-only analysis must not save, restyle, or recalculate21 the original. Perform edits and application checks on separate copies.22- Use live Excel formulas for derived workbook outputs; keep source records and23 adjustable inputs identifiable. Do not replace formulas with cached answers.24- Preserve unrelated sheets, formulas, styles, controls, and package features.25 A narrow edit is not permission to rebuild or redesign the workbook.26- For new workbooks or requested formatting, read27 [common presentation](references/common/presentation.md). For narrow edits, apply it only28 to changed cells without overriding the supplied layout.29- For imports, new editable inputs or authorized input changes, read30 [source data and input contracts](references/common/data-and-inputs.md) before31 populating cells. Keep data types, source assumptions and current narrative coherent.32- For new reader-facing analytical reports/dashboards or authorized chart changes,33 read [analytical charts](references/common/charts.md) during planning. Choose charts for34 the question, not a fixed count; preserve data-only and narrow-edit scope.3536## Layer 2 — Business scenario3738| Requested work product | Read before planning the workbook |39| --- | --- |40| Financial model, revenue/cost budget, forecast, valuation, financial statements, scenario/sensitivity analysis, or financial management report | [Finance](references/domains/finance.md), even if the request never says "finance" |41| Operational tracker, inventory, roster, ordinary data table, or other non-financial spreadsheet | Common presentation only; do not impose financial colors or extra model tabs |42| One-cell update, formula repair, or template filling in an existing financial file | Preserve the existing structure and house style; use only the finance rules relevant to the requested change |43| Read-only extraction or analysis | [Read and analyze](references/operations/read-analyze.md); do not redesign the source |4445For mixed workbooks, apply the finance layer to the financial model/report46areas, not every unrelated table. Finance guidance is bundled here: do not stop47at a generic spreadsheet route or require an external skill search to find it.4849Examples:50- "Build next quarter's revenue, costs and hiring scenarios" → finance + CREATE.51- "Make a stock-count tracker" → common presentation + CREATE, not finance.52- "Change the tax-rate input in this workbook" → EDIT; keep its other tabs and53 layout, rather than adding an executive-summary sheet.5455## Layer 3 — Operation and implementation5657| Operation | Read | Tools |58| --- | --- | --- |59| Create a new XLSX | [Create](references/operations/create.md) | Prefer a suitable high-level library; raw OOXML remains available |60| Edit, fill a template, or repair formulas | [Edit](references/operations/edit.md) | Unpack → targeted XML changes → pack |61| Read or analyze XLSX/XLSM/CSV/TSV | [Read and analyze](references/operations/read-analyze.md) | `xlsx_reader.py`, then analysis tools as needed |62| Apply or change formatting | [Common presentation](references/common/presentation.md) and [Edit](references/operations/edit.md) for existing files | Append/reuse styles; change only intended cells |63| Check a created or edited workbook | [Validate](references/operations/validate.md) | Static checks, application checks, and task/scenario review |6465For new financial work using openpyxl, read [high-level primitives](references/implementation/authoring.md)66when choosing construction helpers. Check the calculation environment before67substantial formula authoring, then build, view and revise inside the same attempt.68Read [OOXML details](references/implementation/ooxml.md) only when directly changing69package relationships, cell types, strings, or style definitions. Style indices70are workbook-local; never copy an index from an example into an unrelated file.7172## Package organization7374`references/common/` owns reusable data and presentation rules; `domains/` owns75applicable business conventions; `operations/` owns the requested workflow;76`implementation/` owns library/package details. The links above are direct entry77points; load only applicable files. Keep `scripts/`, `templates/` and dependency78paths unchanged when following these guides.7980## Finish8182Use the selected scenario's requirements while building, not as optional83polish after the workbook is complete. Run the applicable checks in VALIDATE84and fix discovered defects. A formula scanner's exit code is not a certificate85of financial accuracy, presentation quality, or usability. State unavailable86checks honestly and deliver only the files the user requested.