Excel/XLSX Manipulation

Community

Effortlessly manage Excel data.

AuthorMacPhobos
Version1.0.0
Installs0

System Documentation

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'.

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: Excel/XLSX Manipulation
Download link: https://github.com/MacPhobos/research-mind/archive/main.zip#excel-xlsx-manipulation

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.