skills.rest
wx-chevalier
wx-chevalierCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Automate Excel, CSV, and TSV file creation, editing, and analysis with Python libraries including pandas and openpyxl.

10|2|Updated Mar 3, 2026
Search Tags:#financial modeling#formulas#spreadsheet#excel#data cleaning#data manipulation
One-click install
npx skills add https://github.com/wx-chevalier/Awesome-Agent-Skills --skill xlsx-wx-chevalier
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/wx-chevalier/Awesome-Agent-Skills/tree/main/claude/xlsx
Command: npx skills add https://github.com/wx-chevalier/Awesome-Agent-Skills --skill xlsx-wx-chevalier

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, libreoffice, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet files, eliminating manual errors and saving significant time on data manipulation tasks.

Core Features & Use Cases

  • Data Transformation: Convert data between formats, clean messy tabular data, and restructure spreadsheets.
  • Formula Management: Create new Excel files with complex formulas or update existing ones, ensuring zero formula errors.
  • Use Case: Automatically generate a financial projection model in Excel based on provided assumptions, complete with industry-standard formatting and error-free formulas.

Quick Start

Use the xlsx skill to create a new spreadsheet with columns for 'Date', 'Revenue', and 'Expenses', populating it with sample 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 formula creation and ensure there are zero formula errors?▼

Automate Excel formula creation by generating files with openpyxl and pandas, then running the recalc.py script via LibreOffice to ensure zero formula errors and accurate computed values.

Can I clean messy data and convert between CSV, TSV, and xlsx formats?▼

Yes, you can clean messy data and convert between CSV, TSV, xlsx, and xlsm formats using pandas and openpyxl, restructuring spreadsheets while preserving existing templates during updates.

What's the best way to generate a financial projection model in Excel?▼

Generate a financial projection model in Excel by providing assumptions to the Skill, which automatically populates industry-standard formatting and complex, error-free formulas using openpyxl.

Do I need LibreOffice to recalculate formulas in my xlsx spreadsheet?▼

Yes, you need LibreOffice installed to recalculate formulas in your xlsx spreadsheet, as the Skill relies on the scripts/recalc.py script to process and validate formula outputs.

Will updating an existing spreadsheet preserve my original Excel template formatting?▼

Yes, updating an existing spreadsheet preserves your original Excel template formatting, as the Skill is designed to modify data and formulas without destroying the existing template structure.

How does Python handle data manipulation and charting in xlsm files?▼

Python handles data manipulation and charting in xlsm files by leveraging openpyxl to add columns, compute formulas, apply formatting, and generate charts while maintaining macro support.

Related Skills

Explore More Finance & Accounting Skills→
cbbkrd-techcbbkrd-tech

xlsx

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.

Community
Advanced
iOfficeAIiOfficeAI
31.8k

xlsx

Create, edit, and analyze Excel spreadsheets with pandas and openpyxl.

Official
Advanced
QcasaresQcasares

data-analyst

Execute SQL queries and analyze spreadsheet data with Python.

Community
Advanced
rajyeole6rajyeole6

agency-tool-evaluator

Evaluate software tools using weighted scoring and total cost of ownership analysis.

Community
Advanced