xlsx

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

49|2|Updated Mar 20, 2026
One-click install
npx skills add https://github.com/vibeinging/YiYi --skill xlsx-vibeinging
Or copy as Structured Prompt for Agent▼
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.