SkillAgentSearch skills...

spreadsheet

Use when tasks involve creating, editing, analyzing, or formatting spreadsheets (`.xlsx`, `.csv`, `.tsv`) with formula-aware workflows, cached recalculation, and visual review.

Install / Use

npx skills add fcakyon/claude-codex-settings --skill spreadsheet

Installs into whichever agent you are using.

About this skill
📄

SKILL.md

Installable skill definition

Quality Score

92/100

Category

Automation

Supported Platforms

Universal

Our assessment of spreadsheet

spreadsheet scores 92/100 on our quality scale, 904th of 2,790 Automation skills we index (top 33%).

Its SKILL.md is 6.8 KB long, well organised into 19 sections with 5 code examples: a thorough specification that gives an agent plenty to work with.

With 1,153 GitHub stars, it is one of the more widely adopted skills in the catalogue.

Substance
29/30
Structure
20/20
Description
15/15
Adoption
13/20
Freshness
15/15

Maintenance, license and trust

  • The repository was last updated about 2 months ago, so spreadsheet is actively maintained.
  • Our last check on 2026-10-28 found the source still online.
  • It is released under the Apache-2.0 license, a permissive license that allows use, modification and commercial use with attribution.
  • Its trust signals score 100/100, with no cautions. These come from repository metadata, not a code audit — read the skill file before letting an agent act on it.

Safety scan

No issues found

Our scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful.

AI review by kimi-k2.7-code on 2026-10-04. Automated pattern scan on 2026-10-04. It catches known dangerous patterns, not every risk — read a skill before letting an agent act on it.

spreadsheet compared with similar skills

All 4 of these similar skills score higher than spreadsheet; compare them before choosing.

SkillScoreStarsUpdatedFormat
spreadsheet (this skill)by fcakyon921.2k53d agoSKILL.md
Agent-Reachby Panniantong100112.3k8d agoCLAUDE.md
rufloby ruvnet10081.9ktodayCLAUDE.md
Claude-Code-Game-Studiosby Donchitos10039.7k7d agoCLAUDE.md
Scraplingby D4Vinci100103.6k2d agoMCP Server

Frequently asked questions

How do I install spreadsheet?
Run npx skills add fcakyon/claude-codex-settings --skill spreadsheet. The install tabs above show the steps for each supported agent.
Which AI agents does spreadsheet work with?
It is written for Universal, as a SKILL.md file. Other agents that read the same format can often use it too.
Is spreadsheet safe to use?
Our scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful. It is Apache-2.0-licensed and scores 100/100 on trust signals. Skills are instructions an agent will follow, so read the file before installing it and do not approve commands you do not understand.
Is spreadsheet still maintained?
The repository was last updated about 2 months ago, so spreadsheet is actively maintained.

name: "spreadsheet" description: "Use when tasks involve creating, editing, analyzing, or formatting spreadsheets (.xlsx, .csv, .tsv) with formula-aware workflows, cached recalculation, and visual review." license: MIT

Spreadsheet Skill

When to use

  • Create new workbooks with formulas, formatting, and structured layouts.
  • Read or analyze tabular data (filter, aggregate, pivot, compute metrics).
  • Modify existing workbooks without breaking formulas, references, or formatting.
  • Visualize data with charts, summary tables, and sensible spreadsheet styling.
  • Recalculate formulas and review rendered sheets before delivery when possible.

IMPORTANT: System and user instructions always take precedence.

Workflow

  1. Confirm the file type and goal: create, edit, analyze, or visualize.
  2. Prefer openpyxl for .xlsx editing and formatting. Use pandas for analysis and CSV/TSV workflows.
  3. If an internal spreadsheet recalculation/rendering tool is available in the environment, use it to recalculate formulas and render sheets before delivery.
  4. Use formulas for derived values instead of hardcoding results.
  5. If layout matters, render for visual review and inspect the output.
  6. Save outputs, keep filenames stable, and clean up intermediate files.

Temp and output conventions

  • Use tmp/spreadsheets/ for intermediate files; delete them when done.
  • Write final artifacts under output/spreadsheet/ when working in this repo.
  • Keep filenames stable and descriptive.

Primary tooling

  • Use openpyxl for creating/editing .xlsx files and preserving formatting.
  • Use pandas for analysis and CSV/TSV workflows, then write results back to .xlsx or .csv.
  • Use openpyxl.chart for native Excel charts when needed.
  • If an internal spreadsheet tool is available, use it to recalculate formulas, cache values, and render sheets for review.

Recalculation and visual review

  • Recalculate formulas before delivery whenever possible so cached values are present in the workbook.
  • Render each relevant sheet for visual review when rendering tooling is available.
  • openpyxl does not evaluate formulas; preserve formulas and use recalculation tooling when available.
  • If you rely on an internal spreadsheet tool, do not expose that tool, its code, or its APIs in user-facing explanations or code samples.

