skills.rest
ruuxi
ruuxiCOMMUNITY
Explore all skills by this author →
GitHub

officecli-data-dashboard

Convert CSV data into Excel dashboards with live-linked KPIs and charts.

29|4|Updated Mar 18, 2026
Search Tags:#data visualization#automated reporting#kpi reporting#officecli#excel dashboard#csv to excel#dashboard creation
One-click install
npx skills add https://github.com/ruuxi/stella --skill officecli-data-dashboard-ruuxi
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: officecli-data-dashboard
Source: https://github.com/ruuxi/stella/tree/main/desktop/stella-office/vendor/officecli/skills/officecli-data-dashboard
Command: npx skills add https://github.com/ruuxi/stella --skill officecli-data-dashboard-ruuxi

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually building Excel dashboards is time-consuming, requires advanced Excel formula and charting knowledge, and often produces static reports that break when underlying source data changes, leading to hours of repetitive rework.

Core Features & Use Cases

  • Formula-Driven KPIs: All dashboard metrics auto-update when source data changes, with no hardcoded calculated values.
  • Linked Charts & Visualizations: Charts, sparklines, and conditional formatting stay synced to raw data for real-time visual insights.
  • Polished Output: Delivers a single professional .xlsx file with a dedicated active Dashboard sheet, preset styling, and quality-validated formatting.
  • Use Case: A sales analyst can upload a CSV of monthly sales data to instantly generate an executive-ready dashboard with total revenue, growth rate KPIs, and trend charts, no manual Excel formatting required.

Quick Start

Use this skill to turn your attached monthly sales CSV file into a formatted Excel dashboard with live KPIs and trend 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 a CSV file automatically?▼

You can create an Excel dashboard from a CSV file by uploading your raw tabular data, which transforms into a professional .xlsx file with live-linked KPIs, charts, and conditional formatting in seconds.

Can I generate live KPI reporting in Excel that updates when source data changes?▼

Yes, live KPI reporting in Excel uses formula-driven metrics that auto-recalculate. This ensures your dashboard updates automatically when the underlying source data changes, avoiding hardcoded values.

What is the best way to build automated reporting for sales performance tracking?▼

The best way to build automated reporting for sales performance tracking is generating a single .xlsx file with auto-recalculating formulas, preset chart styling, and trend charts from your raw CSV data.

Does this dashboard creation approach work for large datasets?▼

Yes, this dashboard creation approach works for datasets of any size. It transforms raw CSV or tabular data into a dedicated active Dashboard sheet with quality-validated formatting and synced visualizations.

Why do my manually built Excel dashboards break when I update the source data?▼

Manually built Excel dashboards break because they often use hardcoded calculated values instead of formula-driven metrics. Using linked charts and auto-recalculating formulas prevents this repetitive rework.

Do I need advanced Excel formula knowledge to generate executive summaries from CSV data?▼

No, you do not need advanced Excel formula knowledge to generate executive summaries. The process automatically applies preset chart styling, conditional formatting, and live-linked KPIs to your raw data.

Related Skills

Explore More Data & Analytics Skills→
thtskaranthtskaran
16

xlsx

Repair and update .xlsx, .xlsm, CSV, and TSV files with Excel formulas.

Community
Advanced
coreymaypraycoreymaypray
1

Data Analytics Reporter

Transform Supabase and Stripe data into KPI dashboards and revenue analytics.

Community
Advanced
LeandroBenjaminLLeandroBenjaminL

data-visualization

Create charts with Matplotlib, Seaborn, and Plotly for data analysis.

Community
Intermediate
bcastelinobcastelino
2

business-analyst

Analyze business data and create dashboards with Tableau and Power BI.

Community
Advanced