skills.rest
augustscl
augustsclCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create and edit Excel spreadsheets with formulas, formatting, and error validation.

2|Updated Apr 6, 2026
Search Tags:#templates#pandas#openpyxl#excel#xlsx#recalculation#financial-modeling
One-click install
npx skills add https://github.com/augustscl/awesome-xiawang-skills --skill xlsx-augustscl
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/augustscl/awesome-xiawang-skills/tree/main/xlsx
Command: npx skills add https://github.com/augustscl/awesome-xiawang-skills --skill xlsx-augustscl

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Many spreadsheet workflows break when formulas are hardcoded, templates are altered, or calculations are not properly recalculated; this Skill eliminates manual spreadsheet errors by enforcing formula-first construction, preserving template conventions, and validating outputs for Excel error codes.

Core Features & Use Cases

  • Formula-first creation and editing: Build workbooks that use Excel formulas for totals, growth rates, and ratios instead of hardcoded values to keep models dynamic.
  • Template preservation and formatting: When updating existing files, match existing style, color conventions, and number formats exactly to avoid breaking established templates.
  • Recalculation and error detection: Recalculate formulas using LibreOffice via the included recalc.py script and report any #REF!, #DIV/0!, #VALUE!, #NAME?, or similar errors.
  • Data analysis and automation: Use pandas for data manipulation and openpyxl for formula and formatting work to support tasks like financial modeling, CSV/TSV import, and visualization-ready spreadsheets.
  • Use Case: Produce a financial forecast workbook with assumptions on a separate sheet, formula-driven projections across periods, industry-standard color coding for inputs and links, and a final recalc to verify zero formula errors.

Quick Start

Create a new workbook with inputs on an "Assumptions" sheet, implement calculations as Excel formulas on projection sheets, save as forecast.xlsx, and run the recalc.py script to recalculate and verify there are no Excel errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create Excel formulas instead of hardcoded values when building financial models?▼

This Skill enforces formula-first construction, ensuring your spreadsheet uses Excel formulas for calculations instead of hardcoded values. It preserves template conventions and applies consistent number and color formatting to keep financial models dynamic.

How do I detect and fix Excel error codes like #REF! or #DIV/0! in my spreadsheet?▼

The Skill recalculates formulas using LibreOffice via the recalc.py script and reports any #REF!, #DIV/0!, #VALUE!, or #NAME? errors. This allows you to validate outputs and ensure your spreadsheet contains zero formula errors before finalizing.

Can I use pandas and openpyxl to automate Excel data analysis and formatting?▼

Yes, the Skill uses pandas for data manipulation and openpyxl for formula and formatting work. This combination supports data analysis, financial modeling, and CSV/TSV imports to produce visualization-ready spreadsheets.

What is the best way to update existing Excel templates without breaking formatting conventions?▼

When updating existing files, the Skill matches existing style, color conventions, and number formats exactly. This template preservation avoids breaking established templates and maintains consistent formatting throughout the workbook.

Does LibreOffice recalculation work with CSV and TSV files or only XLSX spreadsheets?▼

The Skill handles .xlsx, .xlsm, .csv, and .tsv files for recalculation and formula validation. This allows you to apply formula-first construction and error detection across various tabular data formats for financial modeling and data analysis.

Related Skills

Explore More Finance & Accounting Skills→
open-nekoopen-neko
11

xlsx

Create, edit, and analyze Excel files with openpyxl and LibreOffice.

Official
Advanced
kerrybackkerryback

xlsx

Create, edit, and analyze Excel workbooks with formulas and recalculation.

Community
Advanced
XJTLUmediaXJTLUmedia
28

xlsx

Create and edit Excel spreadsheets with openpyxl, pandas, and LibreOffice.

Community
Intermediate
devMoezdevMoez
1

excel-author

Generate auditable Excel workbooks with openpyxl for financial modeling.

Community
Advanced