Skills working-with-spreadsheets
📦

working-with-spreadsheets

Content revision r2 Safe ⚙️ External commands

Build Reliable Excel Workbooks

Formula-heavy spreadsheets can become inconsistent, difficult to review, and prone to calculation errors. This skill provides practical patterns for formulas, formatting, editing, and verification.

Supports: Claude Codex Code(CC)
📊 75 Adequate

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request
Review the Skillstore skill "working-with-spreadsheets" from https://skillstore.io/skills/asmayaseen-working-with-spreadsheets.md and its manifest at https://skillstore.io/api/skills/asmayaseen-working-with-spreadsheets/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

Your Agent should still show its plan and request any confirmation required by the security policy.

Agent-readable resources

Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.

Markdown detail GET /skills/asmayaseen-working-with-spreadsheets.md Signed manifest GET /api/skills/asmayaseen-working-with-spreadsheets/manifest Signed lockfile GET /api/skills/asmayaseen-working-with-spreadsheets/lockfile

Test it

Using "working-with-spreadsheets". Create a revenue model with editable assumptions and calculated growth.

Expected outcome:

A workbook with blue assumption cells, black formula cells, currency formats, percentage formats, and a formula-based revenue projection.

Using "working-with-spreadsheets". Review an existing workbook for common formula problems.

Expected outcome:

  • No invalid cross-sheet references found.
  • Two division formulas need denominator checks.
  • One input cell uses formula styling and should use input styling.

Using "working-with-spreadsheets". Add an analysis worksheet without replacing source data.

Expected outcome:

A modified workbook with a separate analysis sheet, preserved source formulas, and validated worksheet references.

Security Audit

Safe
v9 • 7/23/2026 Open versioned report

All 30 static findings are false positives caused by Markdown code fences, inline examples, fixed local commands, or harmless validation messages. The reviewed files show no system reconnaissance, command injection, prompt injection, network access, credential access, or malicious intent.

2
Files scanned
254
Lines analyzed
0
Review items
0
False positives ignored

Risk Factors

⚙️ External commands (28)
SKILL.md:13-22 SKILL.md:22-28 SKILL.md:28-35 SKILL.md:35-47 SKILL.md:47-60 SKILL.md:60-64 SKILL.md:64-79 SKILL.md:79-85 SKILL.md:85-86 SKILL.md:86-87 SKILL.md:87-88 SKILL.md:88-92 SKILL.md:92-107 SKILL.md:107-111 SKILL.md:111-138 SKILL.md:138-142 SKILL.md:142-158 SKILL.md:158-164 SKILL.md:164-167 SKILL.md:167-170 SKILL.md:170-179 SKILL.md:179-189 SKILL.md:189-193 SKILL.md:193-196 SKILL.md:196-204 SKILL.md:204-210 SKILL.md:210-214 SKILL.md:214-215
No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.
Audited by: codex View Audit History →
Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report
Security Assessment

Copy report link

https://skillstore.io/skills/asmayaseen-working-with-spreadsheets/audits/9?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/asmayaseen-working-with-spreadsheets/security.svg)](https://skillstore.io/skills/asmayaseen-working-with-spreadsheets?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/asmayaseen-working-with-spreadsheets?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/asmayaseen-working-with-spreadsheets/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/asmayaseen-working-with-spreadsheets.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>
Academic citations (APA · BibTeX · CFF)

APA citation

Asmayaseen. (2026). working-with-spreadsheets security audit report (audit version 9) [Author version unspecified]. Skillstore. https://skillstore.io/skills/asmayaseen-working-with-spreadsheets/audits/9

BibTeX citation

@techreport{asmayaseen-asmayaseen-working-with-spreadsheets-2026, author = {Asmayaseen}, title = {working-with-spreadsheets security audit report (audit version 9)}, institution = {Skillstore}, year = {2026}, number = {9}, url = {https://skillstore.io/skills/asmayaseen-working-with-spreadsheets/audits/9}, note = {Author version unspecified} }

CITATION.cff

cff-version: 1.2.0 message: "If you use this Skill, cite its author and this versioned security audit report." title: "working-with-spreadsheets security audit report (audit version 9)" version: "unspecified" type: report authors: - name: "Asmayaseen" date-released: "2026-07-23" url: "https://skillstore.io/skills/asmayaseen-working-with-spreadsheets/audits/9" identifiers: - type: other value: "skillstore:asmayaseen-working-with-spreadsheets:audit:9" description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: High
45
Architecture
85
Maintainability
87
Content
70
Community
83
Spec Compliance

What You Can Build

Prepare a Financial Model

Create a formula-driven workbook with consistent input colors, calculation styles, and financial number formats.

Automate Workbook Updates

Modify existing sheets, add analysis tabs, preserve formulas, and save a separate output file.

Review Spreadsheet Quality

Check references, formula errors, missing values, and formatting before sharing a workbook.

Try These Prompts

Create a Simple Workbook 
Create an Excel workbook with monthly revenue, a total formula, currency formatting, and clearly styled input cells.
Format a Financial Model 
Apply the documented financial color and number standards to my workbook while preserving all existing formulas.
Edit and Validate a Workbook 
Add an analysis sheet, create cross-sheet formulas, and report any invalid references or division errors.
Design a Scalable Spreadsheet Workflow 
Plan a large-workbook pipeline using pandas and openpyxl, including formula preservation, recalculation, validation, and memory controls.

Best Practices

  • Use Excel formulas for calculated cells so workbook logic remains visible and editable.
  • Save edited workbooks to a new file until the result has been reviewed.
  • Recalculate formulas with a compatible engine and verify common Excel errors before delivery.

Avoid

  • Do not replace formulas with Python-calculated values when users need an auditable model.
  • Do not load formula workbooks with data-only mode and then save them.
  • Do not assume column positions, row offsets, or cross-sheet references without checking samples.

Frequently Asked Questions

Which spreadsheet formats does this skill cover?
The examples focus on Excel .xlsx workbooks handled with pandas and openpyxl.
Can openpyxl calculate Excel formulas?
No. Openpyxl writes and preserves formulas, but a compatible spreadsheet engine must calculate their values.
When should I use pandas?
Use pandas for tabular analysis, transformations, and reading multiple sheets into DataFrames.
When should I use openpyxl?
Use openpyxl for formulas, cell styles, worksheet structure, and workbook-level editing.
Can the skill verify formula results automatically?
It provides a verification checklist, but the referenced recalculation script is not included in the reviewed files.
Does the skill preserve my original workbook?
The examples can save a separate output file, but you must choose filenames that avoid overwriting the source.

Developer Details

Author

Asmayaseen

License

MIT

Skillstore revision

r2

Version notice

The author did not declare a version.

Repository

https://github.com/Asmayaseen/hackathon-2/tree/main/.claude/skills/working-with-spreadsheets

Ref

89edfdc710d0846129dcee6a929477b04f08052c

Maintenance freshness

7/24/2026

Usage

9 downloads · 201 views

File structure

📁 scripts/

📄 verify.py

📄 SKILL.md