skills.rest
atro2829-hub
atro2829-hubCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Read, edit, convert, and generate Excel-compatible spreadsheet files.

Updated Jun 1, 2026
Search Tags:#data analysis#spreadsheet#excel#xlsx#csv#chart#pivot
One-click install
npx skills add https://github.com/atro2829-hub/APPLE-NET-NEW --skill xlsx-atro2829-hub
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/atro2829-hub/APPLE-NET-NEW/tree/main/skills/xlsx
Command: npx skills add https://github.com/atro2829-hub/APPLE-NET-NEW --skill xlsx-atro2829-hub

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill handles spreadsheet work that is too tedious or error-prone to do by hand, including reading, fixing, transforming, analyzing, and generating Excel and tabular files.

Core Features & Use Cases

  • Spreadsheet creation and editing: Build new workbooks or modify existing .xlsx, .xlsm, .csv, and .tsv files.
  • Analysis and reporting: Summarize data, create pivots, add charts, and produce structured Excel outputs for review or decision-making.
  • Format conversion and cleanup: Convert between tabular formats, merge datasets, clean columns, and preserve workbook structure and formulas where possible.

Quick Start

Use the xlsx skill to analyze the attached spreadsheet and return a cleaned Excel workbook with a summary sheet.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean up and convert CSV or TSV files into a formatted Excel workbook?▼

Spreadsheet cleanup and format conversion transforms raw CSV or TSV files into structured Excel workbooks. The process reads tabular inputs, aligns misaligned columns, cleans data, and preserves formulas to generate reliable .xlsx or .xlsm outputs for review.

Can I generate pivot tables and charts from existing spreadsheet data?▼

Pivot tables and charts can be generated from existing spreadsheet data to summarize datasets for reporting. The task analyzes workbook inputs, creates pivot-style summaries, and adds visual charts to produce structured Excel outputs ready for decision-making.

Does OpenPyXL support preserving formulas when editing .xlsx and .xlsm files?▼

OpenPyXL supports reading, editing, and preserving formulas within .xlsx and .xlsm files. It ensures reliable Excel-compatible structures are maintained during workbook modifications, validated through LibreOffice-aware QA workflows to confirm formula integrity.

What is the best way to merge multiple datasets and fix columns in a spreadsheet?▼

Merging datasets and fixing columns in a spreadsheet involves reading multiple tabular inputs, aligning mismatched structures, and cleaning column data. This approach handles tedious transformations too error-prone for manual work, outputting a unified and reliable workbook.

Why do my spreadsheet formulas break after automated format conversion?▼

Spreadsheet formulas often break after automated format conversion due to structural misalignment or unsupported syntax. Validating outputs with LibreOffice-aware QA workflows ensures Excel-compatible structures, formula integrity, and chart rendering are preserved across .xlsx and .xlsm formats.

Related Skills

Explore More Data & Analytics Skills→
YouMingYehYouMingYeh
2

xlsx

Clean, transform, and convert spreadsheet files between xlsx, csv, and tsv formats.

Community
Intermediate
semaes111semaes111

Excel Analysis

Analyze Excel spreadsheets with pandas to create pivots, metrics, and charts.

Community
Advanced
Fergana-LabsFergana-Labs
27

xlsx

Automate Excel workbook creation, editing, and analysis with pandas and openpyxl.

Official
Advanced
h4vzzh4vzz
33

data-visualization

Generate static and interactive charts from structured data using matplotlib, seaborn, and plotly.

Community
Intermediate