skills.rest
gaogg521
gaogg521COMMUNITY
Explore all skills by this author →
GitHub

officecli-data-dashboard

Convert CSV input into a two-sheet .xlsx workbook with a KPI Dashboard.

33|6|Updated Apr 8, 2026
Search Tags:#automation#dashboard#visualization#excel#csv#kpi#business-intelligence
One-click install
npx skills add https://github.com/gaogg521/1ONE-ClaudeCode --skill officecli-data-dashboard-gaogg521
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: officecli-data-dashboard
Source: https://github.com/gaogg521/1ONE-ClaudeCode/tree/main/src/process/resources/skills/officecli-data-dashboard
Command: npx skills add https://github.com/gaogg521/1ONE-ClaudeCode --skill officecli-data-dashboard-gaogg521

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps data teams and analysts quickly build polished Excel dashboards from CSV or tabular data, eliminating manual data wrangling and formatting steps.

Core Features & Use Cases

  • Two-sheet workbook: one for raw data and one for an interactive KPI Dashboard with charts and sparklines.
  • Formula-driven KPIs: dashboards update automatically when the data sheet changes.
  • Flexible input: supports CSV or any tabular data and outputs a single .xlsx file ready for sharing.

Quick Start

Feed a CSV file to the skill and it will generate a two-sheet Excel workbook with a Data sheet and a KPI Dashboard.

Frequently Asked Questions about officecli-data-dashboard

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create an Excel dashboard from a CSV file?▼

To create an Excel dashboard from a CSV file, you input the tabular data and the tool generates a two-sheet workbook with a raw data sheet and a KPI-driven dashboard featuring charts and conditional formatting.

Can I generate KPIs and sparklines directly from tabular data?▼

Yes, you can generate KPIs and sparklines from tabular data. The output workbook includes formula-driven KPIs and a dashboard sheet that update automatically when the raw data changes.

Does this approach support conditional formatting for business intelligence visualization?▼

This approach supports conditional formatting for business intelligence visualization. The generated dashboard sheet includes charts, sparklines, and conditional formatting to deliver quick data insights.

What is the best way to automate building a two-sheet Excel workbook with raw data and dashboards?▼

The best way to automate building this workbook is to feed a CSV file into the skill. It outputs a single .xlsx file containing both the raw data and a ready-to-deliver KPI dashboard.

Will the KPIs in the generated Excel dashboard update if the data changes?▼

The KPIs in the generated Excel dashboard will update if the data changes. The dashboard relies on formula-driven KPIs that automatically recalculate when the underlying data sheet is modified.

Are there limitations when turning CSV data into an Excel dashboard?▼

A key limitation is that the process requires a CSV file as input and outputs a single .xlsx file. It is designed for tabular data, so non-tabular formats are not supported.

Related Skills

Explore More Data & Analytics Skills→
coval-aicoval-ai
2

huggingface-import

Import HuggingFace datasets into structured CSV files for Coval.

Official
Intermediate
IsKenKenYaIsKenKenYa

Excel Analysis

Analyze Excel spreadsheets by importing data, cleaning it, and generating pivot tables and charts.

Community
Intermediate
spqwspqw

observable-framework-lib-arquero

Transform and analyze tabular data with Arquero in Observable Framework.

Community
Intermediate
Mohamed-ElkahefMohamed-Elkahef

csv-data-visualizer

Generate interactive Plotly visualizations and statistical profiles from CSV datasets.

Community
Intermediate