skills.rest
GGGODLIN
GGGODLINCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

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

Updated Feb 12, 2026
Search Tags:#reporting#data analysis#pandas#formulas#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/GGGODLIN/skill_share --skill xlsx-gggodlin
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/GGGODLIN/skill_share/tree/main/xlsx
Command: npx skills add https://github.com/GGGODLIN/skill_share --skill xlsx-gggodlin

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, 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, automating complex tasks and ensuring data integrity.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new spreadsheets or modify existing ones, including formulas and formatting.
  • Data Analysis & Visualization: Analyze data within spreadsheets using powerful tools and create visualizations.
  • Formula Recalculation & Error Checking: Ensure all formulas are accurate and error-free using a dedicated recalculation script.
  • Use Case: Automatically generate a financial projection spreadsheet, populate it with data, apply industry-standard formatting, and verify all calculations are correct.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add a formula to sum the 'Revenue' column.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate spreadsheet creation and data analysis in Python?▼

To automate spreadsheet creation and data analysis, this tool generates and modifies .xlsx, .xlsm, and .csv files while leveraging pandas and openpyxl for advanced calculations and formatting.

How do I check Excel formulas for errors like #REF! and #DIV/0!?▼

To check Excel formulas for errors like #REF! and #DIV/0!, a dedicated recalculation script detects common issues and ensures all spreadsheet calculations remain accurate and error-free.

Can I use pandas and openpyxl to edit existing xlsx files with formulas?▼

Yes, you can use pandas and openpyxl to edit existing xlsx files, allowing you to modify spreadsheet data, implement new formulas, and apply industry-standard formatting seamlessly.

What is the best way to generate a formatted financial projection spreadsheet?▼

The best way to generate a formatted financial projection spreadsheet is to populate data, apply standard formatting, and verify calculations using automated recalculation and error detection features.

Does this spreadsheet analysis tool support csv files?▼

Yes, this spreadsheet analysis tool supports csv files, enabling comprehensive data management including creation, editing, and advanced analysis directly within the csv format.

Related Skills

Explore More Data & Analytics Skills→
HellKaiser45HellKaiser45

xlsx

Read, edit, format, and convert Excel-compatible files using openpyxl and pandas.

Community
Intermediate
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
clark-labs-incclark-labs-inc
28

libreoffice-rs

Convert office documents to PDF, images, and Markdown without LibreOffice.

Official
Intermediate
silvainfmsilvainfm
2

duckdb

Run SQL analytics directly on CSV, Parquet, and JSON files and Pandas or Polars DataFrames.

Community
Advanced