Official Verified data analysis Safety 5/5

excel-data-helper

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.

skill-install — Terminal

Install via CLI (Recommended)

clawhub install openclaw/skills/skills/chartgen-ai/excel-data-quality

Download Source Code (.zip)

What This Skill Does

The Excel Data Helper is a powerful, local-first analytical toolkit designed for OpenClaw users to interface with spreadsheet data. It transforms raw .csv, .xlsx, .xls, and .tsv files into actionable intelligence. By leveraging a suite of over 20 scanning modules, the skill performs a deep-dive data quality diagnosis, evaluating information across six core dimensions including consistency, completeness, and accuracy.

Beyond mere diagnosis, it acts as an intelligent bridge to visualization. Users can generate highly customized ECharts—ranging from standard bar and line graphs to complex radar and heatmaps—entirely within their local environment. The agent-powered semantic analysis ensures that the output is not just a visual representation, but an intelligent synthesis of the data structure. It is designed to be privacy-first, ensuring that no data is transmitted to external servers.

Installation

To integrate this skill into your OpenClaw environment, ensure you have the necessary permissions and run the following command in your terminal: clawhub install openclaw/skills/skills/chartgen-ai/excel-data-quality

Once installed, navigate to the skill directory and finalize the setup by installing the required npm dependencies: cd <skill_directory> && npm install This one-time setup configures the necessary libraries (SheetJS, ECharts, and Sharp) required for robust data parsing and image rendering.

Use Cases

Data Cleaning: Identifying anomalies, duplicates, and missing values in large datasets before importing them into production databases.
Business Intelligence: Quickly generating visual representations of sales trends, project timelines, or KPI metrics directly from raw file uploads.
Academic & Research: Performing statistical profiling and visualizing research data to discover patterns without needing external spreadsheet software.
Workflow Automation: Streamlining the document review process by having an AI assistant perform the initial quality scan and chart generation for every incoming file.

Example Prompts

"Can you help me diagnose the data quality of this sales_report.csv and point out any empty fields?"
"I've uploaded my project tracker. Please generate a timeline Gantt chart for the team."
"Run a full quality check on this dataset and then create a heatmap showing the correlation between ad spend and conversions."

Tips & Limitations

Manual Trigger: The skill is designed to wait for your command. It will not auto-process files, so always reply with a menu choice (0-3) to begin.
Local Privacy: Since all analysis occurs locally, large files might temporarily consume significant CPU during high-intensity scanning. For files exceeding 50MB, ensure your machine has sufficient RAM.
Context Handling: If you are working with multiple files, address them one by one to ensure accurate routing of analysis tasks.

Read Full Documentation on GitHub

Metadata

Author@chartgen-ai

Stars3875

Updated2026-04-07

View Author Profile

AI Skill Finder

Not sure this is the right skill?

Describe what you want to build — we'll match you to the best skill from 16,000+ options.

Find the right skill

Add to Configuration

Paste this into your clawhub.json to enable this plugin.

{
  "plugins": {
    "official-chartgen-ai-excel-data-quality": {
      "enabled": true,
      "auto_update": true
    }
  }
}

Tags(AI)

#data-analysis#excel#visualization#automation#local-ai

Safety Score: 5/5

Flags: file-read, file-write, code-execution

Related Skills

data-analysis-pro

Data analysis pro skill providing three core functions: data analysis, data interpretation, and data visualization. **Use Cases**: (1) Data Analysis - Statistics, filtering, aggregation, calculation (e.g., "Calculate total sales", "Filter data greater than 100") (2) Data Interpretation - Trend analysis, pattern discovery, report generation (e.g., "Analyze sales trends", "Interpret data changes") (3) Data Visualization - Chart generation, data display (e.g., "Draw a bar chart", "Generate a pie chart") **Trigger Keywords**: analyze data, statistics, calculate, interpret trends, generate chart, visualize, plot **Prerequisites**: Set environment variable CHARTGEN_API_KEY (obtain from chartgen.ai)

chartgen-ai 3875

chartgen

Use this skill when the user wants to create visualizations (charts, dashboards, diagrams, Gantt, PPT), analyze data (Excel/CSV upload, cross-file analysis, trends, outliers) or generate reports. Also use when the user mentions ChartGen or uploads spreadsheet files.

chartgen-ai 3875

chartgen

Chartgen skill providing three core functions: data analysis, data interpretation, and data visualization. **Use Cases**: (1) Data Analysis - Statistics, filtering, aggregation, calculation (e.g., "Calculate total sales", "Filter data greater than 100") (2) Data Interpretation - Trend analysis, pattern discovery, report generation (e.g., "Analyze sales trends", "Interpret data changes") (3) Data Visualization - Chart generation, data display (e.g., "Draw a bar chart", "Generate a pie chart") **Trigger Keywords**: analyze data, statistics, calculate, interpret trends, generate chart, visualize, plot **Prerequisites**: Set environment variable CHARTGEN_API_KEY (obtain from chartgen.ai)

chartgen-ai 3875

chartgen

chartgen-ai 3875

chartgen

chartgen-ai 3875