skills.rest
MacPhobos
MacPhobosCOMMUNITY
Explore all skills by this author →
GitHub

Excel/XLSX Manipulation

Read, write, transform, and format Excel XLSX files in Python and JavaScript.

Updated Jan 30, 2026
Search Tags:#pandas#openpyxl#excel#xlsx#csv#data manipulation
One-click install
npx skills add https://github.com/MacPhobos/research-mind --skill excel-xlsx-manipulation
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Excel/XLSX Manipulation
Source: https://github.com/MacPhobos/research-mind/tree/main/.claude/skills/universal-data-xlsx
Command: npx skills add https://github.com/MacPhobos/research-mind --skill excel-xlsx-manipulation

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies the process of reading, writing, transforming, and formatting data within Excel (XLSX) files, eliminating manual data handling and complex spreadsheet operations.

Core Features & Use Cases

  • Read/Write Excel: Load data from and save data to .xlsx files using Python (openpyxl, pandas) and JavaScript (xlsx).
  • Data Transformation: Perform filtering, grouping, and pivoting operations on your data.
  • Formatting & Formulas: Apply styles, fonts, colors, and insert formulas directly into spreadsheets.
  • File Conversion: Easily convert between CSV and Excel formats.
  • Merging: Combine multiple Excel files into a single, consolidated workbook.
  • Use Case: You have several CSV files containing sales data from different regions. Use this Skill to convert them to Excel, merge them into one file, and then pivot the data to analyze sales performance by product and region.

Quick Start

Use the Excel/XLSX Manipulation skill to read the data from 'sales_report.xlsx' and save it as 'sales_report.csv'.

Frequently Asked Questions about Excel/XLSX Manipulation

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

FAQPage Schema
How do I convert CSV files to Excel format using pandas?▼

Converting CSV files to Excel format involves loading structured data using pandas and saving it as an `.xlsx` file. This Skill supports file conversion operations between CSV and Excel formats across Python and JavaScript environments.

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

Merging multiple Excel files into a single consolidated workbook is a core feature of this Skill. It allows you to combine data from separate `.xlsx` files programmatically, eliminating manual spreadsheet operations.

Can I apply formulas and formatting to Excel files with openpyxl?▼

Yes, applying formulas and formatting to Excel files is fully supported. This Skill utilizes libraries like openpyxl to insert formulas directly into spreadsheets and apply styles, fonts, and colors to structured data.

How does Python handle data transformation and pivoting in Excel files?▼

Data transformation in Excel files is handled by performing filtering, grouping, and pivoting operations on your data. This Skill uses Python libraries such as pandas to manipulate structured data programmatically within `.xlsx` files.

Does this Excel manipulation Skill work with JavaScript as well as Python?▼

Yes, this Excel manipulation Skill works with both JavaScript and Python environments. It utilizes the `xlsx` library for JavaScript and pandas or openpyxl for Python to read, write, and transform `.xlsx` files.

Related Skills

Explore More Data & Analytics Skills→
bobmatnycbobmatnyc
68

xlsx

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

Community
Intermediate
georgekhananaevgeorgekhananaev
27

xlsx

Create, edit, and analyze Excel workbooks in XLSX, XLSM, and CSV formats.

Community
Advanced
Imad-OuteImad-Oute

seaborn

Create statistical graphics in Python using seaborn and matplotlib.

Community
Intermediate
Awish021Awish021
10

pyspark-databricks

Build and optimize PySpark ETL pipelines on Databricks with Delta Lake.

Community
Intermediate