skills.rest
AIDotNet
AIDotNetOFFICIAL
Explore all skills by this author →
WebsiteGitHub

excel-handler

Read, create, convert, and merge Excel files using Python with pandas and openpyxl.

84|15|Updated Dec 31, 2025
Search Tags:#spreadsheet#excel#xlsx#csv#data manipulation#file conversion
One-click install
npx skills add https://github.com/AIDotNet/MoYuCode --skill excel-handler
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-handler
Source: https://github.com/AIDotNet/MoYuCode/tree/main/skills/tools/excel-handler
Command: npx skills add https://github.com/AIDotNet/MoYuCode --skill excel-handler

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, and includes scripts (resource) components.

What problem does it solve?

This Skill automates the tedious tasks of reading, creating, converting, and merging Excel files, saving significant time and reducing manual errors.

Core Features & Use Cases

  • Read Excel: Load data from .xlsx or .xls files into JSON or other formats.
  • Create Excel: Generate new spreadsheets from JSON or CSV data, with optional header styling.
  • Convert Formats: Transform Excel files into CSV, JSON, HTML, or Markdown.
  • Merge Files: Combine multiple Excel files into a single workbook, either as separate sheets or a consolidated sheet.
  • Use Case: You have several CSV files containing sales data from different regions. Use this Skill to convert them into a single Excel file with a dedicated sheet for each region, making it easy to analyze and present.

Quick Start

Use the excel-handler skill to read the data from 'sales_data.xlsx' and save it as 'sales_data.json'.

Frequently Asked Questions about excel-handler

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

FAQPage Schema
How do I convert Excel files to JSON or CSV format?▼

You can convert Excel files to JSON or CSV by using this Skill to read .xlsx or .xls data and export it. It leverages pandas to load spreadsheet data and transform it into structured JSON, CSV, HTML, or Markdown formats.

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

The best way to merge multiple Excel files is using this Skill to combine them into a single workbook. It can organize each source file as a separate sheet or consolidate them into one combined sheet using pandas and openpyxl.

Can I generate an Excel spreadsheet from JSON or CSV data?▼

Yes, you can generate an Excel spreadsheet from JSON or CSV data. This Skill creates new .xlsx files from your raw data structures and applies optional header styling to format the output spreadsheet using openpyxl.

Does pandas work with openpyxl to read and write xlsx files?▼

Pandas works with openpyxl to read and write xlsx files by leveraging pandas for data handling and openpyxl for spreadsheet operations. This combination ensures robust reading, writing, and manipulation of Excel files.

How do I read data from an xlsx file into JSON?▼

To read data from an xlsx file into JSON, use this Skill to load the spreadsheet with pandas and export the data as a JSON file. It reads .xlsx or .xls files and transforms their contents into structured JSON formats.

Related Skills

Explore More Data & Analytics Skills→
mattmacleod16-svgmattmacleod16-svg
1

spreadsheet

Automate spreadsheet creation, editing, analysis, and formatting with openpyxl and pandas.

Community
Intermediate
bettercallfanbettercallfan

dataset-onboarding-graph-preprocess

Convert raw phone network data files into structured graph tables.

Community
Advanced
Wesley1600Wesley1600

Python Script Skill Template

Executes Python scripts that process CLI input and return JSON-formatted results.

Community
Basic
bloknayrbbloknayrb
2

Excel Analysis

Analyzes and transforms data in .xlsx files using Python libraries.

Community
Intermediate