A professional-grade Excel automation engine for creating, reading, and analyzing spreadsheets with full formula and formatting support.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install xlsx-skill
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install xlsx-skill using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is XLSX Skill?
The XLSX Skill is a robust document processing module designed for the Openclaw Skills ecosystem, enabling developers to programmatically manage Excel workbooks. By combining the data manipulation power of pandas with the granular formatting capabilities of openpyxl, it allows for the creation of complex financial models, automated dashboards, and cleaned data exports. This skill supports modern spreadsheet formats including .xlsx and .xlsm, as well as flat .csv files.
Built for technical workflows, the XLSX Skill provides high-level abstractions for common tasks like writing DataFrames to sheets, while maintaining low-level access for cell-level styling, conditional formatting, and chart insertion. It is the ideal tool for teams using Openclaw Skills to bridge the gap between raw data analysis and stakeholder-ready reporting.
XLSX Skill Use Cases
- Generating automated monthly financial reports with standard accounting formatting.
- Building data cleaning pipelines that strip duplicates and standardize text formats.
- Creating interactive templates with data validation and dropdown menus for user input.
- Exporting complex data analytics into visual dashboards featuring native Excel charts.
- Bulk conversion of legacy CSV data into structured, multi-sheet Excel workbooks.
How XLSX Skill Works
- The skill initializes by either creating a new workbook object or loading an existing file from the filesystem.
- Data is ingested or manipulated using pandas for speed or openpyxl for specific spreadsheet features.
- Logic is applied to set cell values, define Excel formulas, and establish cross-sheet references.
- Visual elements like borders, fonts, and conditional formatting rules are applied to the active worksheet.
- If required, the skill generates native Excel charts (Bar, Line, Pie) based on defined data ranges.
- The final state is serialized and saved to an .xlsx file, ready for distribution or further automated steps within Openclaw Skills.
XLSX Skill Setup
To get started with this skill in your Openclaw Skills environment, install the necessary Python dependencies:
pip install pandas openpyxl xlsxwriter
For advanced visualization and export capabilities, consider installing these optional tools:
# For chart support
pip install numpy
# For PDF export
brew install --cask libreoffice
XLSX Skill Data Schema & Taxonomy
The XLSX Skill organizes information following the standard spreadsheet hierarchy, ensuring compatibility across all Openclaw Skills workflows:
| Component | Description |
|---|---|
| Workbook | The primary file container (.xlsx, .xlsm, .csv) |
| Worksheet | Individual sheets identified by name or index |
| Cell | Data points containing values, formulas, and style metadata |
| Style | Format objects including Font, Fill, Border, and Alignment |
| Chart | Visual representations linked to specific cell ranges |
XLSX Skill Advanced Features
- Support for complex Excel formulas and cross-sheet cell references.
- Native chart generation including BarChart, LineChart, and PieChart objects.
- Advanced conditional formatting using CellIsRule and custom FormulaRules.
- Integrated data validation for dropdown lists and numerical range enforcement.
- Pivot table support through pandas integration for deep data summary.
- Adherence to financial modeling standards with programmatic color-coding for inputs and outputs.
SKILL.md
Loading
Related Openclaw Skills
PDF Skill
A comprehensive document processing engine for creating, editing, merging, and extracting structured data from PDF files using Python-based tools.
Indie App Marketing Pipeline
A zero-LLM daily marketing system for indie developers that generates and schedules a full week of multi-platform social content from a pre-defined content bank.
CPS Monetization Pro
A systematic framework for executing high-conversion Cost-Per-Sale (CPS) affiliate marketing campaigns across multiple platforms.
Durable Workflow Patterns
A comprehensive set of patterns and scripts for building AI agent workflows that maintain state and survive external failures.
Cross-border E-commerce Strategy
A systematic framework designed to achieve positive cash flow and scalable operations in international markets within 90 days.
Fish Audio
A professional-grade AI audio generation skill for text-to-speech and voice cloning through the Fish Audio API.
Featured*
