A specialized skill for creating, inspecting, and editing Microsoft Excel workbooks while preserving formulas, formatting, and structural integrity.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install excel-xlsx-1
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-1 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?
The Excel / XLSX skill is designed for AI agents that need to interact with spreadsheet files beyond simple data ingestion. It enables the creation and modification of .xlsx, .xlsm, and .xls files while ensuring that complex features like live formulas, merged cells, and conditional formatting remain intact. By utilizing this skill within Openclaw Skills, users can bridge the gap between automated data processing and human-readable, interactive spreadsheet deliverables.
This skill prioritizes technical accuracy, particularly regarding Excel's unique handling of dates as serial numbers and its tendency to truncate long numeric identifiers. Whether you are building financial models or generating corporate reports, this skill ensures that the resulting workbooks are professional, functional, and free of common calculation errors.
Excel / XLSX Use Cases
- Generating dynamic financial reports where formulas must remain live for user adjustment.
- Protecting sensitive data types like ZIP codes and phone numbers from being mangled by Excel auto-formatting.
- Updating existing workbook templates without losing custom styles, print settings, or hidden sheets.
- Automating the conversion of raw analytical data into structured, multi-sheet workbooks.
- Managing large-scale data migrations that require streaming reads to prevent memory spikes.
How Excel / XLSX Works
- Select the appropriate library workflow, such as pandas for data-heavy analysis or openpyxl for style-preserving edits.
- Open or initialize the workbook, identifying key sheets, named ranges, and existing formatting conventions.
- Write data to cells while explicitly defining data types to prevent automatic corruption of numbers or dates.
- Embed Excel formulas using relative and absolute references to maintain a live, interactive model.
- Validate the workbook structure, checking for off-by-one errors in formulas and ensuring all merged areas and hidden rows are preserved.
- Export the final file after verifying that recalculation results are consistent and visual layouts are professional.
Excel / XLSX Setup
Install the skill using the clawhub CLI:
clawhub install excel-xlsx
To ensure you have the latest updates and logic improvements for your Openclaw Skills, run:
clawhub sync
Excel / XLSX Data Schema & Taxonomy
| Component | Description |
|---|---|
| File Formats | Supports .xlsx, .xlsm, .xls, .csv, and .tsv. |
| Cell Logic | Handles formulas, cached values, and defined named ranges. |
| Data Integrity | Manages serial date numbers, 15-digit numeric precision, and text-based identifiers. |
| Formatting | Preserves merged cells, hidden sheets, column widths, and print areas. |
Excel / XLSX Advanced Features
- Advanced formula anchoring and model traceability for complex financial workbooks.
- Support for streaming reads and chunked processing to handle massive spreadsheet files without memory exhaustion.
- Template-aware editing that respects pre-existing corporate styles and business logic.
- Detailed audit capabilities to identify and resolve formula errors like circular references or broken links.
- Seamless integration with other Openclaw Skills for comprehensive data analysis and automated reporting workflows.
SKILL.md
Loading
Related Openclaw Skills
Tencent LKE Chat SSE
A high-performance HTTP SSE interface for integrating Tencent Cloud Intelligent Agents with support for streaming, event parsing, and DeepSeek models.
Security Audit Skill
A lightweight, observer-only security layer for logging agent actions, auditing history, and reviewing configuration risks.
gi-summarize
A sophisticated text distillation engine that transforms long documents, meeting transcripts, and codebases into structured, concise summaries.
Deck Narrative Planner
An AI-powered presentation architect that converts raw materials into structured narrative decks with slide-by-slide logic.
Ezviz Restaurant Inspection
An AI-driven inspection tool that uses Ezviz camera captures and intelligent agents to monitor restaurant hygiene, fire safety, and staff compliance.
13-Week Cash Flow Forecast
A professional financial modeling tool to build and maintain rolling 13-week cash flow forecasts for precise liquidity management.
Featured*
