skills.rest
vuminhieu
vuminhieuCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze spreadsheet files with formulas and formatting.

Updated Feb 2, 2026
Search Tags:#Excel#pandas#openpyxl#formulas#spreadsheet#data-analysis#xlsx
One-click install
npx skills add https://github.com/vuminhieu/spexor-client --skill xlsx-vuminhieu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/vuminhieu/spexor-client/tree/main/.agent/skills/skills/xlsx
Command: npx skills add https://github.com/vuminhieu/spexor-client --skill xlsx-vuminhieu

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill reduces the manual burden of creating, formatting, and analyzing spreadsheets across common formats (.xlsx, .xlsm, .csv, .tsv), while preserving formulas and ensuring reliable recalculation.

Core Features & Use Cases

  • Workbook creation: Generate new workbooks with formulas and structured formatting from data sources.
  • Data reading & analysis: Import data, compute metrics, and visualize results within sheets.
  • Update existing sheets while preserving formulas: Modify templates and models without breaking formulas.
  • Use Case: Prepare monthly financial models by importing data, applying formulas, and producing updated reports.

Quick Start

Use the xlsx skill to create a new workbook from a sample dataset and apply a simple formula across a range.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I update an existing Excel workbook while preserving formulas?▼

To update an existing Excel workbook while preserving formulas, use the xlsx Skill to modify templates and models. It edits existing sheets and relies on a LibreOffice-based recalc workflow to recalculate formulas and ensure data integrity without breaking existing structures.

Can I use pandas and openpyxl to generate new spreadsheets with formatting?▼

Yes, you can generate new spreadsheets with formatting. The xlsx Skill uses Python tooling like pandas and openpyxl to automate workbook creation, applying structured formatting and formulas directly from your data sources.

Does this approach support reading and analyzing CSV and TSV files?▼

Reading and analyzing CSV and TSV files is fully supported. The Skill imports data from .csv and .tsv formats, computes metrics, and visualizes results within sheets, alongside handling standard .xlsx and .xlsm files.

What is the best way to automate monthly financial model preparation in Excel?▼

The best way to automate monthly financial model preparation is using the xlsx Skill to import data, apply formulas, and produce updated reports. It reduces manual burden by replacing repetitive workbook tasks with automated generation and recalculation.

Why does spreadsheet recalculation fail when updating models, and how is it fixed?▼

Spreadsheet recalculation fails when manual updates break formula references. The xlsx Skill fixes this by using a LibreOffice-based recalc workflow to recalculate formulas automatically, ensuring data integrity and preventing broken models.

Related Skills

Explore More Data & Analytics Skills→
Darwin-AgentDarwin-Agent
415

xlsx

Process spreadsheet inputs into formatted Excel workbooks with validation.

Official
Advanced
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
Science-DiscoveryScience-Discovery
71

Excel Analysis

Automate Excel data analysis and visualization with pandas, openpyxl, and matplotlib.

Official
Intermediate
alexhegitalexhegit
4

pandas-skill

Clean, analyze, and transform tabular datasets using pandas DataFrame operations.

Community
Intermediate