xlsx

Read, create, convert, analyze, and report on Excel spreadsheets in XLSX, XLS, and CSV formats.

8|Updated Jan 22, 2026

Search Tags:#automation #reporting #Excel #data-analysis #xlsx #CSV

Ready to run

npx skills add https://github.com/thechandanbhagat/claude-skills --skill xlsx-thechandanbhagat

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/thechandanbhagat/claude-skills/tree/main/skills/xlsx
Command: npx skills add https://github.com/thechandanbhagat/claude-skills --skill xlsx-thechandanbhagat

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, xlrd, xlsxwriter.

What problem does it solve?

This Skill reduces manual spreadsheet work by enabling reliable reading, creation, conversion, analysis, and reporting of Excel data across XLSX, XLS, and CSV formats.

Core Features & Use Cases

Read data from Excel files and extract structured data for downstream processing.
Create new spreadsheets from templates or data sources, with formatting and validation.
Convert between XLSX, XLS, and CSV formats to fit different workflows.
Analyze data using familiar tools (e.g., Python with openpyxl/pandas) and generate reports or templates for sharing.
Use Case: consolidate monthly sales figures from multiple Excel files into a single CSV or a formatted report.

Quick Start

Load an Excel file such as data.xlsx and request to export to data.csv, or generate a summary report from template.xlsx.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I convert an Excel file to CSV format?▼

To convert an Excel file to CSV format, load your XLSX or XLS file and request an export to CSV. The skill uses libraries like openpyxl and pandas to read the spreadsheet data and write it into the target format.

Can I use Python to analyze Excel spreadsheets and generate reports?▼

Yes, you can analyze Excel spreadsheets and generate reports using Python. The skill uses pandas and openpyxl to read, transform, and analyze data, enabling you to create formatted summary reports from your existing files.

Does this approach support both XLSX and older XLS file formats?▼

Yes, this approach supports both XLSX and older XLS file formats. It handles cross-format compatibility across XLSX, XLS, and CSV, optionally using format converters like LibreOffice or ssconvert for older files.

What's the best way to consolidate multiple Excel files into one report?▼

The best way to consolidate multiple Excel files into one report is to use pandas for data extraction and transformation. You can merge data from multiple spreadsheets into a single formatted report or CSV file.

Do I need pandas and openpyxl installed to read and create Excel files?▼

Yes, you need pandas and openpyxl installed to read and create Excel files programmatically. These Python libraries are core dependencies for spreadsheet manipulation, alongside xlrd and xlsxwriter for full functionality.

Why does converting XLS to XLSX require external converters like LibreOffice?▼

Converting XLS to XLSX requires external converters like LibreOffice because Python libraries alone have limited support for the legacy XLS binary format. Optional converters such as ssconvert provide the necessary cross-format compatibility.