skills.rest
iiammae
iiammaeCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Open, read, edit, and convert Excel spreadsheet files with openpyxl and pandas.

Updated Jun 9, 2026
Search Tags:#financial modeling#Excel#data cleaning#Excel automation#spreadsheet management
One-click install
npx skills add https://github.com/iiammae/opero --skill xlsx-iiammae
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/iiammae/opero/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/iiammae/opero --skill xlsx-iiammae

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides powerful Excel functionalities directly, solving the need for manual data entry, formula application, and formatting adjustments for .xlsx files, enabling efficient spreadsheet creation and management.

Core Features & Use Cases

  • File Manipulation: Open, read, edit, or fix existing .xlsx, .xlsm, .csv, or .tsv files.
  • Sheet Creation: Generate new spreadsheets from scratch or from other data sources.
  • File Conversion: Convert between various tabular file formats.
  • Use Case: Ideal for cleaning or restructuring messy data files into proper spreadsheets, without the need for dedicated Excel expertise.

Quick Start

Create a new spreadsheet for financial modeling and automatically recalculate formulas with the xlsx skill.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel data cleaning and financial modeling tasks?▼

To automate Excel data cleaning and financial modeling, this Skill applies predefined formatting and formula standards to user-provided spreadsheets, handling file manipulation and formula recalculation without manual entry.

Can I convert CSV or TSV files into properly formatted xlsx spreadsheets?▼

Yes, you can convert CSV or TSV files into xlsx spreadsheets. This Skill handles file conversion between various tabular formats, restructuring messy data files into proper, formatted spreadsheets.

Do I need LibreOffice to recalculate formulas in my Excel files?▼

Yes, LibreOffice is required for formula recalculations in Excel files. The Skill depends on openpyxl and pandas for file handling and data manipulation, while utilizing LibreOffice to process formulas.

What is the best way to fix corrupted or messy xlsx and xlsm files?▼

The best way to fix messy xlsx and xlsm files is using automated spreadsheet management that opens, reads, and edits existing files to clean and restructure data into proper spreadsheets.

Does openpyxl support creating new spreadsheets from scratch for financial models?▼

Yes, openpyxl supports creating new spreadsheets from scratch. Combined with this Skill's processing logic, it generates new sheets for financial modeling and automatically recalculates formulas.

Why does my spreadsheet formula not update after editing the xlsx file?▼

Your spreadsheet formula might not update because LibreOffice is required for recalculations. This Skill depends on LibreOffice specifically to process and apply formula updates to modified xlsx files.

Related Skills

Explore More Finance & Accounting Skills→
Gull-StackGull-Stack

xlsx

Create, edit, and analyze Excel spreadsheets with formulas using Python.

Official
Advanced
daodaoleedaodaolee

xlsx

Create, edit, and analyze Excel files with formulas and pandas.

Community
Advanced
pounctpounct

xlsx

Create and edit Excel spreadsheets with formulas using openpyxl and pandas.

Community
Advanced
langbyyilangbyyi
96

xlsx

Create, edit, analyze, and validate Excel spreadsheet files with pandas and openpyxl.

Community
Advanced