xlsx

Read, write, and convert Excel files with Python and JavaScript.

68|19|Updated Nov 21, 2025
One-click install
npx skills add https://github.com/bobmatnyc/claude-mpm-skills --skill xlsx-bobmatnyc
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/bobmatnyc/claude-mpm-skills/tree/main/universal/data/xlsx
Command: npx skills add https://github.com/bobmatnyc/claude-mpm-skills --skill xlsx-bobmatnyc

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines the process of reading, writing, and manipulating data within Excel files, eliminating manual copy-pasting and complex spreadsheet formulas.

Core Features & Use Cases

  • Programmatic Excel Operations: Read data from, write data to, and format Excel files using Python and JavaScript.
  • Data Transformation: Perform filtering, grouping, and pivoting on Excel data.
  • File Conversion: Easily convert between Excel and CSV formats.
  • Use Case: Combine data from multiple Excel files into a single, consolidated report for analysis.

Quick Start

Use the xlsx skill to read data from 'report.xlsx' and save it as 'report.csv'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I read and write Excel files using Python?

To read and write Excel files using Python, you can use openpyxl or pandas. This approach enables programmatic interaction with .xlsx files for data manipulation, formatting, and transformation without manual spreadsheet tasks.

Can I convert Excel data to CSV format programmatically?

Yes, you can convert Excel data to CSV format programmatically. Using Python or JavaScript libraries, you can extract spreadsheet data and export it directly as CSV files for easier data sharing and analysis.

What is the best way to merge multiple Excel files into one dataset?

The best way to merge multiple Excel files into one dataset is by using Python with pandas. This method consolidates data from various spreadsheets into a single report, streamlining data transformation and analysis.

Does JavaScript support reading and formatting xlsx files?

Yes, JavaScript supports reading and formatting xlsx files. By using the xlsx library, you can perform programmatic spreadsheet operations including data extraction, formatting, and file conversion within your JavaScript applications.

How do I perform data transformation like pivoting on Excel data?

You can perform data transformation like pivoting on Excel data by using Python libraries such as pandas. This facilitates advanced filtering, grouping, and pivoting operations directly on your spreadsheet data programmatically.