skills.rest
openakita
openakitaCOMMUNITY
Explore all skills by this author →
GitHub

excel-maker

Generate, audit, and export editable XLSX report workbooks from CSV or XLSX data.

2.0k|274|Updated Jan 30, 2026
Search Tags:#report generation#excel#XLSX#CSV#formula#workbook#Data Profiling
One-click install
npx skills add https://github.com/openakita/openakita --skill excel-maker
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-maker
Source: https://github.com/openakita/openakita/tree/main/plugins/excel-maker
Command: npx skills add https://github.com/openakita/openakita --skill excel-maker

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, pydantic, aiosqlite, fastapi.

What problem does it solve?

Turning raw CSV or XLSX files into structured, auditable Excel report workbooks normally requires manual data cleaning, formula writing, and formatting. This Skill automates that pipeline while keeping every step reviewable and never letting the model write binary Excel files directly.

Core Features & Use Cases

  • Guided Report Pipeline: Import and profile workbooks, clarify reporting requirements, generate a controlled WorkbookPlan JSON, then build a multi-sheet .xlsx with README, Raw_Data, Clean_Data, Summary, Charts, Formula_Check, and Audit_Log sheets.
  • Formula Generation and Explanation: Produce SUMIFS, COUNTIFS, AVERAGEIFS, and year-over-year formulas with plain-language explanations, then audit the final workbook for missing sheets, empty formulas, and #REF! errors.
  • Safe Operation Execution: Validate whitelisted operations (rename_column, groupby, pivot, filter, write_formula) and reject arbitrary Python, JavaScript, or SQL from model output.
  • Use Case: Upload a sales CSV, answer a few clarifying questions about audience and metrics, confirm the proposed workbook plan, and download a formatted report_v1.xlsx with an audit log.

Quick Start

Create an Excel report project, upload my sales CSV file, profile it, and build a formatted XLSX report workbook with summary formulas and an audit log.

Frequently Asked Questions about excel-maker

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

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

Start a report project, upload the CSV, and let the importer detect delimiters and header rows. After profiling columns and metrics, confirm the generated WorkbookPlan and build a formatted .xlsx with summary, charts, and audit sheets.

How to generate Excel formulas like SUMIFS automatically?▼

Provide the formula kind, target range, and optional criteria range to the formula tool. It returns a valid formula string starting with '=' plus a plain-language explanation, supporting SUMIFS, COUNTIFS, AVERAGEIFS, and year-over-year calculations.

What Python packages are required to build XLSX reports?▼

The table_core dependency group provides openpyxl and pandas, which are required for importing and building .xlsx files. Optional groups cover legacy formats (xlrd, pyxlsb) and charting (matplotlib), installable from the plugin settings.

Can the AI model edit Excel files directly?▼

No. The model only produces a WorkbookPlan JSON describing sheets, operations, and formulas. Deterministic Python code validates the plan against a whitelist and builds the binary workbook, rejecting any embedded code or SQL.

What are the limitations of automated Excel report generation?▼

It is not a full online Excel editor, and large sheets are sampled for preview and model context rather than processed in full. Uploaded source files and templates are never overwritten, and each refinement creates a new workbook version.

Related Skills

Explore More Data & Analytics Skills→
koralliskorallis
90

document-processing-xlsx

Create, parse, and manipulate Excel spreadsheets using xlsx, exceljs, or SheetJS.

Community
Intermediate
oimiragieooimiragieo
36

excel-generator

Generate multi-sheet Excel workbooks with formulas, charts, and formatting.

Community
Basic
Largo2z9Largo2z9
1

validate-output-coherence

Validate generated outputs against brand schemas, tone rules, and sourcing constraints.

Community
Advanced
AradotsoAradotso
5

power-bi-retail-analytics-salespulse360

Deploy and customize the SalesPulse 360 Power BI dashboard for retail analytics.

Official
Advanced