xlsx

Automates Excel spreadsheet creation, editing, and formatting with Python.

Updated Sep 22, 2025

Search Tags:#automation #formatting #financial modeling #data analysis #formulas #spreadsheet #excel

Ready to run

npx skills add https://github.com/Menschlichkeit-Osterreich/menschlichkeit-oesterreich-development --skill xlsx-menschlichkeit-osterreich

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Menschlichkeit-Osterreich/menschlichkeit-oesterreich-development/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/Menschlichkeit-Osterreich/menschlichkeit-oesterreich-development --skill xlsx-menschlichkeit-osterreich

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, python-docx, python-pptx, lxml, defusedxml, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines spreadsheet management by automating the creation, editing, and analysis of Excel files, ensuring accuracy and adherence to professional standards.

Core Features & Use Cases

Data Manipulation: Read, write, and modify .xlsx, .xlsm, .csv, and .tsv files using Python libraries like pandas and openpyxl.
Formula Management: Ensure all formulas are error-free and correctly implemented within Excel.
Formatting & Standards: Apply industry-standard color coding, number formatting, and formula construction rules for financial models and general spreadsheets.
Use Case: Automatically update a sales report spreadsheet by adding new data, calculating totals with Excel formulas, and ensuring all formatting matches the existing template.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and populate it with the provided data.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I automate Excel formatting and fix formula errors in xlsx files?▼

You can automate Excel formatting and fix formula errors in xlsx files by using Python libraries like pandas and openpyxl, which enforce font consistency and run mandatory formula recalculations to eliminate #REF! or #DIV/0! errors.

Does openpyxl support financial modeling with industry-standard color coding?▼

Yes, openpyxl supports financial modeling by applying industry-standard color coding and number formatting rules to xlsx and xlsm files, ensuring professional presentation while preserving existing spreadsheet templates.

What is the best way to parse and modify csv files for data analysis?▼

The best way to parse and modify csv files for data analysis is using pandas for data manipulation, which reads tsv and csv formats seamlessly and integrates with openpyxl for exporting to structured xlsx spreadsheets.

Can I use Python to update existing spreadsheet templates without breaking formulas?▼

Yes, you can use Python to update existing spreadsheet templates without breaking formulas by leveraging openpyxl for structural edits and running a mandatory recalculation script to validate and fix formula errors.

Why does my automated spreadsheet show #REF! errors after data manipulation?▼

Your automated spreadsheet shows #REF! errors after data manipulation because formula references were broken during editing, requiring a mandatory recalculation script to validate and fix formula errors automatically.

Are there limitations when editing xlsm files with Python for data analysis?▼

When editing xlsm files with Python for data analysis, limitations depend on openpyxl's macro preservation capabilities, though the skill fully supports data manipulation, professional formatting, and zero formula errors for xlsm formats.