How is this list ordered?

It is ranked by observed search demand, with direct matches for the Excel topic placed first. No single publisher can take more than a capped share of the list.

Which Excel skill should I start with?

Start at the stage of the stack where your work is breaking: data cleaning if your inputs are messy, formulas and functions if the calculations are wrong, pivot tables or charts if the summary isn't readable, automation if you keep repeating the same clicks. Skills for data models only matter once you're working across related tables rather than a single sheet.

Can one skill handle cleaning, formulas, pivots, and charts?

Some entries span more than one sub-topic, but the topic is organized around distinct stages: calculated cells, trusted tables, pivot summaries, readable charts, automation, and related tables. Match the skill to the stage you're on instead of expecting one package to cover the whole stack.

Do I need automation skills if I already know formulas?

Automation is a separate sub-topic aimed at repeating a procedure without redoing the clicks, so it applies when the same sequence runs more than once. Formulas and functions cover the calculated cells themselves; automation covers the repetition around them.

← Browse all topicsOutputs

Excel Skills for AI Agents: Formulas to Charts

Excel skills cover the whole working stack of a spreadsheet deliverable: cleaning messy inputs into a table you can trust, writing formulas and functions for lookups, logic, and aggregations, building pivot tables that summarize a table by dragging fields, turning ranges into readable charts, relating tables through data models beyond a single sheet, and automating procedures so you don't redo the clicks. The work usually stacks in that order — clean input, calculate, summarize, chart, then automate what you repeat — so pick the skill that matches the stage you're stuck on rather than the one with the broadest description. Read the ranked list top to bottom, open the entries whose sub-topic matches your current bottleneck, and compare how each one frames its input and output before you load it.

8 to start with24 top options

Start with these.

Excel work stacks: clean input, calculate, summarize, chart, then automate what you repeat.

These are the closest matches for this work. Start with the first one and open it to install.

Rank 01
Direct
xlsx
Official
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like \"the xlsx in my downloads\") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.
by anthropics/skills
View Agent Skill
Rank 02
Direct
xlsx-manipulation
Create, edit, and manipulate Excel spreadsheets programmatically using openpyxl
by claude-office-skills/skills
- Pivot tables
5,890 · popularity
View Agent Skill
Rank 03
Direct
excel-automation
by claude-office-skills/skills
- Automation
15,217 · popularity
View Agent Skill
Rank 04
Direct
clean-data-xls
Clean up messy spreadsheet data — trim whitespace, fix inconsistent casing, convert numbers-stored-as-text, standardize dates, remove duplicates, and flag mixed-type columns. Use when data is messy, inconsistent, or needs prep before analysis. Triggers on "clean this data", "clean up this sheet",…
by anthropics/financial-services
- Data cleaning
1,965 · popularity
View Agent Skill
Rank 05
Direct
audit-xls
Audit a spreadsheet for formula accuracy, errors, and common mistakes. Scopes to a selected range, a single sheet, or the entire model (including financial-model integrity checks like BS balance, cash tie-out, and logic sanity). Triggers on "audit this sheet", "check my formulas", "find formula…
by anthropics/financial-services
2,060 · popularity
View Agent Skill
Rank 06
Direct
minimax-xlsx
Open, create, read, analyze, edit, or validate Excel/spreadsheet files (.xlsx, .xlsm, .csv, .tsv). Use when the user asks to create, build, modify, analyze, read, validate, or format any Excel spreadsheet, financial model, pivot table, or tabular data file. Covers: creating new xlsx from scratch,…
by minimax-ai/skills
- Formulas & functions
- Pivot tables
- Automation
3,715 · popularity
View Agent Skill
Rank 07
Direct
lark-sheets
Notable
飞书电子表格：创建和操作电子表格。支持工作表与行列结构（增删/合并/尺寸/隐藏/冻结/分组）、单元格读写（值/公式/样式/批注/单元格图片）、区域复制移动排序填充、查找替换、批量更新，图表、透视表、条件格式、筛选器与筛选视图、下拉列表、迷你图、浮动图片等对象的创建与维护，以及公式校验、历史版本回滚、本地 Excel/CSV 与飞书表格的导入导出。当用户需要创建或编辑表格、统计汇总与可视化、表格美化、公式计算（含 Excel 公式迁移）、金融/财务建模（DCF、三张表、预算、Sensitivity 等）时使用。多维表格（Base/bitable）请改用 lark-base；若用户是想按名称或关键词搜索云空间（云盘/云存储）里的表格文件，请改用 lark-drive 的 drive +search 先定位资源。当用户给出 doubao.com 的 /sheets/ URL/token 时，也应直接使用本 skill，不要因为域名不是飞书而回退到 WebFetch；路由依据是 URL 路径模式和 token，而不是域名。
by larksuite/cli
- Pivot tables
- Charts
749,105 · popularity
View Agent Skill
Rank 08
Direct
gws-sheets
Notable
Google Sheets: Read and write spreadsheets.
by googleworkspace/cli
56,446 · popularity
View Agent Skill

