A comprehensive local tool for diagnosing data quality and generating interactive ECharts visualizations from Excel and CSV files.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install excel-data-quality
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install excel-data-quality using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Excel Data Helper?
Excel Data Helper is a powerful addition to the Openclaw Skills ecosystem designed for developers and data analysts who need quick, local insights into their datasets. It automatically detects uploaded data files and offers an interactive menu for quality diagnosis, scoring, and professional-grade chart generation. By leveraging LLM-powered semantic analysis alongside traditional profiling, it identifies issues across six dimensions of data quality.
Unlike cloud-based solutions, this skill operates entirely locally, ensuring your sensitive business data remains secure. It supports a wide range of formats including .xlsx, .xls, .csv, and .tsv, making it a versatile tool for any data-driven workflow within your agentic environment. This integration ensures that every file you upload is met with an intelligent assistant ready to transform raw rows into meaningful visualizations.
Excel Data Helper Use Cases
- Auditing raw CSV data for missing values, inconsistencies, or formatting errors using automated scan modules.
- Generating interactive ECharts visualizations such as bar, line, or radar charts directly within your agent workflow.
- Creating advanced project management dashboards, Gantt charts, or PPT-ready diagrams from local spreadsheets.
- Scoring dataset reliability and identifying semantic anomalies using 20+ specialized scan modules.
How Excel Data Helper Works
- The skill monitors for file uploads and triggers automatically when it detects supported formats like .xlsx, .xls, .csv, or .tsv.
- It presents an interactive menu to the user, offering options for Quality Check, basic Charts, or Advanced Dashboarding without auto-processing the file.
- Upon selection, the agent utilizes local libraries like SheetJS and ECharts to process the file and generate visual or textual reports based on the user's intent.
- LLM semantic analysis is applied to provide deeper insights into the data context and potential anomalies during the quality check phase.
- Results are rendered locally and displayed in a human-readable format, utilizing absolute file paths for follow-up operations.
Excel Data Helper Setup
To integrate this into your environment, navigate to the skill directory and install the necessary local dependencies. Ensure you have Node.js version 14 or higher installed to handle the SheetJS and ECharts components of this Openclaw Skills package.
cd <skill_directory>
npm install
Excel Data Helper Data Schema & Taxonomy
The skill organizes data using standard tabular structures and generates metadata based on its 6-dimension scoring model.
| Attribute | Specification |
|---|---|
| Input Formats | .csv, .tsv, .xlsx, .xls |
| Analysis Engine | 20+ scan modules with 6-dimension scoring |
| Visual Engines | ECharts for interactive graphs, Sharp for rendering |
| Local Files | Processes data locally using absolute file paths |
Excel Data Helper Advanced Features
- Agent-powered semantic analysis for identifying context-specific data errors that traditional scripts might miss.
- Multi-agent support for creating complex layouts including Gantt charts, dashboards, and automated PPT diagrams.
- Robust international locale support including CJK, European, Middle Eastern, and American character sets.
- Privacy-first local execution requiring no external API calls for data processing or chart rendering.
- Intent-based routing that intelligently maps user replies to specific quality check or visualization sub-skills.
SKILL.md
Loading
Related Openclaw Skills
Cisco AI Skill Scanner
A robust security auditing tool designed to detect prompt injection, data exfiltration, and malicious code patterns in AI agent skills.
md2pdf
A high-performance CLI tool for converting Markdown documents into beautifully formatted PDFs using Pandoc and Typst.
Prometheus Monitoring
A powerful skill to query Prometheus monitoring metrics, alerts, and cluster health directly through an AI agent.
Hello World Skill
A minimal custom skill designed to provide friendly, multi-lingual greetings and serve as a baseline for testing AI agent extensions.
Monarch Money
A command-line integration for Monarch Money that allows AI agents to query account balances, transactions, and budget performance.
Communication Master
Communication Master is an AI-powered coach designed to help users navigate difficult conversations, set healthy boundaries, and practice nonviolent communication.
Featured*
