A specialized AI agent skill for creating and managing Microsoft Excel workbooks with full support for formulas, formatting, and template preservation.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install excel-xlsx-bak
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 excel-xlsx-bak 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 Excel / XLSX Spreadsheet Automation?
The Excel / XLSX skill for Openclaw Skills provides a robust framework for managing Microsoft Excel workbooks (XLSX, XLSM, XLS) and tabular data. Unlike simple CSV exports, it prioritizes workbook longevity by handling live formulas, complex styles, and legacy date systems.
By integrating this capability via Openclaw Skills, developers can automate report generation, financial modeling, and template-based data entry without losing professional formatting or structural metadata. It ensures that the final output is not just a data dump, but a fully functional, compatible workbook ready for business use.
Excel / XLSX Spreadsheet Automation Use Cases
- Generating complex financial models with live formulas and relative cell references.
- Updating existing Excel templates without destroying corporate branding, merged cells, or hidden rows.
- Processing large datasets while maintaining numeric precision and protecting identifiers like ZIP codes with leading zeros.
- Converting raw data into feature-complete Excel workbooks that include filters, frozen panes, and conditional formatting.
How Excel / XLSX Spreadsheet Automation Works
- Analyzes the specific spreadsheet task to determine if the workflow requires high-level data analysis or structural preservation.
- Inspects existing workbook metadata, including named ranges, sheet-level conventions, and hidden elements to ensure compatibility.
- Implements specialized logic to handle Excel-specific quirks such as the 1900 date system and 15-digit numeric precision limits.
- Writes live formulas and updates cell values while validating against potential error states like circular references or broken links.
- Performs a final review of the workbook structure, styles, and recalculation state before final delivery to the user.
Excel / XLSX Spreadsheet Automation Setup
To add this capability to your agent, install it via the CLI using Openclaw Skills management tools:
clawhub install excel-xlsx
Ensure your environment is configured to support Python-based spreadsheet libraries like openpyxl for structural edits or pandas for data-heavy analysis.
Excel / XLSX Spreadsheet Automation Data Schema & Taxonomy
The skill manages a variety of spreadsheet formats and internal metadata components:
| Component | Details |
|---|---|
| Supported Formats | .xlsx, .xlsm, .xls, .csv, .tsv |
| Data Types | Explicit handling for Strings, Floats, and Serial Dates |
| Structural Metadata | Merged cells, Hidden rows/cols, Named ranges, Sheet order |
| Formatting | Font styles, Cell borders, Fills, Number formats, Conditional formatting |
| Logic Layers | Excel formulas, Cached values, Data validation rules |
Excel / XLSX Spreadsheet Automation Advanced Features
- Advanced formula anchoring and automated recalculation checks to prevent delivering stale or broken values.
- Template-aware preservation logic that respects pre-existing sheet order, freeze panes, and print settings.
- Streaming and chunked read capabilities optimized for handling memory-intensive large workbooks without system crashes.
- Multi-platform compatibility verification for Excel, Google Sheets, and LibreOffice environments.
SKILL.md
Loading
Related Openclaw Skills
Code Quality Analyzer
An advanced AI coding agent skill designed to analyze repository changes, perform automated code reviews, and sync quality metrics to a central database.
China Mirror Accelerator
A performance-focused skill that automatically injects trusted Chinese mirror parameters into installation and download commands.
Restaurant Reservation Radar
An AI-driven assistant that monitors availability and automates reservations for Michelin-star and high-demand restaurants in your travel destinations.
Ecwid Store Manager
A comprehensive REST API v3 integration for managing Ecwid e-commerce store data including products, orders, and promotions.
Token On-Chain Analysis (gate-info-tokenonchain)
A specialized AI agent skill for deep on-chain analysis of crypto tokens, focusing on holder concentration, network activity, and whale movements.
doc-search
A high-performance document vectorization and semantic retrieval engine supporting multi-format processing and hybrid search.
Featured*
