skills.rest
anthonyhtang
anthonyhtangCOMMUNITY
Explore all skills by this author →
GitHub

officecli-data-dashboard

Create an Excel dashboard workbook with KPI cards, sparklines, and charts from CSV data.

3|Updated Mar 30, 2026
Search Tags:#charts#dashboard#excel#csv#kpis#data-visualization#sparklines
One-click install
npx skills add https://github.com/anthonyhtang/OfficeCLI-enhanced-codex --skill officecli-data-dashboard-anthonyhtang
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: officecli-data-dashboard
Source: https://github.com/anthonyhtang/OfficeCLI-enhanced-codex/tree/main/skills/officecli-data-dashboard
Command: npx skills add https://github.com/anthonyhtang/OfficeCLI-enhanced-codex --skill officecli-data-dashboard-anthonyhtang

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Turns raw CSV/tabular data into a polished Excel dashboard with a dedicated Data sheet and a Dashboard sheet, delivering insight-ready visuals automatically.

Core Features & Use Cases

  • Formula-driven KPIs on the Dashboard sheet that reference the data sheet
  • Sparklines and charts linked to Sheet1 data for quick visual analysis
  • A guided workflow that imports data, builds KPI cards, and produces a ready-to-share workbook

Quick Start

Create a new workbook, import your CSV data, then run the guided steps to populate the Dashboard with KPIs, sparklines, and charts.

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 CSV data automatically?▼

You can build an Excel dashboard from CSV data by importing the tabular file into a new workbook and running a guided workflow that automatically generates a dedicated Dashboard sheet with KPI cards, sparklines, and linked charts.

What is the best way to visualize CSV data with KPI cards and sparklines in Excel?▼

The best way to visualize CSV data with KPI cards and sparklines is to use a structured approach that separates data and visuals into two sheets, applying formula-driven KPIs and cell-range referenced charts to ensure dynamic updates and accurate visual analysis.

Can I use formula-driven KPIs that reference a separate data sheet for my Excel dashboard?▼

Yes, you can use formula-driven KPIs that reference a separate data sheet. This best practice ensures your dashboard visuals and KPI cards dynamically pull calculated values directly from the raw data sheet, maintaining accuracy across the workbook.

Does the dashboard generation process include validation for Excel charts and formulas?▼

Yes, the dashboard generation process includes a final validation step. This step checks the automatically generated Excel charts, sparklines, and KPI formulas to ensure the cell-range references and calculated metrics are correctly applied before sharing.

How do I import CSV data and build a ready-to-share Excel workbook with charts?▼

You import CSV data into a new workbook and use a guided workflow to populate a dedicated Dashboard sheet. This process builds KPI cards, sparklines, and linked charts automatically, resulting in a polished, ready-to-share workbook.

Related Skills

Explore More Data & Analytics Skills→
XCmiaowXCmiaow

xlsx

Clean, edit, analyze, and generate Excel, CSV, and TSV spreadsheets with formula validation.

Community
Advanced
Casper-StudiosCasper-Studios
11

thats-my-quant

Analyze financial and RevOps data with structured workflows and Excel reports.

Official
Advanced
rangerrick337rangerrick337
10

xlsx

Automate Excel spreadsheet creation, editing, and analysis with formula integrity across .xlsx, .xlsm, .csv, and .tsv.

Community
Advanced
mhattingpetemhattingpete
657

dashboard-creator

Generate HTML dashboards with KPI cards, SVG charts, and data tables.

Community
Basic