skills.rest
YHWriteCode
YHWriteCodeCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, read, edit, and convert spreadsheet files with formula recalculation.

Updated Jun 29, 2025
Search Tags:#openpyxl#excel#xlsx#libreoffice#recalc#formula-validation#spreadsheet-cleaning
One-click install
npx skills add https://github.com/YHWriteCode/EconRAGent --skill xlsx-yhwritecode
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/YHWriteCode/EconRAGent/tree/main/skills/xlsx
Command: npx skills add https://github.com/YHWriteCode/EconRAGent --skill xlsx-yhwritecode

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, defusedxml, lxml, and includes scripts (resource) components.

What problem does it solve?

Many tasks require producing or repairing spreadsheet deliverables but fail because of messy tabular inputs, broken formulas, lost formatting, or missing recalculation; this Skill makes spreadsheet work reliable and auditable so the final deliverable is a valid, re‑calculable Excel file.

Core Features & Use Cases

  • Read, edit, and create spreadsheets: open and modify .xlsx/.xlsm, import .csv/.tsv, add columns, restructure sheets, and preserve template conventions.
  • Formula-first construction & validation: insert Excel formulas (never hardcode calculated values), use provided LibreOffice-based recalculation to generate evaluated values, and scan for Excel errors (#REF!, #DIV/0!, #NAME?, etc.).
  • Cleaning & conversion: detect and fix malformed rows, misplaced headers, and junk data; convert between tabular formats while keeping formulas and links intact.
  • Financial model standards: apply the color, number-format, and documentation conventions described in the skill for professional financial work.
  • Use Case: Convert a messy CSV of transactions into a multi-sheet financial model with assumption cells, dynamic formulas, formatting per standards, recalculated values, and a final validated .xlsx.

Quick Start

Open input.xlsx, clean and reformat the data, replace computed hardcoded values with Excel formulas, run the provided recalculation script, and save a validated output.xlsx.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert a messy CSV into a validated xlsx file with working formulas?▼

To convert a messy CSV into a validated xlsx file, this Skill imports the tabular data, cleans malformed rows, inserts dynamic Excel formulas instead of hardcoded values, and runs a LibreOffice-based recalculation to ensure accurate outputs.

How does LibreOffice recalculation work for validating Excel formulas?▼

LibreOffice recalculation works by executing a provided script that processes the spreadsheet to evaluate inserted Excel formulas, ensuring the calculated values are accurate and detecting broken references or errors like #REF! and #DIV/0!.

Can I use openpyxl to edit xlsm files while preserving existing template formatting?▼

Yes, you can use openpyxl within this Skill to open and modify .xlsm files, add columns, restructure sheets, and preserve existing template conventions while applying professional financial formatting standards.

What is the best way to detect and fix broken references and Excel errors in a spreadsheet?▼

The best way to detect and fix broken references is to use the formula-first validation mechanism, which scans for Excel errors like #REF!, #DIV/0!, and #NAME?, ensuring the final deliverable is a valid, re-calculable file.

Does this spreadsheet automation approach support converting between xlsx, csv, and tsv formats?▼

Yes, this approach supports converting between xlsx, csv, and tsv formats by importing tabular data, applying necessary cleaning and reformatting, and exporting the result while keeping formulas and links intact.

Related Skills

Explore More Finance & Accounting Skills→
ChenYCLChenYCL

xlsx

Create, read, edit, and analyze Excel spreadsheet files with openpyxl and pandas.

Community
Intermediate
stefanbosakstefanbosak

xlsx

Automate Excel creation, editing, and analysis with formula-safe workflows.

Community
Advanced
koya-altkoya-alt

excel-generator

Generate .xlsx files with formatting, formulas, charts, and data validation using openpyxl or xlsxwriter.

Community
Intermediate
xlsamaxlsama

xlsx

Create, edit, and analyze spreadsheet files using pandas and openpyxl.

Community
Advanced