OfficeCLI Data Dashboard Skill
Build multi-element Excel dashboards with KPI cards, charts, sparklines, and conditional formatting — no Office install required.
Skill emphasizes user confirmation and verification, but does not address privilege escalation, data exfiltration, or sensitive data handling. Deduction for potential remote code execution via curl|bash, though no malicious intent evidenced.
Skill claims end-to-end verification but static review cannot confirm. Has detailed gate checks but not exhaustive. Deduction for lack of automated tests and runtime verification.
Clearly defines applicable scenarios and triggers, but environment fit depends on GitHub/officecli.ai download which may be inaccessible from mainland China, no alternative provided. Deduction.
Well-structured documentation with examples and QA, but lacks version control, changelog, and clear maintenance responsibility. Deduction.
Claims to produce directly usable Excel dashboards, but static review cannot verify output quality; only self-reported validation. Deduction.
Only self-reported verification, lacks third-party independent validation or reproducible tests. Deduction.
- curl | bash piping in skill execution poses security risk; review installation scripts.
- Dependency on GitHub and officecli.ai for binary download may be inaccessible from mainland China; consider mirror or offline installation.
- Skill claims end-to-end validation but lacks reproducible test suite; users should verify outputs themselves.
- No data handling and privacy statement; ensure data security when using.
What does this skill do, and when should you use it?
This skill enables an AI agent to construct professional Excel dashboards from CSV or tabular input. It produces a single .xlsx file featuring a Dashboard sheet (opens first), multiple formula-driven KPI cards, multiple charts, sparklines, and conditional formatting. It layers on top of OfficeCLI, a free, open-source Office suite built for AI agents. It inherits strict rules from the underlying xlsx engine and adds dashboard-specific principles such as dashboard-first layout, visible-cell chart references, and full recalc on load.
Creates an Excel workbook with a Dashboard sheet that the user lands on first, several KPI cards each backed by a formula, charts that reference cell ranges, sparklines, and conditional formatting rules. It handles importing CSV or tabular data, sets the active tab and full calc on load, and applies print setup for board-ready outputs. It runs a rigorous QA cycle (8 gates) to verify formulas exist, charts are properly configured, no placeholders leak, and no visual defects like ### appear.
- A data analyst wants to turn a CSV export into an executive dashboard for a board pack.
- An operations manager needs a live ops console with KPIs and trend charts.
- A startup founder wants a scorecard tracking multiple metrics with sparklines.
- A financial analyst needs a dashboard visualizing budget vs actuals.
- An AI agent tasked with producing a polished, self-contained Excel deliverable without manual formatting.
What are this skill's strengths and limitations?
- No Office installation required; works as a single binary.
- Deterministic JSON output for AI agents, easy to automate.
- Includes strict quality gates to ensure deliverable completeness.
- Part of a larger open-source project with an active community and documentation.
- Supports a visual feedback loop via built-in HTML/PNG viewing.
- Requires network access to download the binary.
- No test suite mentioned; client environments may have undocumented issues.
- Known rendering regressions in LibreOffice for some chart types (e.g., pie chart blank).
- Heavy reliance on the OfficeCLI engine; no fallback implementation.
How do you install this skill?
- Install OfficeCLI: on macOS/Linux run
curl -fsSL https://d.officecli.ai/install.sh | bash, on Windows use PowerShell:irm https://d.officecli.ai/install.ps1 | iex. 2. Verify withofficecli --version. 3. This skill is part of the OfficeCLI repository; its SKILL.md can be used directly or fetched viaofficecli load_skill officecli-data-dashboard.
How do you use this skill?
Start with a prompt like 'create a KPI dashboard' or 'build a data visualization dashboard'. Ensure OfficeCLI is installed and verified. The skill guides the agent through phases: importing CSV, setting up the Dashboard sheet, adding KPI formulas, adding charts and sparklines, and finally running all quality and validation gates (formula checks, chart counts, placeholder scans).
How does this skill compare with similar options?
Compared to general-purpose spreadsheet tools like LibreOffice or Microsoft Excel, this skill is purpose-built for AI-agent automation, offering path-based access and JSON output. It is simpler than using libraries like python-openpyxl, which require extensive coding.