Excel/XLSX Manipulation
CommunityEffortlessly 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
.xlsxfiles 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 requiredComponents
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.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.