Agent skill

XLSX Processing Openai

by lawve-ai in lawve-ai/awesome-legal-skills

Toolkit for comprehensive Spreadsheet reading, creation, editing, and analysis with visual quality control.

Apache-2.0Auto-check: notesDocuments & Office

Install XLSX Processing Openai

skills CLI
$ npx skills add lawve-ai/awesome-legal-skills --skill xlsx-processing-openai -a claude-code

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

GitHub CLI
$ gh skill install lawve-ai/awesome-legal-skills xlsx-processing-openai --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/lawve-ai/awesome-legal-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/excel-editor-openai .claude/skills/xlsx-processing-openai && 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
xlsx-processing-openai
GitHub stars
842
Token cost
~1.3k tokens
SKILL.md length
594 words
Files
7 (incl. references)
Skills in repo
154
Repo updated
First seen
Licence
Apache-2.0

At a glance

Toolkit for comprehensive Spreadsheet reading, creation, editing, and analysis with visual quality control.

  • Works in 5 steps: Confirm the file type and goals (create,… → Use openpyxl for .xlsx edits and pandas… → If layout matters, render for visual… → …
  • Work with spreadsheets (.xlsx
  • SKILL.md covers When to use, Workflow, Temp and output conventions and Primary tooling, plus 11 more sections
  • Runs Python scripts from its folder; calls uv, python3 and brew

What it does

XLSX Processing Openai is an agent skill from lawve-ai/awesome-legal-skills. Toolkit for comprehensive Spreadsheet reading, creation, editing, and analysis with visual quality control. Use to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing tabular data, (3) Modifying existing spreadsheets while preserving formulas, (4) Building financial models with proper formatting, (5) Data visualization with in-sheet charts, or any other spreadsheet tasks.

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

It sits in Documents & Office, covering Excel spreadsheets. It works with Microsoft Excel, OpenAI, openpyxl and LibreOffice. The repository describes itself as: A curated list of awesome Agent Skills for automating legal work. The licence is Apache-2.0.

When your agent uses it

  • Work with spreadsheets (.xlsx
  • Creating new spreadsheets with formulas and formatting
  • Analyzing tabular data
  • Modifying existing spreadsheets while preserving formulas

Example prompts

  • “/xlsx-processing-openai”

Requirements

  • Python 3

Workflow steps

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

  1. Confirm the file type and goals (create, edit, analyze, visualize).
  2. Use openpyxl for .xlsx edits and pandas for analysis and CSV/TSV workflows.
  3. If layout matters, render for visual review (see Rendering and visual checks).
  4. Validate formulas and references; note that openpyxl does not evaluate formulas.
  5. Save outputs and clean up intermediate files.

What it can do on your machine

Read from SKILL.md and the folder at commit 045f738. 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

XLSX Processing Openai loads about 1.3k tokens when it runs, and up to ~3.4k if it reads all its reference files. Until then it costs about 121 tokens; SKILL.md has 594 words of instructions outside code blocks.

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

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:68
    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 lawve-ai/awesome-legal-skills at commit 045f738, republished under its Apache-2.0 licence (© lawve-ai). 594 words, ~1,348 tokens.

Download SKILL.mdSave it as .claude/skills/xlsx-processing-openai/SKILL.md (or your agent's skills folder). This skill also uses 6 other files; get the full folder from GitHub.
name
xlsx-processing-openai
description
Toolkit for comprehensive Spreadsheet reading, creation, editing, and analysis with visual quality control. Use to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing tabular data, (3) Modifying existing spreadsheets while preserving formulas, (4) Building financial models with proper formatting, (5) Data visualization with in-sheet charts, or any other spreadsheet tasks.
metadata.author
OpenAI
metadata.license
Apache-2.0
metadata.version
2026.01.30

Spreadsheet Skill (Create, Edit, Analyze, Visualize)

When to use

  • Build new workbooks with formulas, formatting, and structured layouts.
  • Read or analyze tabular data (filter, aggregate, pivot, compute metrics).
  • Modify existing workbooks without breaking formulas or references.
  • Visualize data with charts/tables and sensible formatting.

IMPORTANT: System and user instructions always take precedence.

Workflow

  1. Confirm the file type and goals (create, edit, analyze, visualize).
  2. Use openpyxl for .xlsx edits and pandas for analysis and CSV/TSV workflows.
  3. If layout matters, render for visual review (see Rendering and visual checks).
  4. Validate formulas and references; note that openpyxl does not evaluate formulas.
  5. Save outputs and clean up intermediate files.

Temp and output conventions

  • Use tmp/spreadsheets/ for intermediate files; delete 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.
  • If you need charts, prefer openpyxl.chart for native Excel charts.

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, ask the user to review the output locally for layout accuracy.

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 (chart-heavy or PDF review workflows):

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 isn't 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.
  • 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 (e.g., =H6*(1+$B$3) not =H6*1.04).
  • Guard against errors (#REF!, #DIV/0!, #VALUE!, #N/A, #NAME?) with validation and checks.
  • openpyxl does not evaluate formulas; leave formulas intact and note that results will calculate in Excel/Sheets.
Show full SKILL.md (249 more words)Show less

Citation requirements

  • Cite sources inside the spreadsheet using plain text URLs.
  • For financial models, cite sources of inputs in cell comments.
  • For tabular data sourced from the web, include a Source column with URLs.

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.

Formatting requirements (new or unstyled spreadsheets)

  • Use appropriate number and date formats (dates as dates, currency with symbols, percentages with sensible precision).
  • Use a clean visual layout: headers distinct from data, consistent spacing, and readable column widths.
  • Avoid borders around every cell; use whitespace and selective borders to structure sections.
  • Ensure text does not spill into adjacent cells.

Color conventions (if no style guidance)

  • Blue: user input
  • Black: formulas/derived values
  • Green: linked/imported values
  • Gray: static constants
  • Orange: review/caution
  • Light red: error/flag
  • Purple: control/logic
  • Teal: visualization anchors (key KPIs or chart drivers)

Finance-specific requirements

  • Format zeros as "-".
  • Negative numbers should be red and in parentheses.
  • Always specify units in headers (e.g., "Revenue ($mm)").
  • Cite sources for all raw inputs in cell comments.

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; 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 left-aligned.
  • Indent submetrics under their parent line items.

© lawve-ai, 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 6 other files (references) in skills/excel-editor-openai of lawve-ai/awesome-legal-skills.

  • SKILL.md
  • LICENSE.txt
  • README.md
  • 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 045f738

Compare with similar skills

XLSX Processing Openai 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.

XLSX Processing Openai compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
XLSX Processing Openai this skilllawve-ai/awesome-legal-skills842—~1.3kAutomated safety check: NotesApache-2.0
Openai Spreadsheettrailofbits/skills-curated513—~1.3kAutomated safety check: NotesCC-BY-SA-4.0
XLSXnexus-research-lab/nexus151—~501Automated safety check: PassApache-2.0
Office XLSXsingula-ai/alego1091 repos~2.3kAutomated safety check: PassMIT
Spreadsheetdavila7/claude-code-templates32k1 repos~1.3kAutomated safety check: NotesApache-2.0
Minimax XLSXLeoYeAI/openclaw-master-skills2.2k—~4.4kAutomated safety check: PassMIT

Similar skills

  • Openai Spreadsheet

    trailofbits/skills-curated

    Official

    A skill your agent uses when tasks involve creating, editing, analyzing, or formatting spreadsheets (.xlsx, .csv, .tsv) using Python (openpyxl, pandas), especially when formulas, references, and…

    513 GitHub stars~1.3k tokensUpdated 2 mo ago
    Documents & OfficeAuto-check: notes
  • XLSX

    nexus-research-lab/nexus

    只要电子表格文件(.xlsx、.xlsm、旧版 .xls、.csv、.tsv)是任务的主要输入或输出,或者需要 被打开、读取、创建、修改,就使用本 Skill。也适用于公式、格式、图表、数据清洗和表格格式转换。

    151 GitHub stars~501 tokensUpdated today
    Documents & OfficeAuto-check passed
  • Office XLSX

    singula-ai/alego

    Read, create, and modify Excel workbooks (.xlsx), including data, formulas, formatting, and pandas analysis.

    109 GitHub starsUsed in 1 repo~2.3k tokens
    Documents & OfficeAuto-check passed
  • Spreadsheet

    davila7/claude-code-templates

    A skill your agent uses when tasks involve creating, editing, analyzing, or formatting spreadsheets (.xlsx, .csv, .tsv) using Python (openpyxl, pandas), especially when formulas, references, and…

    32k GitHub starsUsed in 1 repo~1.3k tokens
    Documents & OfficeAuto-check: notes
  • Minimax XLSX

    LeoYeAI/openclaw-master-skills

    MiniMax spreadsheet production system. An agent skill from LeoYeAI/openclaw-master-skills.

    2.2k GitHub stars~4.4k tokensUpdated 2 mo ago
    Documents & OfficeAuto-check passed
  • 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 today
    Documents & OfficeAuto-check passed

More from lawve-ai/awesome-legal-skills

All 154 skills in this repo
  • Customs Trade Law Onur Kafkas

    lawve-ai/awesome-legal-skills

    U.S. An agent skill from lawve-ai/awesome-legal-skills.

    842 GitHub stars~4.1k tokensUpdated 7 days ago
    Auto-check passed
  • Eu Data Act Oliver Schmidt Prietz

    lawve-ai/awesome-legal-skills

    Practitioner skill for advising on EU Regulation 2023/2854 (Data Act).

    842 GitHub stars~3.9k tokensUpdated 7 days ago
    Auto-check passed
  • Litigation Deadline Calendar

    lawve-ai/awesome-legal-skills

    Calendar litigation and arbitration deadlines from a scheduling order.

    842 GitHub stars~4.3k tokensUpdated 7 days ago
    Auto-check passed
  • Outlook Emails Lawvable

    lawve-ai/awesome-legal-skills

    Read, search, and download emails and attachments from Microsoft Outlook via OAuth2.

    842 GitHub stars~672 tokensUpdated 7 days ago
    Auto-check passed
  • Ambiguity Report

    lawve-ai/awesome-legal-skills

    Turn an interpretive-ambiguity audit of a legal text — contract, statute, regulation, or judicial opinion — into a polished deliverable.

    842 GitHub stars~4.6k tokensUpdated 7 days ago
    Auto-check passed
  • Az Eu Website Privacy Audit

    lawve-ai/awesome-legal-skills

    Audits a website for compliance with Azerbaijan's Law on Personal Data No.

    842 GitHub stars~3.8k tokensUpdated 7 days ago
    Auto-check passed

Questions about XLSX Processing Openai

What does XLSX Processing Openai do?

Toolkit for comprehensive Spreadsheet reading, creation, editing, and analysis with visual quality control. XLSX Processing Openai is an agent skill from lawve-ai/awesome-legal-skills. Toolkit for comprehensive Spreadsheet reading, creation, editing, and analysis with visual quality control.

When should I use XLSX Processing Openai?

XLSX Processing Openai fits situations like: work with spreadsheets (.xlsx; creating new spreadsheets with formulas and formatting; analyzing tabular data; modifying existing spreadsheets while preserving formulas.

How do I install XLSX Processing Openai in Claude Code?

Run `npx skills add lawve-ai/awesome-legal-skills --skill xlsx-processing-openai -a claude-code`. Or copy the skill folder (skills/excel-editor-openai in lawve-ai/awesome-legal-skills) into .claude/skills/xlsx-processing-openai in your project. Claude Code loads it when a task matches its description.

How do I install XLSX Processing Openai in Codex?

Run `npx skills add lawve-ai/awesome-legal-skills --skill xlsx-processing-openai -a codex`. Or copy the skill folder (skills/excel-editor-openai in lawve-ai/awesome-legal-skills) into .agents/skills/xlsx-processing-openai in your project. Codex loads it when a task matches its description.

Can I use XLSX Processing Openai 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 lawve-ai/awesome-legal-skills --skill xlsx-processing-openai -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/xlsx-processing-openai, .gemini/skills/xlsx-processing-openai, .github/skills/xlsx-processing-openai and .opencode/skills/xlsx-processing-openai in your project.

What does XLSX Processing Openai need to run?

Going by SKILL.md and its folder, XLSX Processing Openai 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 XLSX Processing Openai 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 XLSX Processing Openai 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 XLSX Processing Openai use?

XLSX Processing Openai is published under the Apache-2.0 licence (from the LICENSE file in the skill folder). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does XLSX Processing Openai use?

About 1.3k tokens (SKILL.md is roughly 5.4k 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 XLSX Processing Openai?

Skills that share tags, products or a category with XLSX Processing Openai: Openai Spreadsheet (trailofbits/skills-curated, 513 stars), XLSX (nexus-research-lab/nexus, 151 stars), Office XLSX (singula-ai/alego, 109 stars) and Spreadsheet (davila7/claude-code-templates, 32k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains XLSX Processing Openai?

lawve-ai (a GitHub organization) maintains it in lawve-ai/awesome-legal-skills, which has 842 GitHub stars. The repository holds 154 skills in this directory. The repository was last updated on October 2, 2026.

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