excel-generator

Generate and format Excel workbooks with formulas, charts, and data validation.

2|2|Updated Apr 3, 2026
One-click install
npx skills add https://github.com/tamnguyentommy-rgb/Routex_AI_Web_Project --skill excel-generator-tamnguyentommy-rgb
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: excel-generator
Source: https://github.com/tamnguyentommy-rgb/Routex_AI_Web_Project/tree/main/.local/secondary_skills/excel-generator
Command: npx skills add https://github.com/tamnguyentommy-rgb/Routex_AI_Web_Project --skill excel-generator-tamnguyentommy-rgb

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the creation, formatting, and updating of Excel workbooks (.xlsx) with embedded formulas, charts, data validation, and pivot-style summaries to speed up financial modeling and data reporting.

Core Features & Use Cases

  • Excel & Spreadsheet Generator: Create and modify .xlsx files from scratch or by editing existing templates, including formulas, styling, charts, data validation, and pivot-like summaries.
  • Google Sheets & PDF Exports: Optionally export to Google Sheets or PDF for sharing and reporting.
  • Use Case: Build a multi-year financial model, dashboards, or templates that automatically generate reports from input data.

Quick Start

Create a starter Excel workbook using the generator to produce a 3-statement model with assumptions and an income statement.

Frequently Asked Questions about excel-generator

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

FAQPage Schema
How do I automate Excel workbook generation with embedded formulas and charts?

You can automate Excel workbook generation by using a Skill that creates .xlsx files from scratch or updates existing templates with embedded formulas, charts, data validation, and pivot-like summaries for financial modeling.

Can I generate a 3-statement financial model in an xlsx spreadsheet automatically?

Yes, you can generate a 3-statement financial model in an xlsx spreadsheet automatically. The Skill supports common financial patterns like 3-statement models, DCFs, and LBOs with deterministic outputs ready for reporting.

Does this Excel generator support exporting workbooks to Google Sheets or PDF?

Yes, the Excel generator supports exporting workbooks to Google Sheets or PDF. It creates formatted .xlsx files with formulas and charts, then optionally exports them for sharing and reporting purposes.

What is the best way to update existing Excel templates with new financial data?

The best way to update existing Excel templates with new financial data is using an automation Skill that modifies .xlsx files. It injects data, recalculates embedded formulas, and updates charts while maintaining deterministic outputs.

Can I build pivot-like summaries and data validation into a generated spreadsheet?

Yes, you can build pivot-like summaries and data validation into a generated spreadsheet. The Skill uses Python libraries like openpyxl and xlsxwriter to format and validate data within the automated Excel workbooks.

Do I need Python libraries to create financial models in Excel?

No, you do not need to manually manage Python libraries to create financial models in Excel. The Skill handles the underlying openpyxl and xlsxwriter logic internally to produce formatted .xlsx files with charts and formulas.