Explore 16 more Agent Skills

Rank 09
Direct
data-analysis
Analyze spreadsheet data, generate insights, create visualizations, and build reports from Excel/CSV data.
by claude-office-skills/skills
7,289 · popularity
View Agent Skill
Rank 10
Direct
gws-sheets-read
Google Sheets: Read values from a spreadsheet.
by googleworkspace/cli
48,658 · popularity
View Agent Skill
Rank 11
Direct
gws-sheets-append
Google Sheets: Append a row to a spreadsheet.
by googleworkspace/cli
44,734 · popularity
View Agent Skill
Rank 12
Direct
recipe-backup-sheet-as-csv
Export a Google Sheets spreadsheet as a CSV file for local backup or processing.
by googleworkspace/cli
30,040 · popularity
View Agent Skill
Rank 13
Direct
recipe-create-expense-tracker
Set up a Google Sheets spreadsheet for tracking expenses with headers and initial entries.
by googleworkspace/cli
28,902 · popularity
View Agent Skill
Rank 14
Direct
recipe-log-deal-update
Append a deal status update to a Google Sheets sales tracking spreadsheet.
by googleworkspace/cli
28,543 · popularity
View Agent Skill
Rank 15
Possible
recipe-sync-contacts-to-sheet
Export Google Contacts directory to a Google Sheets spreadsheet.
by googleworkspace/cli
29,677 · popularity
View Agent Skill
Rank 16
Possible
recipe-create-events-from-sheet
Read event data from a Google Sheets spreadsheet and create Google Calendar entries for each row.
by googleworkspace/cli
29,083 · popularity
View Agent Skill
Rank 17
Possible
powerbi-modeling
Power BI semantic modeling assistant for building optimized data models. Use when working with Power BI semantic models, creating measures, designing star schemas, configuring relationships, implementing RLS, or optimizing model performance. Triggers on queries about DAX calculations, table…
by github/awesome-copilot
- Data models
Needs (stated): MCP server
9,868 · popularity
View Agent Skill
Rank 18
Possible
data-visualization
Create effective data visualizations with Python (matplotlib, seaborn, plotly). Use when building charts, choosing the right chart type for a dataset, creating publication-quality figures, or applying design principles like accessibility and color theory.
by anthropics/knowledge-work-plugins
12,860 · popularity
View Agent Skill
Rank 19
Possible
data-storytelling
Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive presentations.
by wshobson/agents
15,981 · popularity
View Agent Skill
Rank 20
Possible
datanalysis-credit-risk
Credit risk data cleaning and variable screening pipeline for pre-loan modeling. Use when working with raw credit data that needs quality assessment, missing value analysis, or variable selection before modeling. it covers data loading and formatting, abnormal period filtering, missing rate…
by github/awesome-copilot
7,300 · popularity
View Agent Skill
Rank 21
Possible
financial-analyst
Performs financial ratio analysis, DCF valuation, budget variance analysis, and rolling forecast construction for strategic decision-making. Use when analyzing financial statements, building valuation models, assessing budget variances, or constructing financial projections and forecasts. Also…
by alirezarezvani/claude-skills
1,017 · popularity
View Agent Skill
Rank 22
Possible
convert-documents-to-markdown
Convert Word (.doc, .docx), PowerPoint (.ppt, .pptx), Excel (.xls, .xlsx), OpenDocument (.odt, .ods, .odp), RTF, EPUB, CSV, and PDF files to GitHub-Flavored Markdown. Use when a task needs the contents of an office document, spreadsheet, presentation, ebook, or PDF you cannot read directly.
by firecrawl/anydoc
10,958 · popularity
View Agent Skill
Rank 23
Possible
lieflat-charts
Notable
一套模板驱动的数据可视化与报告生成 skill，既能严格从 Lupi、Basics、Glance、Maps 与 Interactive gallery 的真实实现生成 HTML 图表，也能从 12 套中英文整页报告模板生成可发布的 HTML 报告；以 Mono 为保底，能按数据语义自动选择内置彩色预设，也支持用户明确提供的自定义色板。地图仅在用户明确要求时启用，同一交付禁止混用色系。
by larashero3-dotcom/lieflat-charts
View Agent Skill
Rank 24
Possible
diagram-design
Notable
Create branded architecture, IT current-state, flowchart, sequence, state machine, ER/data model, timeline, swimlane, quadrant, radar/spider, polar chart (polar/radial lollipop), loop/flywheel, nested, tree, org chart, layer stack, Venn, pyramid/funnel, treemap, bar, waterfall, line, Gantt and scatter charts, high-level, process, medallion, data flow, DP integration, DP security matrix, Sankey, fishbone, Wardley map, kanban, user journey, deployment, dependency graph, UML class, story map, or database schema diagrams as standalone HTML/SVG/PNG. Redraw .drawio/.drawio.png/.drawio.svg, Mermaid .mmd, or Excalidraw .excalidraw sources at a chosen size/detail; onboard brand tokens from a website; add semantic patterns, callouts, accessible motion, or sketchy/hand-drawn styling.
by cathrynlavery/diagram-design
- Data models
View Agent Skill

