skills.rest
a1094174619
a1094174619COMMUNITY
Explore all skills by this author →
GitHub

xlsx

Open, read, edit, clean, convert, and restructure spreadsheet files.

Updated Aug 27, 2026
Search Tags:#openpyxl#excel#xlsx#data-transformation#data-cleaning#format-conversion
One-click install
npx skills add https://github.com/a1094174619/skills --skill xlsx-a1094174619
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/a1094174619/skills/tree/main/xlsx
Command: npx skills add https://github.com/a1094174619/skills --skill xlsx-a1094174619

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill reduces the manual toil of opening, editing, cleaning, converting, and repairing spreadsheet files. It targets workflows where a spreadsheet is the primary input or output, and where data from formats like .xlsx, .xlsm, .csv, or .tsv needs structuring, cleaning, or format conversion.

Core Features & Use Cases

  • Open, read, edit, and fix messy data in spreadsheet files (Excel-compatible formats including .xlsx, .xlsm, .csv, .tsv).
  • Create new spreadsheets or convert between tabular formats, maintaining deliverables as spreadsheet files.
  • Trigger when a user references a spreadsheet by name or path and wants a concrete action performed (e.g., data cleaning, restructuring, or format conversion).

Quick Start

Open the input spreadsheet, apply cleaning and restructuring rules, and output a validated spreadsheet file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate data cleaning and restructuring for multiple xlsx and csv files?▼

You can automate data cleaning and restructuring for xlsx and csv files by applying deterministic script-driven operations to open, edit, and validate messy inputs into a final spreadsheet deliverable.

Can I convert csv or tsv files into a formatted xlsx spreadsheet?▼

Yes, you can convert csv or tsv inputs into a formatted xlsx spreadsheet by applying format conversion rules that restructure tabular data and output a validated spreadsheet file.

Does openpyxl support opening and editing xlsm files with macros?▼

Yes, openpyxl supports opening and editing xlsm files, allowing you to read, clean, and restructure spreadsheet inputs while maintaining the output deliverable as a valid spreadsheet file.

What is the best way to fix misaligned data in a spreadsheet without manual editing?▼

The best way to fix misaligned data is to use script-driven cleaning rules that automatically open, structure, and repair spreadsheet files, ensuring the final output conforms to spreadsheet deliverable standards.

How do I convert a spreadsheet file to tsv format for data processing?▼

You can convert a spreadsheet file to tsv format by applying format conversion operations that read your input spreadsheet and restructure the output to deliver a valid tsv file.

Related Skills

Explore More Data & Analytics Skills→
OpenCoworkAIOpenCoworkAI
2.0k

xlsx

Create and edit Excel workbooks with formulas across .xlsx, .xlsm, .csv, and .tsv formats.

Official
Advanced
YrzheYrzhe
10

xlsx

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

Community
Advanced
JosephWoodallJosephWoodall
1

xlsx

Process and transform XLSX, CSV, and TSV spreadsheets using openpyxl.

Community
Intermediate
Wesley1600Wesley1600

Python Script Skill Template

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

Community
Basic