xlsx

Create, edit, recalculate and validate Excel workbooks preserving formulas and formatting.

9|1|Updated Apr 16, 2026
One-click install
npx skills add https://github.com/CarbeneAI/Forge --skill xlsx-carbeneai
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/CarbeneAI/Forge/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/CarbeneAI/Forge --skill xlsx-carbeneai

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the manual, error-prone work of creating, updating, and validating spreadsheet models by ensuring formulas, formatting, and templates are preserved and recalculated correctly.

Core Features & Use Cases

  • Create and Edit Workbooks: Create new .xlsx files with formulas and professional formatting or modify existing workbooks while preserving templates and formulas.
  • Data Analysis & Visualization: Use pandas for data manipulation and openpyxl for Excel-native formulas and styling to deliver analysis-ready spreadsheets.
  • Recalculation and Validation: Recalculate formulas using LibreOffice via the included recalc.py script and verify there are zero Excel formula errors before delivery.
  • Use Case: Build a financial projection workbook from raw CSVs that uses in-sheet formulas for all calculations, matches existing corporate template conventions, and passes automated recalculation checks.

Quick Start

Create a new .xlsx from dataset.csv with formulas and formatting, then run the recalc.py script to recalculate and verify there are no formula errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I build Excel financial models with formulas from CSV files?

To build Excel financial models from CSV files, you can use pandas for data manipulation and openpyxl to create .xlsx workbooks with in-sheet formulas. The workflow ensures professional formatting is applied and formulas are calculated correctly within the spreadsheet.

What is the best way to edit existing Excel workbooks without breaking formatting?

The best way to edit existing Excel workbooks without breaking formatting is using openpyxl workflows. This approach preserves your existing corporate templates and formulas while allowing modifications, ensuring the original styling remains intact during spreadsheet automation tasks.

How do I verify and recalculate Excel formulas to ensure zero errors?

You verify and recalculate Excel formulas to ensure zero errors by running the LibreOffice recalc.py script. This recalculates all values in your .xlsx workbook and validates the spreadsheet to confirm there are no formula errors before final delivery.

Does this approach support creating .xlsx files with in-sheet formulas for data analysis?

Yes, this approach supports creating .xlsx files with in-sheet formulas for data analysis. It combines pandas for data manipulation with openpyxl for Excel-native formulas and styling, delivering analysis-ready spreadsheets that match corporate template conventions.

Can I update spreadsheet templates and automate .xlsm file modifications?

You can update spreadsheet templates and automate file modifications across .xlsx, .xlsm, .csv, and .tsv formats. The process modifies existing workbooks while strictly preserving templates, formulas, and formatting for financial modeling and data analysis tasks.

Why do my Excel formulas show errors after automated workbook modifications?

Excel formulas show errors after automated workbook modifications when recalculation is not properly enforced. Running LibreOffice via recalc.py recalculates values and validates the workbook, enforcing zero formula errors and ensuring templates and formatting are preserved.