xlsx

Create, edit, and analyze XLSX and CSV files with formulas and formatting.

1|Updated Apr 4, 2026

Search Tags:#pandas #openpyxl #spreadsheet #data-analysis #xlsx #recalculation

Ready to run

npx skills add https://github.com/m0at/claudemd --skill xlsx-m0at

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/m0at/claudemd/tree/main/skills/xlsx
Command: npx skills add https://github.com/m0at/claudemd --skill xlsx-m0at

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Spreadsheet handlers struggle to manage, format, and recalculate formula-based workbooks across multiple sheets. This Skill provides a Python-based toolkit to create, edit, format, analyze data with Pandas and OpenPyXL, and ensure formulas recalculate reliably via a LibreOffice-backed workflow.

Core Features & Use Cases

Cross-sheet formula management and error checking
Data analysis and import/export using pandas and openpyxl
Recalculation workflow using recalc.py to validate formulas and detect errors
CSV/Excel interoperability for reporting and data exchange

Quick Start

Create a new workbook, insert data, and apply a formula to verify automatic recalculation

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I automate XLSX workbook creation and formula recalculation in Python?▼

Automate XLSX workbook creation and formula recalculation using Python with openpyxl and pandas for data management, plus a LibreOffice-backed recalculation workflow to reliably validate formulas and update cell values.

Can I manage cross-sheet formulas and error checking across multiple Excel sheets?▼

Yes, you can manage cross-sheet formulas and perform error checking across multiple Excel sheets using openpyxl to handle formula references and a dedicated recalculation workflow to detect calculation errors.

Does this approach support CSV and Excel interoperability for data analysis workflows?▼

Yes, this approach supports CSV and Excel interoperability for data analysis workflows by using pandas to import and export data, enabling seamless reporting and data exchange between XLSX and CSV file formats.

What is the best way to recalculate formula-based spreadsheets without opening Excel?▼

The best way to recalculate formula-based spreadsheets without opening Excel is using a LibreOffice-backed recalculation workflow via recalc.py, which validates formulas and updates calculated values programmatically.

How do I clean and format spreadsheet data for financial modeling and reporting?▼

Clean and format spreadsheet data for financial modeling and reporting by applying openpyxl for cell formatting and pandas for data cleaning, ensuring structured analysis and accurate outputs across workbook sheets.