← Back to Skills Marketplace
excel-clean
by
Martin-SH-Ni
· GitHub ↗
· v1.0.0
· MIT-0
97
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install excel-clean
Description
Clean Excel data — deduplication, fill missing values, format conversion.
README (SKILL.md)
Excel Cleaner（Excel数据清洗）
去重 / 空值填充 / 格式转换 | Pandas驱动
功能 | Features
- ✅ 批量去重 — 按指定列组合去重
- ✅ 空值填充 — 支持填充固定值、前值、后值
- ✅ 格式转换 — 数值/文本/日期格式互转
- ✅ 保留原文件 — 输出为
_cleaned.xlsx，原文件不变
使用场景 | Use Cases
| 场景 | 说明 |
|---|---|
| 名单去重 | 删除重复客户/订单记录 |
| 数据补全 | 用"未知"或0填充空值 |
| 格式标准化 | 日期统一为 YYYY-MM-DD |
使用方式 | Usage
输入参数:
file_path Excel文件路径
dedup_cols 去重列名列表（可选）
fill_value 空值填充内容（可选）
convert_type 格式类型转换（可选）
输出:
success 是否成功
output 输出文件路径
rows 处理后行数
示例 | Example
result = excel_clean(
file_path="/data/orders.xlsx",
dedup_cols=["订单号", "手机号"],
fill_value="未知",
convert_type="日期:YYYY-MM-DD"
)
依赖 | Dependencies
pandas >= 1.3.0
openpyxl >= 3.0.0
版本 v1.0
Usage Guidance
This skill appears coherent for cleaning Excel files, but note it is instruction-only: it assumes a Python runtime with pandas and openpyxl are available (or that the agent will pip-install them). Before installing or running: confirm the agent/environment will run Python safely; verify where files are read from and written to (ensure the agent has only the filesystem access you expect); avoid processing sensitive spreadsheets with an agent you don't fully trust; if you need guarantees, ask the skill author for an explicit install script or a packaged implementation so you can review the exact code that will run.
Capability Analysis
Type: OpenClaw Skill
Name: excel-clean
Version: 1.0.0
The skill bundle describes a standard Excel data cleaning utility using Pandas and openpyxl. The documentation in SKILL.md and metadata in _meta.json are consistent with the stated purpose of deduplication and formatting, with no evidence of malicious instructions, data exfiltration, or suspicious execution patterns.
Capability Assessment
Purpose & Capability
Name/description (Excel cleaning) align with the SKILL.md operations (dedupe, fill, convert) and the listed dependencies (pandas, openpyxl). The requirements requested are proportionate to the stated purpose. One minor gap: the SKILL.md implies Python usage but the skill does not declare a Python runtime or install steps.
Instruction Scope
Instructions stay within scope: they describe reading an input Excel file, performing local transforms, and writing a _cleaned.xlsx output. The SKILL.md does not instruct reading unrelated files, accessing environment secrets, or transmitting data externally. It describes a function signature but provides no implementation code.
Install Mechanism
This is an instruction-only skill with no install spec. Dependencies are Python packages (pandas, openpyxl) — reasonable for the task, but the skill does not provide how/when those packages will be installed or whether a Python runtime is available.
Credentials
No environment variables, credentials, or config paths are requested. The skill does not ask for unrelated secrets or broad system access.
Persistence & Privilege
No elevated privileges requested: always:false and user-invocable:true. The skill does not request to modify other skills or system-wide settings.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install excel-clean - After installation, invoke the skill by name or use
/excel-clean - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
首发
Metadata
Frequently Asked Questions
What is excel-clean?
Clean Excel data — deduplication, fill missing values, format conversion. It is an AI Agent Skill for Claude Code / OpenClaw, with 97 downloads so far.
How do I install excel-clean?
Run "/install excel-clean" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is excel-clean free?
Yes, excel-clean is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does excel-clean support?
excel-clean is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created excel-clean?
It is built and maintained by Martin-SH-Ni (@martin-sh-ni); the current version is v1.0.0.
More Skills