excel-weekly-dashboard
Designs refreshable Excel dashboards (Power Query + structured tables + validation + pivot reporting). Use when you need a repeatable weekly KPI workbook that updates from files with minimal manual work.
Why use this skill?
Build refreshable, validation-ready Excel dashboards with OpenClaw. Automate weekly reporting, Power Query pipelines, and KPI tracking efficiently.
Install via CLI (Recommended)
clawhub install openclaw/skills/skills/kowl64/excel-weekly-dashboardWhat This Skill Does
The excel-weekly-dashboard skill is a robust toolkit designed to automate the lifecycle of weekly reporting in Microsoft Excel. It moves away from manual "copy-paste" workflows by implementing Power Query-driven pipelines. The skill focuses on four pillars: reliable ingestion (handling folders of CSVs or flat dumps), rigorous data cleansing (transforming raw, messy data into structured tables), automated validation (catching bad data before it hits reports), and interactive visualization (pivot-driven dashboards with ISO week support). It is built for professionals who need repeatable, audit-ready weekly KPI tracking without needing to migrate to full BI software.
Installation
To install this skill, use the following command in your OpenClaw terminal:
clawhub install openclaw/skills/skills/kowl64/excel-weekly-dashboard
Use Cases
- Automating weekly financial reporting from fragmented CSV export folders.
- Standardizing inconsistent month-over-month spreadsheet exports into a unified, refreshable schema.
- Creating "clean-room" reporting environments where raw data is separated from final pivot-based dashboards to ensure data integrity.
- Designing operational dashboards that require complex validation (e.g., flagging duplicate PayNumbers or missing date fields automatically).
Example Prompts
- "I have a folder of weekly CSV exports in 'data/inbound/'. Can you build a Power Query pipeline that merges these into a single master table, adds an ISO week column, and flags rows that are missing an employee ID?"
- "My weekly Excel file keeps breaking when the IT team changes column names. Can you refactor my model to use defensive Power Query steps that handle missing columns and renaming automatically?"
- "Please design a pivot-driven dashboard for my weekly sales report. I need slicers for year and ISO week, and a 'Refresh Status' sheet that shows the latest processed data timestamp and row counts."
Tips & Limitations
- Tips: Always define a 'stable key' (like a unique ID or SKU) to prevent refresh errors. Use the 'Data_Staging' and 'Data_Clean' query pattern to troubleshoot issues at the source level before they propagate to your charts.
- Limitations: This skill is for repeatable reporting, not complex valuation or predictive modeling. It assumes you can provide a sample file or schema. Avoid using this for massive datasets (1M+ rows) where Power BI would be a more performant choice.
Metadata
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 skillPaste this into your clawhub.json to enable this plugin.
{
"plugins": {
"official-kowl64-excel-weekly-dashboard": {
"enabled": true,
"auto_update": true
}
}
}Tags(AI)
Flags: file-read, file-write, code-execution
Related Skills
transport-investigation-acas-aligned-pack
Generates ACAS-aligned investigation invite wording, neutral question sets, and evidence logs. USE WHEN starting a driver incident investigation/interview.
drivers-hours-wtd-infringement-coach-uk
Creates a 1-page driver-facing tacho/WTD infringement note plus corrective actions and review date. USE WHEN you need to explain infringements and schedule follow-up.
incident-pcn-evidence-appeal-corrective-actions-uk
Builds incident/PCN evidence packs with timelines, appeal drafts, corrective actions, and follow-up monitoring. USE WHEN handling PCNs or incidents needing documentation.
cpc-mpqc-competence-tracker-compliance-uk
Plans CPC/MPQC competence tracking with reminders, evidence lists, and compliance reporting. USE WHEN maintaining training/certification readiness.
api-credentials-hygiene
Audits and hardens API credential handling (env vars, separation, rotation plan, least privilege, auditability). Use when integrating services or preparing production deployments where secrets must be managed safely.