← Back to Skills Marketplace
8250
Downloads
4
Stars
64
Active Installs
4
Versions
Install in OpenClaw
/install automate-excel
Description
Automates reading, writing, merging, transforming, and validating Excel (.xlsx/.xls) files. Use when the user works with spreadsheets, .xlsx files, Excel dat...
Usage Guidance
Before installing, be aware that this skill can read and write local spreadsheets. Use explicit --output paths where possible, keep backups for important workbooks, and be especially careful with renaming or formatting scripts that may overwrite the original file if no output path is supplied.
Capability Assessment
Purpose & Capability
The artifacts consistently describe and implement Excel/CSV conversion, merging, filtering, validation, formatting, and report-generation workflows using openpyxl, pandas, and xlrd.
Instruction Scope
The activation language is broad for spreadsheet work, and some examples/scripts can modify existing workbooks; this is purpose-aligned and partly disclosed, but users should confirm target files and output paths before running write operations.
Install Mechanism
Installation uses standard Python spreadsheet dependencies, but requirements use minimum-version constraints rather than pinned versions, so installs are not fully reproducible.
Credentials
The scripts operate on user-specified Excel/CSV files or directories and I found no network calls, credential use, browser/session access, broad local indexing, or unrelated system access.
Persistence & Privilege
No background persistence, privilege escalation, scheduled execution, or hidden startup behavior was found; the main residual risk is in-place spreadsheet modification when certain scripts are run without an output path.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install automate-excel - After installation, invoke the skill by name or use
/automate-excel - Provide required inputs per the skill's parameter spec and get structured output
Version History
v0.1.3
Initial public release with a comprehensive toolkit of Excel and CSV batch automation scripts.
- Added 18+ command line scripts for Excel/CSV tasks: merging, conversion, deduplication, filtering, aggregation, validation, splitting, VLOOKUP, renaming sheets, formatting, and template fill.
- Provided ready-to-use code samples and detailed usage guides in SKILL.md.
- Included requirements.txt for easy dependency installation.
- All scripts operate independently and support command line arguments for flexible batch processing.
v0.1.2
- SKILL.md significantly simplified: introductory usage explanations and some operational details were removed.
- Kept core quick-reference tables for common Excel automation scripts and their parameters.
- Core technical stack, dependency, code snippets, and tool script listings retained.
- General instructions and examples streamlined for easier access.
v0.1.1
## automate-excel 0.1.1
- No changes detected in this version.
- All features, documentation, and usage instructions remain the same as the previous release.
v0.1.0
- Initial release of automate-excel skill for automated processing of Excel files.
- Supports reading, writing, merging, transforming, and validating .xlsx/.xls files and CSV-to-Excel conversion.
- Provides command-line scripts for common Excel tasks: merging sheets/files, filtering, splitting, deduplication, aggregation, validation, column selection/renaming, VLOOKUP-style join, transpose, template filling, sheet renaming, conditional formatting, and text formatting for columns.
- Utilizes openpyxl and pandas for Excel data management; scripts can be run standalone or via the skill system.
- Includes usage guides, technical notes, and best practices for error handling and batch processing.
Metadata
Frequently Asked Questions
What is Automate Excel?
Automates reading, writing, merging, transforming, and validating Excel (.xlsx/.xls) files. Use when the user works with spreadsheets, .xlsx files, Excel dat... It is an AI Agent Skill for Claude Code / OpenClaw, with 8250 downloads so far.
How do I install Automate Excel?
Run "/install automate-excel" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Automate Excel free?
Yes, Automate Excel is completely free (open-source). You can download, install and use it at no cost.
Which platforms does Automate Excel support?
Automate Excel is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Automate Excel?
It is built and maintained by zway (@zways); the current version is v0.1.3.
More Skills