New: 97,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Official agent skill

Spreadsheet

by JetBrains in JetBrains/skills

A skill your agent uses when tasks involve creating, editing, analyzing, or formatting spreadsheets (.xlsx, .csv, .tsv) with formula-aware workflows, cached recalculation, and visual review.

OfficialApache-2.0Auto-check: notesDocuments & Office

Install Spreadsheet

skills CLI
$ npx skills add JetBrains/skills --skill spreadsheet -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install JetBrains/skills spreadsheet --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/JetBrains/skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/spreadsheet .claude/skills/spreadsheet && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
spreadsheet
GitHub stars
363
Used in
2 other repos
Token cost
~1.8k tokens
SKILL.md length
877 words
Files
9 (incl. references, assets)
Skills in repo
79
Repo updated
First seen
Licence
Apache-2.0

At a glance

A skill your agent uses when tasks involve creating, editing, analyzing, or formatting spreadsheets (.xlsx, .csv, .tsv) with formula-aware workflows, cached recalculation, and visual review.

  • Works in 6 steps: Confirm the file type and goal: create,… → Prefer openpyxl for .xlsx editing and… → If an internal spreadsheet… → …
  • Tasks involve creating
  • SKILL.md covers When to use, Workflow, Temp and output conventions and Primary tooling, plus 12 more sections
  • Runs Python scripts from its folder; calls uv, python3 and brew

What it does

Spreadsheet is an agent skill from JetBrains/skills, published by the product's own GitHub organization. Use when tasks involve creating, editing, analyzing, or formatting spreadsheets (.xlsx, .csv, .tsv) with formula-aware workflows, cached recalculation, and visual review.

Its SKILL.md is about 1.8k tokens, which your agent loads only when the skill is triggered. The skill folder holds 13 other files, including reference files and assets (for example `agents/openai.yaml`, `references/examples/openpyxl/create_basic_spreadsheet.py` and `references/examples/openpyxl/create_spreadsheet_with_styling.py`).

It sits in Documents & Office, covering Excel spreadsheets and CSV and tabular files. It works with Microsoft Excel and openpyxl. The repository describes itself as: Curated agent skills collection verified by JetBrains. The licence is Apache-2.0.

When your agent uses it

  • Tasks involve creating
  • Formatting spreadsheets (.xlsx
  • .tsv) with formula-aware workflows
  • Cached recalculation

Example prompts

  • “/spreadsheet”

Requirements

  • Python 3

Workflow steps

6 steps, taken from the first numbered list in SKILL.md.

  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…
  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.

What it can do on your machine

Read from SKILL.md and the folder at commit e0f258b. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Ships script files (Python), which the agent can run.

    Shell commands in SKILL.md call:

    • uv
    • python3
    • brew
    • apt-get
    • soffice
    • pdftoppm

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md. Its commands use uv, which can reach the network depending on how they are called.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Spreadsheet loads about 1.8k tokens when it runs, and up to ~3.9k if it reads all its reference files. Until then it costs about 47 tokens; SKILL.md has 877 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~47
When it runs · the whole SKILL.md, loaded when a task matches
~1.8k
With references · SKILL.md plus every file in references/, read only if the agent opens them
~3.9k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check: notes

The automated check noted patterns worth knowing about, such as sudo or a known installer.

  • NoteRuns commands with sudoSKILL.md:79
    sudo apt-get install -y libreoffice poppler-utils

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from JetBrains/skills at commit e0f258b, republished under its Apache-2.0 licence (© JetBrains). 877 words, ~1,798 tokens.

