What’s most frustrating about Excel isn’t any single feature—it’s the entire workflow: cleaning data, writing formulas, summarizing results, and finally, checking for errors. Recently, I came across two lists: one is the “Excel Efficiency Skills Ranking” from the Puyun Open Source Research Institute, and the other is the data analysis section of GitHub’s comprehensive list of skills across various fields. The lists look impressive at first glance, but I checked every name on GitHub—anything without a visible repository was excluded. The 15 AI Excel tools below have all been verified to have available source code and be installable. These AI spreadsheet tools and Excel automation tools form a list of Claude Code Excel Skills and Excel Agent Skills, grouped into three use cases; the star ratings are my own—for reference only. Drop them into Claude Code and your AI agents get real Excel automation.
The installation process is generally similar: one line npx skills add repository-url --skill-name You can then access Claude Code. Before installing it, we recommend clicking into the repository and taking a quick look at SKILL.md to make sure it does what you need it to do. I’ve written about both spreadsheets and documents before.15 AI Tools for Creating PowerPoint Presentations...This post pretty much rounds out the Excel section.
Table Creation and Formatting: Building a Presentable Table from Scratch
The formatting, color scheme, and fonts are all set up for you—just submit it and share.
xlsx ★★★★★ | Full-Workbook Handling
Built by Anthropic, it’s the undisputed leader among Excel AI Skills. It handles Excel spreadsheet creation, reads data, edits templates and generates charts—and it enforces a strict rule: the delivered spreadsheets must be free of formula errors; not a single error like “#REF!” or “#DIV/0!” is allowed. If you’re not sure which one to install, start with this one.
proxlsx-skill ★★★★☆ | Report Layout
It’s not just about getting it right—it’s about making it look good, too. It features a built-in “anti-AI” design system: automatic theme application, hidden gridlines, first-row locking, and uniform number formatting. It even catches and renames lazy label names like “Sheet1.” Use it to create spreadsheets for your boss.
document-xlsx ★★★☆☆ | Secure External Distribution
It specializes in securely writing data to .xlsx files before sharing them. It is highly vigilant against untrusted files: it checks for potential pitfalls such as external links, macros, and formula injection in advance. It is ideal for roles that frequently need to share copies of spreadsheets with others.
Formulas, Cleaning, and Debugging: Getting the Results Is Just the Beginning
Just because a spreadsheet opens doesn't mean it's free of pitfalls—what really matters is whether it's accurate and clean.
clean-data-xls ★★★★☆ | Data Cleaning
This Excel data cleaning AI handles “dirty” data: extra spaces, mixed case, text-formatted numbers, various date formats, and duplicate rows—there are corresponding check items for each. It prioritizes cleaning the data using auxiliary column formulas, leaving the original data untouched, so you can revert changes at any time if you make a mistake.
spreadsheet-formula-helper ★★★★☆ | Formula Writing
An AI Excel formula generator that turns human-readable requirements into executable formulas. After writing the code, I provide explanations and sample data, and proactively account for edge cases such as blank rows and duplicate values. Converting between Excel and Google Sheets is also a breeze.
audit-xls ★★★★☆ | Formula Auditing
Just because you've finished the spreadsheet doesn't mean there aren't any pitfalls. This Excel formula checker lists issues in order of severity: hard-coded values in formulas, incorrect range selection, circular references, and broken cross-sheet links. Go over it once before submitting your financial model.
excel-pivot-wizard ★★★☆☆ | PivotTable Summary
Generate an Excel pivot table with a single command—this Excel pivot table automation tool supports calculated fields and slicers, which is more than enough for creating interactive dashboards. Breaking down sales by region and month used to take ages, but now it’s done with a single command. It’s lightweight, but its features aren’t as robust as the previous ones. I’d give it three and a half stars, but I’ll round it down to three.
microsoft-excel ★★★☆☆ | Repetitive Automation
I’ve turned the Excel tasks I repeat every week into Office Scripts (TypeScript) so the process runs automatically, and I use Power Query to import data. It also explicitly requires that you “don’t hardcode magic numbers in formulas”—parameters, units, and assumptions must all be clearly defined, which I really like.
Advanced Users and Data Analysis: When Tables Are Large and Data Is Complex
Export files containing millions of rows—reports that need to be loaded into the data warehouse—it’s time for this batch to take the stage.
claude-office-skills (Finance Edition) ★★★★☆ | Financial Modeling
A collection of tools extracted from the "Claude in Excel" add-in: in addition to "audit-xls" and "clean-data-xls," it includes DCF valuation, integrated financial statements, and peer company analysis. Those using AI financial modeling tools can download the entire package.
claude-office-skills (Complete Edition) ★★★★☆ | Excel, Word, PPT & PDF
Package Claude's desktop Office capabilities for use on the command line: a complete set of workflows for Excel, Word, PowerPoint, and PDF. The Excel component also enforces zero formula errors and follows color-coding conventions, making Excel report automation a breeze.
finance-skills ★★★★☆ | Data Analysis · 3.3k stars
Although its name includes “finance,” it’s actually a very practical AI spreadsheet analysis toolkit: a one-stop solution for market data, analysis, trading, and reporting. You can simply hand it tasks like checking market trends and performing comparative analyses—it’s quite popular among data analysis tools.
csv-data-summarizer-claude-skill ★★★☆☆ | CSV Summary
Just upload a CSV file, and it automatically generates a statistical summary, checks for missing values, and even lets you create visualizations using Python/pandas. It’s the first stop for AI CSV data analysis when I have a bunch of exported files—I use it to see what the data looks like before deciding how to process it.
github.com/skills-directory/csv-data-summarizer-claude-skill
duckdb-skills ★★★★☆ | Official Release
An official DuckDB skillset that includes CSV exploration, database mounting, and document search. Running an export file with millions of rows through it is much faster than manually opening it in a spreadsheet program.
dbt-agent-skills ★★★☆☆ | Data Warehouse Workflow
Officially developed by dbt Labs, it features 17 skills covering modeling, testing, and the semantic layer. Strictly speaking, it’s not an Excel tool, but if your spreadsheet data is ultimately destined for a data warehouse, it can handle that intermediate step—and anyone who creates reports will find it useful sooner or later.
qmd-skill ★★★☆☆ | Quick Search
Quick Markdown Search is ideal for quickly searching and analyzing structured data. When used in conjunction with the previous tools, it makes researching information and drawing conclusions a breeze—it’s one of those tools that’s unassuming but frequently used.
Two honest statements:The star ratings are based on feature coverage and repository maintenance, not actual benchmark scores. There are two or three entries on the list (such as "excel-sheet-reference") for which I couldn't find reliable source code; I'd rather leave one off than include a link just for the sake of it.
There are two more articles in this series:20 Web Design Skills 和 20 Word Tips for the Office...So, we've pretty much got everything we need for the office set up.









