A specialized utility for AI agents to generate professional, multi-sheet Excel workbooks from structured JSON data using Openclaw Skills.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install excel-export
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-export 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 Export?
The Excel Export skill provides a robust mechanism for AI agents to deliver production-ready .xlsx files. It excels at creating sales reports, financial summaries, and multi-sheet data exports with deterministic layouts, frozen headers, and built-in filters. Designed with a focus on data integrity, this addition to Openclaw Skills ensures that leading zeros are preserved, dates are correctly typed, and calculations remain live via Excel formulas.
This skill is built to handle the entire workbook creation process, applying professional styling like Table Style Medium 9 and banded rows automatically. It is particularly useful for developers using Openclaw Skills who need to present data in a format that is immediately ready for business stakeholders, complete with regional formatting defaults for French and Moroccan locales.
Excel Export Use Cases
- Generating quarterly financial summaries or sales reports with automated totals.
- Exporting database query results into formatted spreadsheets for non-technical users.
- Creating multi-sheet workbooks for complex data analysis across different categories.
- Delivering structured data with region-specific formatting such as MAD currency and French booleans.
How Excel Export Works
- The AI agent prepares a structured JSON file containing sheet definitions, column metadata, and row-level data.
- The Python-based script within the Openclaw Skills library is invoked using the specified input JSON and output path.
- The utility validates the data schema, checking for duplicate sheet names, column type consistency, and Excel constraints.
- The xlsxwriter engine generates the workbook, applying deterministic layouts and frozen panes based on the presence of titles.
- Column widths are auto-estimated and table filters are applied to every sheet.
- A success summary in JSON format is returned, detailing the absolute path and the number of rows processed per sheet.
Excel Export Setup
To prepare your environment for this skill, create a dedicated virtual environment and install the required dependencies:
python3 -m venv ~/.openclaw/workspace/.venv_excel
~/.openclaw/workspace/.venv_excel/bin/pip install xlsxwriter
Excel Export Data Schema & Taxonomy
The skill utilizes a specific JSON structure to define the workbook content. It requires a top-level sheets array where each object defines a single tab.
| Level | Field | Description |
|---|---|---|
| Sheet | name |
The tab name (maximum 31 characters). |
| Sheet | columns |
An array of column metadata (key, header, type, total). |
| Column | type |
Supports text, integer, number, percent, currency, date, and boolean. |
| Column | total |
Optional summary functions: sum, average, or count. |
| Data | rows |
An array of objects where keys must match the defined column keys. |
Excel Export Advanced Features
- Live Formula Support: Allows the injection of Excel structured references (e.g.,
=[@Revenue]/SUM([Revenue])) that remain dynamic in the final file. - Data Integrity Doctrine: Prevents Excel from corrupting long numeric strings, such as phone numbers, by enforcing explicit text storage.
- Automatic Layout Management: Deterministically handles title and subtitle positioning with automatic frozen panes for better readability.
- Regional Formatting: Built-in defaults for Moroccan Dirham (MAD) and French date/boolean formats, making it ideal for international Openclaw Skills implementations.
SKILL.md
Loading
Related Openclaw Skills
AI PDF Converter
A high-performance AI document processing tool that converts PDFs into structured formats like Markdown, HTML, and DOCX using intelligent layout analysis.
Context Usage Checker
A smart utility to monitor, visualize, and manage your AI session's token consumption and remaining context window.
Smart PDF OCR
An intelligent document processing skill powered by the MinerU API for high-precision OCR and layout analysis of scanned PDFs.
Code Explore
A specialized skill for inspecting and mapping the structure, logic, and data flow of local codebases without modifying files.
Smart PDF Reader
An intelligent PDF processing tool that extracts text, formulas, and tables from complex documents using the MinerU API.
PDF to Text Extraction (MinerU)
Extract high-quality text from PDFs using the MinerU API with support for OCR and batch processing.
METADATA
Featured*
