xlsx

Read, analyze, and generate results from Excel and CSV files.

49|2|Updated Mar 20, 2026

Search Tags:#python #pandas #openpyxl #excel #data-analysis #xlsx #csv

Ready to run

npx skills add https://github.com/vibeinging/YiYi --skill xlsx-vibeinging

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/vibeinging/YiYi/tree/main/app/src-tauri/skills/xlsx
Command: npx skills add https://github.com/vibeinging/YiYi --skill xlsx-vibeinging

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Spreadsheet processing is tedious and error-prone when performed manually; this skill enables automated reading, transformation, and analysis of Excel and CSV data to save time and reduce mistakes.

Core Features & Use Cases

Reading Spreadsheets: read XLSX/XLS and CSV/TSV using openpyxl and Python's csv module.
Creating Spreadsheets: generate and format new XLSX files with pandas and openpyxl.
Data Analysis Workflows: perform aggregation and analysis with pandas, then export results to a new workbook.
Use Case: Consolidate monthly sales data from multiple files into a single workbook and generate a summary report.

Quick Start

Use the xlsx skill to read input.xlsx, perform analysis, 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 read and analyze Excel files with Python?▼

To read and analyze Excel files with Python, use pandas and openpyxl to load XLSX or CSV data, perform aggregations, and export the analysis results to a new workbook.

What is the best way to consolidate multiple CSV and XLSX files into a single report?▼

The best way to consolidate multiple CSV and XLSX files into a single report is using Python to automate data transformation and aggregation with pandas, outputting a formatted XLSX summary.

Do I need pandas and openpyxl to process spreadsheets in Python?▼

Yes, you need pandas and openpyxl to process spreadsheets in Python, as pandas handles data analysis and aggregation while openpyxl manages reading, creating, and formatting XLSX workbooks.

Can I create and format new XLSX files from raw CSV data?▼

Yes, you can create and format new XLSX files from raw CSV data by using Python to read the CSV input, apply transformations with pandas, and generate a formatted workbook with openpyxl.

Does this Python spreadsheet processing approach support TSV formats?▼

Yes, this Python spreadsheet processing approach supports TSV formats alongside CSV and XLSX, enabling you to read tab-separated data, perform analysis, and write consolidated results.