An automated tool for creating professional, Bloomberg-aesthetic Excel workbooks featuring dashboards, KPI cards, and advanced conditional formatting from natural language.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install excel-generator
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-generator 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 Generator?
The Excel Generator is a powerful utility designed to transform natural language descriptions into high-end, business-ready Excel workbooks. By leveraging Python and the openpyxl library, this tool adheres to a strict Bloomberg-terminal aesthetic, ensuring that every spreadsheet produced looks like it came from a top-tier financial institution. It is an essential component of the Openclaw Skills ecosystem for users who need to automate the creation of complex reports, trackers, and financial models.
Beyond simple data entry, the skill focuses on presentation and usability. It automatically handles structural elements like freezing panes, alternating row colors, and professional color schemes. Whether you are building an inventory system or a SaaS financial dashboard, the Excel Generator ensures consistency across all generated assets while maintaining professional quality standards.
Excel Generator Use Cases
- Creating professional financial dashboards with P&L and cash flow tracking.
- Developing robust inventory management systems with automated status alerts for low stock.
- Generating project trackers that include RAG (Red, Amber, Green) status indicators and completion percentages.
- Building HR headcount reports and organization chart data structures.
- Automating sales pipeline forecasting with weighted calculations and rep performance metrics.
How Excel Generator Works
- Analyze the user's natural language request to identify the specific workbook type, required metrics, and necessary data sheets.
- Initialize a Python script using the openpyxl library, incorporating predefined Bloomberg style constants for visual consistency.
- Construct the Workbook structure, ensuring the first sheet is always a high-level Dashboard containing KPI cards and summary tables.
- Apply professional formatting, including alternating ICE and WHITE row colors, bold navy headers, and properly aligned number columns.
- Generate and save the final .xlsx file to the designated workspace, optionally applying password protection for secure client delivery.
Excel Generator Setup
To use the Excel Generator within the Openclaw Skills environment, ensure your workspace is configured and run the generator script via your terminal:
# Navigate to your workspace
cd ~/.openclaw/workspace
# Run the generator with specific parameters
python3 scripts/excel_generator.py \
--type "financial_dashboard" \
--output "excel-projects/monthly_report.xlsx" \
--title "Monthly Performance Report"
Excel Generator Data Schema & Taxonomy
Every workbook generated by this skill follows a standardized taxonomy to ensure professional data organization:
| Sheet Type | Content Description |
|---|---|
| Dashboard | The primary sheet containing KPI cards, summary tables, and charts. Always positioned as the first tab. |
| Data Sheets | Specific functional tabs based on the template (e.g., Tasks, P&L, Inventory Roster). |
| Raw Data | A background sheet used for source data and complex calculations to keep presentation sheets clean. |
| Analytics | Formulas, pivot-ready data, and rollups used to feed the Dashboard visuals. |
Excel Generator Advanced Features
- Bloomberg-Terminal Aesthetic: Uses a specific color palette including NAVY (0D1B2A) and GOLD (C9A84C) for a premium financial look.
- Automatic Status Formulas: Built-in logic for inventory and project tracking (e.g., OK, LOW, OUT status icons).
- Secured Delivery: Automated password protection using standard protocols for sensitive business documents.
- Multi-Agent Compatibility: Can be triggered by other Openclaw Skills to visualize data fetched from APIs or databases.
- Dynamic Formatting: Auto-sizing column widths and conditional formatting based on data values (CRIMSON for negative, GREEN_SAFE for positive).
SKILL.md
Loading
Related Openclaw Skills
Use OpenClaw
A specialized skill for managing local OpenClaw environments, troubleshooting configurations, and developing new agent capabilities.
Bilibili Audio Transcribe
A specialized tool for downloading Bilibili audio and generating accurate transcripts, subtitles, and segment metadata using AI-powered speech recognition.
Qwen TTS (Alibaba Cloud Speech Synthesis)
A high-performance speech synthesis skill powered by Alibaba Cloud Qianwen for natural and emotional text-to-voice conversion.
Weather
A lightweight skill providing instant access to global weather forecasts and meteorological data directly through the command line or programmatic APIs.
Travel Brainstorming and Planning Skill
An intelligent travel planning skill that clarifies vague user requirements through step-by-step dialogue and uses FlyAI CLI to generate data-backed itineraries.
Qwen Image Gen
A professional-grade image generation skill powered by Alibaba Cloud's Qwen models for high-fidelity text-to-image creation.
Featured*