Download SKILL.mdSave it as .claude/skills/spreadsheet/SKILL.md (or your agent's skills folder). This skill also uses 8 other files; get the full folder from GitHub.
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
Apache-2.0
metadata.short-description
Create, edit, and analyze spreadsheets
metadata.author
OpenAI
metadata.source
https://github.com/openai/skills/tree/e6afb0d74cc75d220df2faf3dd6c635c2dc6a108/skills/.curated/spreadsheet

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.
Show full SKILL.md (339 more words)Show less

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.

© JetBrains, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 8 other files (references, assets) in spreadsheet of JetBrains/skills.

  • SKILL.md
  • LICENSE.txt
  • agents/openai.yaml
  • assets/spreadsheet-small.svg
  • assets/spreadsheet.png
  • references/examples/openpyxl/create_basic_spreadsheet.py
  • references/examples/openpyxl/create_spreadsheet_with_styling.py
  • references/examples/openpyxl/read_existing_spreadsheet.py
  • references/examples/openpyxl/styling_spreadsheet.py

Open the folder on GitHubat commit e0f258b

Used in 2 other repositories

We found 2 copies of this SKILL.md (exact, near-identical or edited) in other folders, from 2 other GitHub owners. This page covers the copy in JetBrains/skills, which our catalogue first saw on October 7, 2026.

Compare with similar skills

Spreadsheet next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Spreadsheet compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Spreadsheet this skillJetBrains/skills3632 repos~1.8kAutomated safety check: NotesApache-2.0
XLSX Spreadsheet ToolkitXiaomiMiMo/MiMo-Code14k—~2.9kAutomated safety check: PassApache-2.0
Cc Streaming Export Safetydoccker/cc-use-exp1.1k—~2.2kAutomated safety check: PassCustom licence
Excel Spreadsheet Builderagentscope-ai/QwenPaw35k—~1.8kAutomated safety check: PassProprietary
TableauLeoYeAI/openclaw-master-skills2.2k—~4.8kAutomated safety check: PassMIT
Excel Spreadsheet Creation and Editinganthropics/skills180k4 repos~2.1kAutomated safety check: PassProprietary

Similar skills

  • XLSX Spreadsheet Toolkit

    XiaomiMiMo/MiMo-Code

    Builds, edits, cleans, recalculates and reads Excel workbooks and CSV files with openpyxl and pandas, plus LibreOffice for recalculation and PDF export.

    14k GitHub stars~2.9k tokensUpdated 4 days ago
    Documents & OfficeAuto-check passed

  • Cc Streaming Export Safety

    doccker/cc-use-exp

    当实现用户驱动的大文件导出或批量序列化（Excel/CSV/JSON/JSONL/PDF，数据量未知或超过 1 万行/10 MB）时触发；普通小文件下载、静态资源下载、非导出 Writer/Report 类不触发。防止 OOM、临时文件残留、同步导出阻塞 HTTP 线程和表格公式注入。

    1.1k GitHub stars~2.2k tokensUpdated 1 mo ago
    Documents & OfficeAuto-check passed

  • Excel Spreadsheet Builder

    agentscope-ai/QwenPaw

    Creates, edits, cleans and analyzes Excel and CSV files with openpyxl and pandas, recalculating formulas through LibreOffice so files are delivered without formula errors.

    35k GitHub stars~1.8k tokensUpdated 7 days ago
    Documents & OfficeAuto-check passed

  • Tableau

    LeoYeAI/openclaw-master-skills

    Expert on modern configuration converter — converts Excel/CSV/XML/YAML into Protobuf-backed JSON/Text/Bin configs via protogen + confgen pipeline.

    2.2k GitHub stars~4.8k tokensUpdated 2 mo ago
    Documents & OfficeAuto-check passed

  • Excel Spreadsheet Creation and Editing

    anthropics/skills

    Official

    Creates, edits and analyzes spreadsheets (.xlsx, .xlsm, .csv, .tsv) with openpyxl and pandas, writing live formulas and recalculating to confirm zero formula errors.

    180k GitHub starsUsed in 4 repos~2.1k tokens
    Documents & OfficeAuto-check passed

  • BiSheng XLSX Workbook Builder

    dataelement/bisheng

    Builds, edits and cleans Excel workbooks inside BiSheng's code executor using openpyxl, with LibreOffice recalculation and a pre-delivery check.

    12k GitHub stars~1.7k tokensUpdated 7 days ago
    Documents & OfficeAuto-check passed

More from JetBrains/skills

All 79 skills in this repo

  • Playwright

    JetBrains/skills

    Official

    A skill your agent uses when the task requires automating a real browser from the terminal (navigation, form filling, snapshots, screenshots, data extraction, UI-flow debugging) via playwright-cli…

    363 GitHub starsUsed in 11 repos~986 tokens
    Auto-check passed

  • Skill Creator

    JetBrains/skills

    Official

    Guide for creating effective skills. An agent skill from JetBrains/skills.

    363 GitHub starsUsed in 120 repos~4.7k tokens
    Auto-check passed

  • Speech

    JetBrains/skills

    Official

    A skill your agent uses when the user asks for text-to-speech narration or voiceover, accessibility reads, audio prompts, or batch speech generation via the OpenAI Audio API; run the bundled CLI…

    363 GitHub starsUsed in 4 repos~1.9k tokens
    Auto-check passed

  • Transcribe

    JetBrains/skills

    Official

    Transcribe audio files to text with optional diarization and known-speaker hints.

    363 GitHub starsUsed in 4 repos~776 tokens
    Auto-check passed

  • Imagegen

    JetBrains/skills

    Official

    A skill your agent uses when the user asks to generate or edit images via the OpenAI Image API (for example: generate image, edit/inpaint/mask, background removal or replacement, transparent…

    363 GitHub starsUsed in 3 repos~2.5k tokens
    Auto-check passed

  • Screenshot

    JetBrains/skills

    Official

    A skill your agent uses when the user explicitly asks for a desktop or system screenshot (full screen, specific app or window, or a pixel region), or when tool-specific capture capabilities are…

    363 GitHub starsUsed in 6 repos~2k tokens
    Auto-check passed

Works with

Categories

Questions about Spreadsheet

What does Spreadsheet do?

A skill your agent uses when tasks involve creating, editing, analyzing, or formatting spreadsheets (.xlsx, .csv, .tsv) with formula-aware workflows, cached recalculation, and visual review. Spreadsheet is an agent skill from JetBrains/skills, published by the product's own GitHub organization.tsv) with formula-aware workflows, cached recalculation, and visual review.

When should I use Spreadsheet?

Spreadsheet fits situations like: tasks involve creating; formatting spreadsheets (.xlsx; .tsv) with formula-aware workflows; cached recalculation.

How do I install Spreadsheet in Claude Code?

Run `npx skills add JetBrains/skills --skill spreadsheet -a claude-code`. Or copy the skill folder (spreadsheet in JetBrains/skills) into .claude/skills/spreadsheet in your project. Claude Code loads it when a task matches its description.

How do I install Spreadsheet in Codex?

Run `npx skills add JetBrains/skills --skill spreadsheet -a codex`. Or copy the skill folder (spreadsheet in JetBrains/skills) into .agents/skills/spreadsheet in your project. Codex loads it when a task matches its description.

Can I use Spreadsheet in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add JetBrains/skills --skill spreadsheet -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/spreadsheet, .gemini/skills/spreadsheet, .github/skills/spreadsheet and .opencode/skills/spreadsheet in your project.

What does Spreadsheet need to run?

Going by SKILL.md and its folder, Spreadsheet needs Python for the scripts in its folder and the command-line tools its instructions call (uv, python3, brew, apt-get, soffice and pdftoppm). Our summary lists: Python 3.

Does Spreadsheet access the network?

SKILL.md contains no URLs. Its commands use uv, which can reach the network depending on how they are called. This is read from the text; nothing was executed.

Is Spreadsheet safe to install?

Our automated static check of SKILL.md found notes only (runs commands with sudo), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.

What licence does Spreadsheet use?

Spreadsheet is published under the Apache-2.0 licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Spreadsheet use?

About 1.8k tokens (SKILL.md is roughly 7.2k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 2.1k tokens, read only when the agent opens those files.

What are the alternatives to Spreadsheet?

Skills that share tags, products or a category with Spreadsheet: XLSX Spreadsheet Toolkit (XiaomiMiMo/MiMo-Code, 14k stars), Cc Streaming Export Safety (doccker/cc-use-exp, 1.1k stars), Excel Spreadsheet Builder (agentscope-ai/QwenPaw, 35k stars) and Tableau (LeoYeAI/openclaw-master-skills, 2.2k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Spreadsheet?

JetBrains (a GitHub organization, an official publisher) maintains it in JetBrains/skills, which has 363 GitHub stars. The repository holds 79 skills in this directory. The repository was last updated on June 29, 2026.

Source: JetBrains/skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.