← Back to Skills Marketplace
Excel Batch Processor
by
bingze00000
· GitHub ↗
· v1.0.0
· MIT-0
255
Downloads
0
Stars
2
Active Installs
1
Versions
Install in OpenClaw
/install excel-batch-processor
Description
Automate batch Excel tasks including merging, splitting, format conversion, data cleaning, deduplication, and bulk formula filling with wildcard support.
README (SKILL.md)
Excel Batch Processor - Excel 批量处理工具
功能描述
批量处理 Excel 文件的自动化工具,支持合并、拆分、格式转换、数据清洗等操作。
使用场景
- 多个 Excel 文件合并为一个
- 大文件拆分为多个小文件
- Excel 与 CSV 互相转换
- 批量修改单元格格式
- 数据清洗和去重
- 公式批量填充
命令
合并文件
合并 Excel 文件列表=file1.xlsx,file2.xlsx,file3.xlsx 输出=merged.xlsx
拆分文件
拆分 Excel 文件=source.xlsx 按=工作表 输出目录=./output
格式转换
转换 Excel 到 CSV 文件=input.xlsx 输出目录=./output
数据清洗
清洗 Excel 文件=input.xlsx 操作=去重,删除空行 输出=cleaned.xlsx
批量填充
批量填充 Excel 文件=*.xlsx 单元格=A1 值=公司名称 输出目录=./output
输出格式
- Excel (.xlsx)
- CSV (.csv)
特性
- 支持通配符批量处理
- 保持原有公式和格式
- 大文件优化处理
- 错误自动跳过
Usage Guidance
This skill appears to do what it says (Excel batch operations) but there are two practical risks: (1) provenance — there's no homepage/source repo or install spec, so you can't verify the author or code; (2) missing install instructions — the metadata lists Python libraries but doesn't say how/when they'll be installed, so an agent or you may need to install them manually or the agent could attempt to run pip installs. Before installing or using: 1) ask the publisher for a source repository or packaged installer and concrete runtime instructions; 2) prefer running any tooling locally on copies of your files (not originals) and in an isolated environment (virtualenv or container); 3) if the agent offers to auto-install packages, inspect the exact commands it will run; 4) avoid processing sensitive data until you can verify the code; and 5) consider requesting a sample of the actual implementation (script or binary) to review or run in a sandbox.
Capability Analysis
Type: OpenClaw Skill
Name: excel-batch-processor
Version: 1.0.0
The skill bundle contains only metadata and documentation (SKILL.md) for an Excel batch processing tool. There is no executable code provided, and the instructions in SKILL.md are consistent with the stated purpose of merging, splitting, and cleaning Excel files without any signs of prompt injection or malicious intent.
Capability Assessment
Purpose & Capability
Name, description, and SKILL.md describe Excel merging/splitting/cleaning which coherently maps to the declared dependencies (openpyxl, pandas) in _meta.json. Functionality requested (wildcards, CSV conversion, large-file optimizations) is consistent with a tool that would use those libraries.
Instruction Scope
SKILL.md is an instruction-only document (Chinese), showing example command formats for merge/split/convert/clean/fill and references only local files and output directories. It does not instruct reading unrelated system files or sending data to external endpoints. However the instructions are high-level and vague (no concrete runtime program to invoke), which gives an agent broad discretion about how to achieve tasks.
Install Mechanism
_meta.json lists requirements (openpyxl, pandas) but there is no install specification and no code files. That mismatch is concerning: it's unclear who installs or supplies the runtime. The agent or user may end up needing to install third-party packages manually or the agent might attempt to pip-install them at runtime — the provenance of any code the agent would execute is unspecified. No homepage or source repo is provided to verify the publisher or package integrity.
Credentials
The skill requests no environment variables, credentials, or config paths. For a local file-processing tool, the absence of secret/credential requests is appropriate.
Persistence & Privilege
Skill is instruction-only, no install actions are declared, always:false, and it does not request elevated or persistent platform privileges. Nothing in the package requests autonomous persistence beyond normal agent invocation.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install excel-batch-processor - After installation, invoke the skill by name or use
/excel-batch-processor - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release of Excel Batch Processor.
- Automates batch processing of Excel files, including merging, splitting, format conversion, data cleansing, and bulk editing.
- Supports merging multiple files, splitting large files, converting between Excel and CSV, bulk format changes, deduplication, and batch formula filling.
- Command-driven usage for each function.
- Handles batch operations with wildcard support, preserves formulas and formats, optimizes for large files, and auto-skips errors.
- Outputs in Excel (.xlsx) and CSV (.csv) formats.
Metadata
Frequently Asked Questions
What is Excel Batch Processor?
Automate batch Excel tasks including merging, splitting, format conversion, data cleaning, deduplication, and bulk formula filling with wildcard support. It is an AI Agent Skill for Claude Code / OpenClaw, with 255 downloads so far.
How do I install Excel Batch Processor?
Run "/install excel-batch-processor" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Excel Batch Processor free?
Yes, Excel Batch Processor is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Excel Batch Processor support?
Excel Batch Processor is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Excel Batch Processor?
It is built and maintained by bingze00000 (@bingze00000); the current version is v1.0.0.
More Skills