xlsx

Read, transform, and export Excel workbooks using Python with openpyxl and pandas.

5|Updated Jan 12, 2026
One-click install
npx skills add https://github.com/SherifEldeeb/agentskills --skill xlsx-sherifeldeeb
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/SherifEldeeb/agentskills/tree/main/skills/baseline/xlsx
Command: npx skills add https://github.com/SherifEldeeb/agentskills --skill xlsx-sherifeldeeb

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the handling of Excel data by enabling automated reading, manipulation, and generation of .xlsx files, reducing manual spreadsheet work and errors.

Core Features & Use Cases

  • Read Workbooks: load data, formulas, and formatting from Excel files for analysis.
  • Create and Format Workbooks: generate new Excel workbooks with multiple sheets and styled headers.
  • Data Operations & Visualization: filter, sort, transform data, and create basic charts from data.
  • Use Case: generate a monthly sales report by aggregating data from multiple sheets and exporting a summarized workbook or CSV.

Quick Start

Use the xlsx skill to read data from data.xlsx, transform it with pandas, and write results to output.xlsx.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate reading and writing Excel spreadsheets with Python?

You can automate reading and writing Excel spreadsheets by applying this Skill to extract, transform, and export .xlsx workbooks. It requires Python 3.9+ with pandas and openpyxl to automate data preparation and reporting workflows.

What is the best way to generate formatted Excel workbooks from multiple data sheets?

Generating formatted Excel workbooks involves loading and aggregating data from multiple sheets using pandas, then exporting a styled .xlsx file. This Skill creates new workbooks with multiple sheets, styled headers, and basic data visualization charts.

Does this Excel automation approach work with existing formulas and formatting?

Yes, this Excel automation approach works with existing formulas and formatting. The Skill reads data, formulas, and formatting from existing .xlsx files, enabling you to load and manipulate them during data extraction and transformation workflows.

Do I need pandas and openpyxl to extract data from .xlsx files?

Yes, you need pandas and openpyxl to extract data from .xlsx files. These are required dependencies for the Skill to read, modify, and export Excel workbooks, enabling data extraction, transformation, and reporting workflows.

When should I use Python for Excel data preparation instead of manual spreadsheet work?

You should use Python for Excel data preparation when you need to reduce manual spreadsheet work and errors across finance, analytics, or operations workflows. It streamlines handling .xlsx files by automating data extraction, filtering, sorting, and transformations.