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.