skills.rest
yibozhong
yibozhongCOMMUNITY
Explore all skills by this author →
𝕏@tmux_1GitHub

xlsx

Automate Excel workflows for reading, editing, creating, and converting spreadsheets.

Updated Apr 6, 2026
Search Tags:#automation#spreadsheet#excel#xlsx#data-cleaning#data-conversion
One-click install
npx skills add https://github.com/yibozhong/skills --skill xlsx-yibozhong
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/yibozhong/skills/tree/main/xlsx
Command: npx skills add https://github.com/yibozhong/skills --skill xlsx-yibozhong

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the manual, error-prone tasks of working with spreadsheet files by automating common Excel workflows, reducing time spent on repetitive data chores.

Core Features & Use Cases

  • Open, read, edit, and create .xlsx/.xlsm/.csv/.tsv files and convert between tabular formats to fit downstream apps.
  • Clean messy tabular data, apply formatting, compute formulas with Excel-compatible rules, and generate consistent spreadsheet deliverables.
  • Use Case: you receive a messy CSV of customer transactions and need to normalize columns, apply calculations, and export a clean XLSX ready for reporting.

Quick Start

Create a new spreadsheet from raw data and apply a simple formula, then save as an .xlsx file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate cleaning messy CSV data and exporting it as a formatted XLSX file?▼

Yes, you can convert between CSV, XLSX, XLSM, and TSV formats. This Skill automates format conversions to fit downstream applications, ensuring your tabular data is compatible with various business analytics and finance systems.

Does this approach support deterministic calculations using Excel formulas?▼

Yes, this approach supports deterministic calculations using Excel formulas. It enforces Excel-compatible calculation rules and supports LibreOffice-based recalculation to ensure formula outputs are accurate and consistent.

What is the best way to programmatically create a new spreadsheet from raw data?▼

The best way to programmatically create a new spreadsheet from raw data is using this Skill, which builds XLSX files from scratch, applies calculations via formulas, documents hardcoded values in cells, and saves the final output.

Can I use pandas and openpyxl to edit existing .xlsm files without breaking macros?▼

You can use this Skill to open, read, and edit existing .xlsm files leveraging pandas and openpyxl. It processes spreadsheet modifications while preserving the structure needed for business analytics workflows.

How does this method handle data sources and hardcoded values in spreadsheet cells?▼

This method handles data sources and hardcoded values in spreadsheet cells by automatically documenting them. It ensures transparency in your spreadsheet workflows by tracking where specific values originate within the generated files.

Related Skills

Explore More Data & Analytics Skills→
OwnLabAIOwnLabAI
21

xlsx

Reads and writes spreadsheet data, transforms formats, and exports to XLSX/CSV/TSV.

Official
Intermediate
bcastelinobcastelino
2

business-analyst

Analyze business data and create dashboards with Tableau and Power BI.

Community
Advanced
bloknayrbbloknayrb
2

Excel Analysis

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

Community
Intermediate
RheasilviaRheasilvia

xlsx

Create, read, and edit Excel workbooks and CSV files with formula recalculation.

Community
Advanced