A comprehensive automation toolkit for programmatically managing, transforming, and validating Excel and CSV files.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install automate-excel
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 automate-excel 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 Automate Excel?
The Automate Excel skill is a professional-grade suite of scripts designed to eliminate manual spreadsheet management. By leveraging the power of Python libraries like pandas and openpyxl, it provides a robust interface for AI agents and developers to handle complex data tasks. This addition to your Openclaw Skills library ensures that your automation workflows can read, write, and manipulate .xlsx and .xls files with precision, maintaining formatting and formulas while processing large datasets efficiently.
Automate Excel Use Cases
- Merging hundreds of individual Excel files or sheets into a unified master report.
- Converting bulk CSV data into formatted Excel workbooks for business presentations.
- Automating the extraction of specific rows from massive spreadsheets based on complex filtering logic.
- Splitting a master database file into smaller chunks for distribution by region or department.
- Deduplicating customer lists or inventory records based on unique key columns.
- Generating personalized documents by injecting data into Excel templates using placeholders.
How Automate Excel Works
- The skill identifies the source file path and specific worksheets or indices required for the task.
- Data is ingested using openpyxl for cell-level precision or pandas for high-performance analytical processing.
- The selected script applies the requested logic, such as VLOOKUP-style joins, aggregations, or conditional formatting.
- Processed data is written back to a new or existing file, with options to preserve original styles or apply new ones.
- A final validation step checks the output against required schemas or business rules to ensure accuracy.
Automate Excel Setup
To get started with this skill, navigate to the skill directory and install the required Python dependencies:
pip install openpyxl pandas xlrd
Alternatively, you can install everything via the provided requirements file:
pip install -r scripts/requirements.txt
You can then run any script with the --help flag to see available parameters:
python scripts/filter_excel.py --help
Automate Excel Data Schema & Taxonomy
The skill organizes data using standard tabular structures. Below is the metadata and file handling taxonomy:
| Feature | Specification |
|---|---|
| Supported Formats | .xlsx (OpenXML), .xls (Legacy via xlrd), .csv |
| In-Memory Format | Pandas DataFrames or List of Dictionaries (JSON-like) |
| Cell Metadata | Supports Font, Alignment, and Formula preservation via openpyxl |
| Output Convention | Configurable output paths, supporting suffixes like _out or timestamps |
Automate Excel Advanced Features
- Multi-Table VLOOKUP: Connect a primary table to multiple lookup sources simultaneously using vlookup_multi.py.
- Template Filling: Use dynamic placeholders like {{column_name}} in an Excel template to generate mass reports.
- Conditional Formatting Rules: Programmatically apply color scales, data bars, and logical highlighting (e.g., highlighting values > 100).
- Scientific Notation Prevention: Automatically format long numeric strings (like IDs) as text to prevent data corruption.
- Batch Directory Processing: Use file globbing to apply the same transformation logic across every file in a folder.
SKILL.md
Loading
Related Openclaw Skills
FlowMonitor Universal
A universal execution tracer designed to monitor latency, resource costs, and flow logic for AI agent workflows.
Zenzap Agentic Onboarding
Bootstrap a complete Zenzap workspace including organization creation, bot installation, and user invitations via a single API interface.
Skill Sandbox
A secure installation pipeline that stages, scans, and auto-promotes or quarantines Openclaw Skills based on multi-layer static security analysis.
OpenClaw Guardian
A production-ready watchdog that monitors, repairs, and alerts for the OpenClaw gateway service to ensure high availability.
Git Summary
An essential Git diagnostic tool that provides a comprehensive overview of repository status, recent commits, and contributor activity.
Star Hotel Search
A smart hotel discovery tool for AI agents that filters accommodations by location, price, and amenities via the Star Hotel MCP.
Featured*