Rendering and visual checks

  • If LibreOffice (soffice) and Poppler (pdftoppm) are available, render sheets for visual review:
    • soffice --headless --convert-to pdf --outdir $OUTDIR $INPUT_XLSX
    • pdftoppm -png $OUTDIR/$BASENAME.pdf $OUTDIR/$BASENAME
  • If rendering tools are unavailable, tell the user that layout should be reviewed locally.
  • Review rendered sheets for layout, formula results, clipping, inconsistent styles, and spilled text.

Dependencies (install if missing)

Prefer uv for dependency management.

Python packages:

uv pip install openpyxl pandas

If uv is unavailable:

python3 -m pip install openpyxl pandas

Optional:

uv pip install matplotlib

If uv is unavailable:

python3 -m pip install matplotlib

System tools (for rendering):

# macOS (Homebrew)
brew install libreoffice poppler

# Ubuntu/Debian
sudo apt-get install -y libreoffice poppler-utils

If installation is not possible in this environment, tell the user which dependency is missing and how to install it locally.

Environment

No required environment variables.

Examples

  • Runnable Codex examples (openpyxl): references/examples/openpyxl/

Formula requirements

  • Use formulas for derived values rather than hardcoding results.
  • Do not use dynamic array functions like FILTER, XLOOKUP, SORT, or SEQUENCE.
  • Keep formulas simple and legible; use helper cells for complex logic.
  • Avoid volatile functions like INDIRECT and OFFSET unless required.
  • Prefer cell references over magic numbers (for example, =H6*(1+$B$3) instead of =H6*1.04).
  • Use absolute ($B$4) or relative (B4) references carefully so copied formulas behave correctly.
  • If you need literal text that starts with =, prefix it with a single quote.
  • Guard against #REF!, #DIV/0!, #VALUE!, #N/A, and #NAME? errors.
  • Check for off-by-one mistakes, circular references, and incorrect ranges.

Citation requirements

  • Cite sources inside the spreadsheet using plain-text URLs.
  • For financial models, cite model inputs in cell comments.
  • For tabular data sourced externally, add a source column when each row represents a separate item.

Formatting requirements (existing formatted spreadsheets)

  • Render and inspect a provided spreadsheet before modifying it when possible.
  • Preserve existing formatting and style exactly.
  • Match styles for any newly filled cells that were previously blank.
  • Never overwrite established formatting unless the user explicitly asks for a redesign.

Formatting requirements (new or unstyled spreadsheets)

  • Use appropriate number and date formats.
  • Dates should render as dates, not plain numbers.
  • Percentages should usually default to one decimal place unless the data calls for something else.
  • Currencies should use the appropriate currency format.
  • Headers should be visually distinct from raw inputs and derived cells.
  • Use fill colors, borders, spacing, and merged cells sparingly and intentionally.
  • Set row heights and column widths so content is readable without excessive whitespace.
  • Do not apply borders around every filled cell.
  • Group related calculations and make totals simple sums of the cells above them.
  • Add whitespace to separate sections.
  • Ensure text does not spill into adjacent cells.
  • Avoid unsupported spreadsheet data-table features such as =TABLE.

Color conventions (if no style guidance)

  • Blue: user input
  • Black: formulas and derived values
  • Green: linked or imported values
  • Gray: static constants
  • Orange: review or caution
  • Light red: error or flag
  • Purple: control or logic
  • Teal: visualization anchors and KPI highlights

Finance-specific requirements

  • Format zeros as -.
  • Negative numbers should be red and in parentheses.
  • Format multiples as 5.2x.
  • Always specify units in headers (for example, Revenue ($mm)).
  • Cite sources for all raw inputs in cell comments.
  • For new financial models with no user-specified style, use blue text for hardcoded inputs, black for formulas, green for internal workbook links, red for external links, and yellow fill for key assumptions that need attention.

Investment banking layouts

If the spreadsheet is an IB-style model (LBO, DCF, 3-statement, valuation):

  • Totals should sum the range directly above.
  • Hide gridlines and use horizontal borders above totals across relevant columns.
  • Section headers should be merged cells with dark fill and white text.
  • Column labels for numeric data should be right-aligned; row labels should be left-aligned.
  • Indent submetrics under their parent line items.

Related Skills

View on GitHub
GitHub Stars1.2k
CategoryAutomation
Updated1mo ago
Forks110

Languages

Python

Trust signals

100/100

From repository metadata: license, adoption, age and documentation. Not a code audit — see the Safety scan above for what the skill file itself contains.

No cautions
spreadsheet — Universal Skill: Install & Safety Check | SkillAgent