What this topic covers

Each sub-topic groups Agent Skills for a specific situation.

Formulas & functions: Calculated cells: lookups, logic, aggregations.
Data cleaning: Get messy inputs into a table you can trust.
Pivot tables: Summarize a table by dragging fields.
Charts: Turn a range into a readable chart.
Automation: Repeat a procedure without redoing the clicks.
Data models: Related tables beyond a single sheet.

Frequently asked questions

How is this list ordered?: It is ranked by observed search demand, with direct matches for the Excel topic placed first. No single publisher can take more than a capped share of the list.
Which Excel skill should I start with?: Start at the stage of the stack where your work is breaking: data cleaning if your inputs are messy, formulas and functions if the calculations are wrong, pivot tables or charts if the summary isn't readable, automation if you keep repeating the same clicks. Skills for data models only matter once you're working across related tables rather than a single sheet.
Can one skill handle cleaning, formulas, pivots, and charts?: Some entries span more than one sub-topic, but the topic is organized around distinct stages: calculated cells, trusted tables, pivot summaries, readable charts, automation, and related tables. Match the skill to the stage you're on instead of expecting one package to cover the whole stack.
Do I need automation skills if I already know formulas?: Automation is a separate sub-topic aimed at repeating a procedure without redoing the clicks, so it applies when the same sequence runs more than once. Formulas and functions cover the calculated cells themselves; automation covers the repetition around them.

How to install an Agent Skill

Start with the first skill on this page. Claude Code reads a SKILL.md once it is in the skills directory:

Claude Code — copy the SKILL.md for xlsx into ~/.claude/skills/xlsx/ for yourself, or .claude/skills/xlsx/ to share it with a project.
From the registry — run npx skills add anthropics/skills@xlsx.
Or download xlsx from its source and place that SKILL.md in the directory above.

How to choose Check the source and the skill’s own instructions before you install. Official and Notable describe where a skill comes from.

Excel Skills for AI Agents: Formulas to Charts

xlsx

xlsx-manipulation

excel-automation

clean-data-xls

audit-xls

minimax-xlsx

lark-sheets

gws-sheets

data-analysis

gws-sheets-read

gws-sheets-append

recipe-backup-sheet-as-csv

recipe-create-expense-tracker

recipe-log-deal-update

recipe-sync-contacts-to-sheet

recipe-create-events-from-sheet

powerbi-modeling

data-visualization

data-storytelling

datanalysis-credit-risk

financial-analyst

convert-documents-to-markdown

lieflat-charts

diagram-design