seb1n/awesome-ai-agent-skills / documents-and-files/spreadsheet-analysis
spreadsheet-analysis
VerifiedInspect, profile, clean, reconcile, analyze, visualize, and verify spreadsheet data while preserving formulas, formatting, types, and source files. Use when working with .xlsx, .xlsm, .xls, .ods, .csv, or .tsv files; answering questions from a workbook; auditing formulas or data quality; comparing sheets or versions; producing pivots, charts, forecasts, or summary workbooks; repairing malformed tables; or validating that spreadsheet edits and calculations are accurate.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 9.8 KB |
| agents/openai.yaml | config | 219 B |
| assets/analysis-report-template.md | markdown | 1.7 KB |
| references/analysis-checklist.md | markdown | 2.5 KB |
| references/tool-routing.md | markdown | 2.5 KB |
| scripts/profile_table.pyexecutable | script | 33.9 KB |
references/tool-routing.md
View on GitHub# Spreadsheet tool routing
Inventory the environment first. Choose the smallest toolchain that preserves the required workbook features.
| Need | Preferred capability | Examples when already available | Key limitation to verify |
|---|---|---|---|
| Visual edit/recalculation | Native spreadsheet application | Excel, LibreOffice Calc, Numbers | Cross-engine formula and layout differences |
| XLSX formulas/styles | Workbook-aware library | openpyxl, ExcelJS, SheetJS | Usually does not calculate formulas or fully preserve every feature |
| XLS/XLSB legacy formats | Format-specific reader or office conversion | xlrd-compatible tooling, pyxlsb, office suite | Conversion can lose macros, names, formatting, charts |
| ODS | ODF-aware library/application | LibreOffice, odfpy | Formula syntax and style differences |
| Large tabular analysis | Dataframe or query engine | pandas, Polars, DuckDB | Workbook semantics and formatting are lost |
| CSV/TSV inspection | Standard parser with explicit dialect/encoding | Python `csv`, DuckDB | No formulas, multiple sheets, types, or formatting metadata |
| Formula recalculation | Compatible calculation engine | Excel or LibreOffice | Engine/version may change results or unsupported functions |
| Rendering | Application export or headless office suite | Excel/LibreOffice PDF or image export | Print areas and fonts affect output |
## Rules
1. Do not infer a dependency exists from a file extension; check it.
2. Use a native or compatible application when macros, pivots, slicers, charts, external links, protection, or exact layout must survive.
3. Use `data_only=False`-style reads to inspect formulas and a separate read for cached values when supported.
4. Treat formula calculation and workbook serialization as separate capabilities.
5. Do not convert XLSM to XLSX if macros must be preserved. Never enable or run macros for inspection.
6. Before recalculating an untrusted workbook, use a low-privilege isolated environment with no secrets or network access and explicitly disable macros/VBA, workbook events, DDE, add-ins, automatic links, data connections, queries, and external-content refresh.
7. Treat cached or recalculated results that depend on disabled macros, events, add-ins, links, or connections as unverified; record the dependency rather than enabling it.
8. Use database/query engines only after defining table grain, types, nulls, and workbook-specific exclusions.
9. If the required isolation or a suitable engine does not exist, report the gap and stop before changing or recalculating the source.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |