← Back to Skills Marketplace
chartgen-ai

Excel Data Quality Check

by ChartGen AI · GitHub ↗ · v1.0.0 · MIT-0
cross-platform ✓ Security Clean
232
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install excel-data-quality
Description
Excel/CSV data quality diagnosis & interactive charts — 20+ scan modules, 6-dimension scoring, agent-powered semantic analysis, and any ECharts visualization...
README (SKILL.md)

\r \r

Excel Data Helper — Data Quality Diagnosis & Chart Skill\r

\r Local Excel/CSV data profiling, quality scanning (20+ modules, 6-dimension scoring, LLM semantic analysis), and chart generation. International locale support: CJK, European, Middle Eastern, Americas.\r \r Supported files: .csv .tsv .xlsx .xls\r \r ---\r \r

Trigger & Menu\r

\r When a supported file is detected, do not auto-process — present this menu first (adapt to the user's language):\r \r

📊 Excel Data Helper — Hi, I noticed you shared a data file: \x3Cfilename>\r \r | # | Action | Description |\r |:---:|--------|-------------|\r | 1 | Quality Check | Overview, scan, scoring |\r | 2 | Chart | Any ECharts type: bar, line, pie, scatter, radar, heatmap… |\r | 3 | Advanced Chart | Dashboard, Gantt, PPT, diagrams |\r | 0 | Skip | Do nothing for now |\r \r Reply 0–3, or describe what you need.\r \r ---\r \r

Routing & Context\r

\r Match user intent and route to the corresponding sub-skill:\r \r

  • IF user replies 1, or intent is overview / quality check / diagnose / score / problems\r → follow references/quality-check.md\r \r
  • IF user replies 2, or intent is chart / plot / visualize / graph\r → follow references/chart.md\r \r
  • IF user replies 3, or intent is dashboard / Gantt / PPT / diagram / complex layout\r → follow references/advanced-chart.md\r \r
  • IF user replies 0, or intent is skip / later / not now\r → do nothing, reply: "Got it — file noted. Just let me know when you're ready."\r \r
  • IF intent is ambiguous or unrelated → ask to clarify, never guess.\r \r Context:\r
  • Short replies (number, "yes", "ok") always refer to the most recent menu or question.\r
  • After Skip (0), context resets — ignore the file unless user re-references it.\r
  • Multiple files — each needs its own explicit choice.\r \r ---\r \r

Setup\r

\r Before first use, install dependencies (one-time):\r \r

cd \x3Cskill_directory>\r
npm install\r
```\r
\r
This installs `xlsx` (SheetJS), `echarts`, and `sharp`. All analysis and chart rendering runs locally.\r
\r
---\r
\r
## Rules\r
\r
- Respond in the user's language.\r
- Never auto-process a file — wait for explicit choice.\r
- Parse tool JSON output; present results in clear, readable format — never expose raw JSON.\r
- Use absolute file paths from tool output directly for follow-up operations.\r
- Always include "Excel Data Helper" in the menu header.\r
Usage Guidance
This skill appears to be what it claims: a local Excel/CSV profiler and ECharts renderer. Before installing or running it: (1) review the repository and package.json (if present) before running npm install to ensure there are no unexpected install scripts; (2) be aware the skill's instructions tell the agent to present itself automatically when a supported file is uploaded/mentioned and (per chart instructions) to render charts immediately once planned — if you prefer an explicit confirmation step, adjust the skill or avoid using the automatic trigger; (3) advanced/dashboard features delegate to a ChartGen skill which requires an API key and external service — that delegation is optional and only used if you enable/install ChartGen; (4) all processing appears local (no hidden network calls) based on the provided files, but if you have strict data-exfiltration policies, run the tools in an isolated environment or review any omitted files (utils, remaining scanner/scorer code) before use.
Capability Analysis
Type: OpenClaw Skill Name: excel-data-quality Version: 1.0.0 The skill bundle is a comprehensive and well-structured tool for local Excel and CSV data quality analysis and visualization. It utilizes standard Node.js libraries such as SheetJS (xlsx), ECharts, and Sharp to perform deep data profiling and render charts without external API dependencies. The logic across the 22 scanning modules (in tools/lib/scanner.js) and the scoring system (in tools/lib/scorer.js) is consistent with the stated purpose of data diagnostics. The instructions in SKILL.md and the reference markdown files provide a structured workflow for the AI agent to act as a data analyst, and no evidence of data exfiltration, malicious execution, or harmful prompt injection was found.
Capability Assessment
Purpose & Capability
The name/description (data profiling, scoring, and ECharts rendering) matches the included tools (parser, profiler, scanner, chart_renderer). Node runtime and npm dependencies (xlsx, echarts, sharp) are reasonable and documented in README/SKILL.md. No unrelated credentials, binaries, or config paths are requested.
Instruction Scope
Runtime instructions stay within the declared purpose (present menu on file detection, run local CLI tools to profile/render) but contain some user-experience choices to be aware of: SKILL.md instructs the agent to 'activate whenever the user uploads/mentions' a supported file and to 'present the skill menu immediately', and chart.md Step 2 mandates rendering planned charts immediately ('do NOT ask for confirmation first'). Those are behavioral decisions (privacy/UX) rather than technical inconsistencies, but they could surprise users who expect the agent to wait for an explicit request before operating on uploaded files.
Install Mechanism
No automated install spec in the registry; the SKILL.md instructs a one-time manual 'npm install' to fetch well-known packages (xlsx, echarts, sharp). This is proportionate given the Node code included. There are no downloads from unknown URLs or extract operations in the manifest.
Credentials
The skill declares no required environment variables, no primary credential, and no config paths. The only external delegation (advanced charts) optionally calls an external ChartGen skill that requires its own API key; that is documented and optional.
Persistence & Privilege
The skill does not request always:true and does not modify other skills or system-wide settings in the provided files. It does include instructions to write generated PNG files locally (chart tool) which is expected for chart rendering.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install excel-data-quality
  3. After installation, invoke the skill by name or use /excel-data-quality
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
- Initial release of Excel Data Helper — perform local Excel/CSV data profiling, quality scanning, and chart generation with international language support. - Supports `.csv`, `.tsv`, `.xlsx`, and `.xls` files. - On file detection, shows a clear menu for quality check, chart creation, advanced charts, or skipping. - 20+ quality scan modules, 6-dimension scoring, and agent-assisted semantic analysis. - User must select an action before processing; no automatic file handling. - All analysis and chart rendering is performed locally—no data leaves your device.
Metadata
Slug excel-data-quality
Version 1.0.0
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 1
Frequently Asked Questions

What is Excel Data Quality Check?

Excel/CSV data quality diagnosis & interactive charts — 20+ scan modules, 6-dimension scoring, agent-powered semantic analysis, and any ECharts visualization... It is an AI Agent Skill for Claude Code / OpenClaw, with 232 downloads so far.

How do I install Excel Data Quality Check?

Run "/install excel-data-quality" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Excel Data Quality Check free?

Yes, Excel Data Quality Check is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does Excel Data Quality Check support?

Excel Data Quality Check is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Excel Data Quality Check?

It is built and maintained by ChartGen AI (@chartgen-ai); the current version is v1.0.0.

💬 Comments