spreadsheet-audit-edit-validate
Spreadsheet Audit Edit Validate
Use this workflow whenever you need to modify or generate an Excel workbook and the task depends on matching an expected workbook structure. The goal is to avoid editing the wrong file, writing into the wrong sheet, or delivering a workbook that does not satisfy the user's required tabs, columns, or counts. Use this workflow whenever you need to create or modify an Excel workbook and the task depends on matching an expected workbook structure. The goal is to avoid editing the wrong file, writing into the wrong sheet, or delivering a workbook that does not satisfy the user's required tabs, columns, or counts.
Important: This workflow has two distinct modes depending on the task type:
| Task Type | Pre-edit Audit | Post-write Validation |
|---|---|---|
| Modify existing workbook | Full audit required (Phases 1-2) | Full validation required (Phase 4) |
| Create new workbook from source/reference data | Skip pre-edit audit (no existing file to audit) | Full validation required (Phase 4) |
This is a workflow skill, not a tool-specific recipe. Apply it with any spreadsheet-capable tooling.
When to use
Use this workflow when: