office-xlsx-skills

Read, write, analyze, and convert Excel, CSV, and JSON files.

4|2|Updated Dec 28, 2025
One-click install
npx skills add https://github.com/lazygophers/ccplugin --skill office-xlsx-skills
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: office-xlsx-skills
Source: https://github.com/lazygophers/ccplugin/tree/main/plugins/office/xlsx/skills/office-xlsx-skills
Command: npx skills add https://github.com/lazygophers/ccplugin --skill office-xlsx-skills

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires mcp-excel-server, pandas, openpyxl, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the process of reading, writing, analyzing, and converting Excel files, eliminating manual data manipulation and saving significant time.

Core Features & Use Cases

  • File Operations: Read, write, and update data in Excel files (.xlsx, .xls, .csv).
  • Data Analysis: Generate summaries, perform filtering, create pivot tables, and analyze data trends.
  • Format Conversion: Convert between Excel, CSV, and JSON formats.
  • Batch Processing: Import multiple files into a single Excel or export sheets to individual files.
  • Chart Generation: Create various chart types directly from data.
  • Smart Insights: Detect anomalies, analyze correlations, and identify trends within data.
  • Use Case: Automatically convert a directory of CSV sales records into a single Excel file with a summary sheet and a sales performance chart.

Quick Start

Use the office-xlsx-skills to convert the attached file 'sales_data.xlsx' to CSV format.

Frequently Asked Questions about office-xlsx-skills

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

FAQPage Schema
How do I convert CSV files to Excel format in bulk?

You can convert CSV files to Excel in bulk by importing multiple files into a single Excel spreadsheet. This Skill handles batch import and export operations, consolidating directory-level CSV records into structured .xlsx files.

Can I generate charts and pivot tables directly from Excel data?

Yes, you can generate charts and pivot tables directly from Excel data. It supports data analysis operations that summarize datasets, filter rows, and visualize trends without requiring manual spreadsheet manipulation.

Does this Skill support converting Excel files to JSON format?

Yes, it supports format conversion between Excel, CSV, and JSON. You can transform .xlsx or .xls spreadsheet data into JSON format to integrate structured tabular data into application workflows.

What is the best way to analyze trends and anomalies in an Excel spreadsheet?

The best way to analyze trends and anomalies in an Excel spreadsheet is to use built-in smart insights. It detects data anomalies, analyzes correlations, and identifies trends for business intelligence and reporting.

Do I need Python and pandas installed to analyze Excel files?

Yes, the underlying spreadsheet manipulation and data analysis rely on Python scripts using pandas and openpyxl. These dependencies are required to execute the data reading, writing, and format conversion tasks.

Can I export individual sheets from a single Excel file into separate files?

Yes, you can export individual sheets from a single Excel file into separate files. The batch processing feature supports splitting an Excel workbook into multiple individual files for targeted distribution.