xlsx

Create, edit, and analyze spreadsheets while preserving formulas and templates.

5|Updated Nov 29, 2025

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

Ready to run

npx skills add https://github.com/shuakyle21/nenitafarm-lechonhaus --skill xlsx-shuakyle21

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/shuakyle21/nenitafarm-lechonhaus/tree/main/.agent/skills/xlsx
Command: npx skills add https://github.com/shuakyle21/nenitafarm-lechonhaus --skill xlsx-shuakyle21

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines creating, editing, and analyzing spreadsheets across common formats (.xlsx, .xlsm, .csv, .tsv), ensuring formulas remain intact and templates are respected, to accelerate data-driven decision making.

Core Features & Use Cases

Create new spreadsheets with robust formulas and formatting to model data.
Read, transform, and analyze data from Excel or CSV files, and generate reports or visualizations.
Preserve existing formulas when updating templates and recalculate results, enabling reliable scenario analysis.

Quick Start

Create a new workbook named Sales_Report.xlsx with a simple monthly sales table, include formulas for total and average, and preserve any existing templates.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I edit an Excel template and preserve existing formulas?▼

You can edit Excel templates and preserve formulas by using this Skill to update .xlsx or .xlsm files while keeping original formulas intact. It triggers a LibreOffice-based recalculation to ensure formula-driven calculations reflect the new data accurately.

Can I use pandas and openpyxl to automate spreadsheet creation and analysis?▼

Yes, you can use pandas and openpyxl to automate spreadsheet creation and analysis. This Skill leverages both libraries to read, transform, and analyze data from Excel or CSV files, generating dynamic workbooks and reports with robust formulas.

Does this spreadsheet automation approach support CSV and TSV file formats?▼

Yes, this spreadsheet automation approach supports CSV and TSV file formats alongside .xlsx and .xlsm. It reads, transforms, and analyzes tabular data across all these common formats, enabling you to model data and generate reports seamlessly.

What is the best way to recalculate formula-driven calculations in an updated workbook?▼

The best way to recalculate formula-driven calculations in an updated workbook is using a LibreOffice-based recalc.py script. This Skill requires this specific recalculation support to reliably update formula results after editing spreadsheet templates.

Why do my spreadsheet formulas break when I automate data transformations?▼

Spreadsheet formulas often break during automated data transformations when hardcoded references are mishandled or recalculation is skipped. This Skill preserves existing formulas during file updates and requires proper documentation of hardcoded references to prevent broken template logic.

How do I generate visualizations from Excel or CSV files for business reporting?▼

To generate visualizations from Excel or CSV files for business reporting, this Skill reads and transforms your data using pandas, then creates visualizations and reports. This accelerates data-driven decision making within standard business workflows.