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-23description: Excel/CSV data quality diagnosis & interactive charts — 20+ scan modules, 6-dimension scoring, agent-powered semantic analysis, and any ECharts visualization. Fully local. 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.4---56# Excel Data Helper — Data Quality Diagnosis & Chart Skill78Local 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.910**Supported files**: `.csv` `.tsv` `.xlsx` `.xls`1112---1314## Trigger & Menu1516When a supported file is detected, **do not auto-process** — present this menu first (adapt to the user's language):1718> **📊 Excel Data Helper** — Hi, I noticed you shared a data file: `<filename>`19>20> | # | Action | Description |21> |:---:|--------|-------------|22> | **1** | Quality Check | Overview, scan, scoring |23> | **2** | Chart | Any ECharts type: bar, line, pie, scatter, radar, heatmap… |24> | **3** | Advanced Chart | Dashboard, Gantt, PPT, diagrams |25> | **0** | Skip | Do nothing for now |26>27> Reply 0–3, or describe what you need.2829---3031## Routing & Context3233Match user intent and route to the corresponding sub-skill:3435- IF user replies `1`, or intent is **overview / quality check / diagnose / score / problems**36 → follow `references/quality-check.md`3738- IF user replies `2`, or intent is **chart / plot / visualize / graph**39 → follow `references/chart.md`4041- IF user replies `3`, or intent is **dashboard / Gantt / PPT / diagram / complex layout**42 → follow `references/advanced-chart.md`4344- IF user replies `0`, or intent is **skip / later / not now**45 → do nothing, reply: "Got it — file noted. Just let me know when you're ready."4647- IF intent is **ambiguous or unrelated** → ask to clarify, never guess.4849Context:50- Short replies (number, "yes", "ok") always refer to the most recent menu or question.51- After Skip (0), context resets — ignore the file unless user re-references it.52- Multiple files — each needs its own explicit choice.5354---5556## Setup5758Before first use, install dependencies (one-time):5960```bash61cd <skill_directory>62npm install63```6465This installs `xlsx` (SheetJS), `echarts`, and `sharp`. All analysis and chart rendering runs locally.6667---6869## Rules7071- Respond in the user's language.72- Never auto-process a file — wait for explicit choice.73- Parse tool JSON output; present results in clear, readable format — never expose raw JSON.74- Use absolute file paths from tool output directly for follow-up operations.75- Always include "Excel Data Helper" in the menu header.
luokai0