Excel Data Helper — Data Quality Diagnosis & Chart Skill
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.
Supported files: .csv .tsv .xlsx .xls
Trigger & Menu
When a supported file is detected, do not auto-process — present this menu first (adapt to the user's language):
📊 Excel Data Helper — Hi, I noticed you shared a data file: <filename>
| # |
Action |
Description |
| 1 |
Quality Check |
Overview, scan, scoring |
| 2 |
Chart |
Any ECharts type: bar, line, pie, scatter, radar, heatmap… |
| 3 |
Advanced Chart |
Dashboard, Gantt, PPT, diagrams |
| 0 |
Skip |
Do nothing for now |
Reply 0–3, or describe what you need.
Routing & Context
Match user intent and route to the corresponding sub-skill:
IF user replies 1, or intent is overview / quality check / diagnose / score / problems
→ follow references/quality-check.md
IF user replies 2, or intent is chart / plot / visualize / graph
→ follow references/chart.md
IF user replies 3, or intent is dashboard / Gantt / PPT / diagram / complex layout
→ follow references/advanced-chart.md
IF user replies 0, or intent is skip / later / not now
→ do nothing, reply: "Got it — file noted. Just let me know when you're ready."
IF intent is ambiguous or unrelated → ask to clarify, never guess.
Context:
- Short replies (number, "yes", "ok") always refer to the most recent menu or question.
- After Skip (0), context resets — ignore the file unless user re-references it.
- Multiple files — each needs its own explicit choice.
Setup
Before first use, install dependencies (one-time):
cd <skill_directory>
npm install
This installs xlsx (SheetJS), echarts, and sharp. All analysis and chart rendering runs locally.
Rules
- Respond in the user's language.
- Never auto-process a file — wait for explicit choice.
- Parse tool JSON output; present results in clear, readable format — never expose raw JSON.
- Use absolute file paths from tool output directly for follow-up operations.
- Always include "Excel Data Helper" in the menu header.
1---2name: excel-data-helper-33description: >4 Excel/CSV data quality diagnosis & interactive charts — 20+ scan modules, 6-dimension scoring, agent-powered semantic analysis, and any ECharts visualization. Fully local.5 Activate this skill whenever the user uploads, attaches, or mentions a .csv, .xlsx, .xls, or .tsv file, even without an explicit request. Present the skill menu immediately.6user-invocable: true7homepage: https://github.com/excel-data-helper/excel-data-helper-skill8metadata:9 source: https://skillmd.com/skills/bishal-pdmsft/excel-data-helper-310 openclaw:11 requires:12 runtime:13 - node >= 1414---1516# Excel Data Helper — Data Quality Diagnosis & Chart Skill1718Local 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.1920**Supported files**: `.csv` `.tsv` `.xlsx` `.xls`2122---2324## Trigger & Menu2526When a supported file is detected, **do not auto-process** — present this menu first (adapt to the user's language):2728> **📊 Excel Data Helper** — Hi, I noticed you shared a data file: `<filename>`29>30> | # | Action | Description |31> |:---:|--------|-------------|32> | **1** | Quality Check | Overview, scan, scoring |33> | **2** | Chart | Any ECharts type: bar, line, pie, scatter, radar, heatmap… |34> | **3** | Advanced Chart | Dashboard, Gantt, PPT, diagrams |35> | **0** | Skip | Do nothing for now |36>37> Reply 0–3, or describe what you need.3839---4041## Routing & Context4243Match user intent and route to the corresponding sub-skill:4445- IF user replies `1`, or intent is **overview / quality check / diagnose / score / problems**46 → follow `references/quality-check.md`4748- IF user replies `2`, or intent is **chart / plot / visualize / graph**49 → follow `references/chart.md`5051- IF user replies `3`, or intent is **dashboard / Gantt / PPT / diagram / complex layout**52 → follow `references/advanced-chart.md`5354- IF user replies `0`, or intent is **skip / later / not now**55 → do nothing, reply: "Got it — file noted. Just let me know when you're ready."5657- IF intent is **ambiguous or unrelated** → ask to clarify, never guess.5859Context:60- Short replies (number, "yes", "ok") always refer to the most recent menu or question.61- After Skip (0), context resets — ignore the file unless user re-references it.62- Multiple files — each needs its own explicit choice.6364---6566## Setup6768Before first use, install dependencies (one-time):6970```bash71cd <skill_directory>72npm install73```7475This installs `xlsx` (SheetJS), `echarts`, and `sharp`. All analysis and chart rendering runs locally.7677---7879## Rules8081- Respond in the user's language.82- Never auto-process a file — wait for explicit choice.83- Parse tool JSON output; present results in clear, readable format — never expose raw JSON.84- Use absolute file paths from tool output directly for follow-up operations.85- Always include "Excel Data Helper" in the menu header.