Spreadsheets (XLSX)

Spreadsheets (XLSX)

✓ Verified

Create, read, edit, and manipulate spreadsheet files (.xlsx, .csv, .tsv) with formulas, charts, and data transformations.

Claude / Claude Codetested
GitHub Copilot
Cursor
VS Code
OpenAI Codex
Document CreationDeveloperData AnalystBusiness OwnerTeacher / Educator

What it does

Claude generates openpyxl or xlsxwriter code that produces a spreadsheet — but one with no formatting, no frozen headers, formulas that don't account for dynamic row counts, and charts that use the wrong chart type for the data. This skill loads correct patterns for spreadsheet generation: proper cell formatting, named ranges, formula construction for variable-length data, chart configuration, and conditional formatting that actually highlights what you want.

Use case

Generating spreadsheets programmatically from data: financial reports, data exports, dashboards that need to live in Excel. Most valuable when the output needs to be usable by non-technical stakeholders without manual cleanup. Made by Anthropic.

The Prompt

Copy and use immediately
"Generate a monthly P&L report from this data with totals, percentages, and a chart."
"Create a project budget spreadsheet with cost categories and a summary tab."
"Export this database query result as a formatted Excel file with frozen headers."
"Build a sales dashboard in Excel with sparklines and conditional formatting."
"Generate an invoice template in Excel with automatic total calculation."

How to use

  1. 1

    Provide structured data (JSON, CSV, or database query result) and describe the intended output.

  2. 2

    Claude generates the spreadsheet file with formatting, formulas, and charts applied.

  3. 3

    For templates: describe the structure and Claude builds a reusable template with named ranges and locked cells.

Input / Output

Input

Structured data (JSON, CSV, SQL result) and a description of the spreadsheet layout and formatting you need.

Output

An .xlsx file with correct formatting, frozen headers, properly scoped formulas, and charts configured for the data type. Ready to open without manual formatting.

Install via CLI

npx skillsadd anthropics/skills/xlsx
Added 15 Mar 2026Submitted by anthropics👁 45📋 0

Details

Platforms
Claude / Claude CodeGitHub CopilotCursorVS CodeOpenAI Codex
Category
Document Creation
License
apache-2.0
Author
Anthropic

Stats

📋 Copies0
👁 Views45
👍 Upvotes0

Install with skills.sh

npx skillsadd anthropics/skills/xlsx

Requires skills.sh CLI

Community Notes

Sign in with GitHub to leave a note.

No notes yet. Be the first to contribute.