skills.rest
excatt
excattCOMMUNITY
Explore all skills by this author →
GitHub

Excel (XLSX) Spreadsheet Skill

An expert AI system capable of independently executing complex cognitive tasks and workflows, designed to outperform humans in narrowly-defined domains.

14|2|Updated Jan 28, 2026
Search Tags:#automation#financial modeling#data analysis#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/excatt/superclaude-plusplus --skill excel-xlsx-spreadsheet-skill
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Excel (XLSX) Spreadsheet Skill
Source: https://github.com/excatt/superclaude-plusplus/tree/main/skills/xlsx
Command: npx skills add https://github.com/excatt/superclaude-plusplus --skill excel-xlsx-spreadsheet-skill

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, recalc.py, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the creation, editing, and analysis of Excel spreadsheets, eliminating manual data entry and complex formula management.

Core Features & Use Cases

  • Spreadsheet Creation: Generate new .xlsx, .xlsm, .csv, or .tsv files with custom formulas, formatting, and data.
  • Data Analysis & Visualization: Read, analyze, and visualize data directly from spreadsheets.
  • Formula Management: Ensure all formulas are error-free, dynamic, and adhere to financial modeling standards.
  • Use Case: Automatically generate a monthly sales report in Excel, pulling data from various sources, applying complex calculations, and formatting it according to company standards.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue'.

Frequently Asked Questions about Excel (XLSX) Spreadsheet Skill

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Excel spreadsheet creation and data analysis with Python?▼

Automating Excel spreadsheet creation and data analysis involves using Python libraries like pandas and openpyxl to programmatically generate .xlsx files, apply formulas, and format data. This Skill handles that process, including dynamic formula management and automated report generation.

Can I use pandas and openpyxl to generate financial models in .xlsx files?▼

Yes, you can generate financial models in .xlsx files using pandas for data analysis and openpyxl for file manipulation. This Skill ensures formulas are dynamic, error-free, and adhere to financial modeling standards with strict color-coding conventions.

What is the best way to calculate formula values in Excel files programmatically?▼

Calculating formula values in Excel files programmatically requires a dedicated recalc.py script to evaluate formulas. This Skill leverages openpyxl for formula management alongside this script to ensure accurate calculation results.

Does this approach support reading and editing CSV and TSV files?▼

Yes, this approach supports reading, editing, and analyzing CSV and TSV files alongside standard .xlsx and .xlsm formats. It uses pandas to process these tabular data formats for comprehensive data analysis and visualization.

How do I format an automated sales report in Excel with strict formula standards?▼

Formatting an automated sales report in Excel with strict formula standards is done by applying predefined color-coding conventions and dynamic formulas. This Skill automates pulling data, applying calculations, and formatting outputs to meet company standards.

Related Skills

Explore More Finance & Accounting Skills→
pounctpounct

xlsx

Create and edit Excel spreadsheets with formulas using openpyxl and pandas.

Community
Advanced
imvladikonimvladikon
3

xlsx

Automate Excel workbook editing with formulas via openpyxl and pandas.

Community
Intermediate
keturkketurk
2

xlsx

Create and edit Excel spreadsheets with pandas and openpyxl scripting.

Community
Advanced
hgxszhj-pixelhgxszhj-pixel
2

minimax-xlsx

Open, create, edit, analyze, and validate Excel files with Python.

Community
Advanced