xlsx

Create, edit, and analyze Excel workbooks in XLSX, XLSM, and CSV formats.

27|9|Updated Jan 4, 2026

Search Tags:#automation #formulas #spreadsheet #excel #xlsx #recalc

Ready to run

npx skills add https://github.com/georgekhananaev/claude-skills-vault --skill xlsx-georgekhananaev

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/georgekhananaev/claude-skills-vault/tree/main/.claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/georgekhananaev/claude-skills-vault --skill xlsx-georgekhananaev

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill automates the tedious tasks of creating, editing, and analyzing spreadsheets, ensuring formulas are preserved and results are consistently recalculated across workbooks.

Core Features & Use Cases

Create new Excel workbooks with formulas and formatting across .xlsx, .xlsm, and related formats.
Read, transform, and analyze data using Python tools like pandas and openpyxl.
Recalculate formulas and validate results using recalc.py with LibreOffice integration for accurate, repeatable results.
Preserve existing templates and formatting when updating workbooks to maintain consistency.

Quick Start

Create a new workbook with a simple sum formula in B2 using openpyxl, then run recalc.py to verify formulas in the file.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I automate Excel workbook creation and editing with Python?▼

To automate Excel workbook creation and editing, this skill uses openpyxl and pandas to generate, read, and transform data across .xlsx, .xlsm, and .csv formats while preserving existing templates and formatting.

How do I recalculate Excel formulas automatically without opening the file?▼

To recalculate Excel formulas automatically, this skill integrates a recalc.py script with LibreOffice to process and validate formula results, ensuring accurate and repeatable outputs across workbooks.

Can I read and transform data across xlsx, xlsm, and csv files in one workflow?▼

Yes, you can read and transform data across xlsx, xlsm, and csv files in a single workflow by leveraging pandas and openpyxl for comprehensive data analysis and modeling.

What is the best way to preserve existing Excel templates and formatting when updating spreadsheets?▼

The best way to preserve existing Excel templates and formatting when updating spreadsheets is to use openpyxl, which maintains template consistency while applying new data and formulas.

Do I need LibreOffice to validate and recalculate formulas in Excel workbooks?▼

Yes, you need LibreOffice integrated with the recalc.py script to accurately validate and recalculate formulas within Excel workbooks for consistent reporting and data-cleaning results.

Why are my Excel formulas not recalculating when I edit spreadsheets programmatically?▼

Excel formulas may not recalculate when editing programmatically because Python libraries alone do not evaluate formulas; this skill solves the limitation by running recalc.py with LibreOffice to force recalculation.