skills.rest
moritalous
moritalousCOMMUNITY
Explore all skills by this author →
Website𝕏@moritalousGitHub

xlsx

Creates, edits, and analyzes Excel-compatible spreadsheets using openpyxl and optional pandas.

11|Updated Dec 27, 2025
Search Tags:#automation#pandas#openpyxl#formulas#spreadsheet#data-analysis#xlsx
One-click install
npx skills add https://github.com/moritalous/claude-code-on-agentcore --skill xlsx-moritalous
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/moritalous/claude-code-on-agentcore/tree/main/backend/assets/claude-agent/app/.claude/skills/xlsx
Command: npx skills add https://github.com/moritalous/claude-code-on-agentcore --skill xlsx-moritalous

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines the end-to-end creation, editing, and analysis of spreadsheets, reducing manual workloads, errors, and repetitive formatting tasks.

Core Features & Use Cases

  • Create new workbooks with formulas, formatting, and conditional styling across multiple sheets.
  • Read, summarize, and analyze data from XLSX, CSV, and TSV files with reproducible results.
  • Update existing workbooks while preserving formulas and structure, enabling safe template reuse and batch updates.
  • Recalculate formulas programmatically to verify outcomes after data changes.

Quick Start

Create a new workbook named sales.xlsx with a sheet "Q1" containing columns Date, Revenue, and Growth, add a formula to compute Growth, format headers, and save as sales.xlsx.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate spreadsheet creation and add formulas across multiple sheets?▼

Automate spreadsheet creation by generating new workbooks with formulas, formatting, and conditional styling across multiple sheets. It programmatically builds files, reducing manual data entry and formatting errors.

Can I update an existing xlsx file while preserving its formulas and structure?▼

Yes, you can update existing xlsx files while preserving their formulas and structure. This Skill enables safe template reuse and batch updates by modifying data without destroying the underlying formula logic or workbook layout.

How do I analyze data from CSV and TSV files using Python for spreadsheet automation?▼

Analyze data from CSV and TSV files using Python libraries like pandas and openpyxl. This Skill reads, summarizes, and extracts insights from your data with reproducible results, requiring no graphical interface to execute.

Do I need a Python environment to recalculate spreadsheet formulas programmatically?▼

Yes, you need a Python environment to recalculate spreadsheet formulas programmatically. This Skill relies on Python libraries such as openpyxl to verify outcomes after data changes and execute automated workbook updates without a graphical interface.

What is the best way to batch update Excel templates without losing conditional formatting?▼

The best way to batch update Excel templates without losing conditional formatting is to use an automation Skill that modifies existing workbooks while preserving formulas and structure. This allows safe, repetitive template updates without manual editing.

Related Skills

Explore More Data & Analytics Skills→
mattmacleod16-svgmattmacleod16-svg
1

spreadsheet

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

Community
Intermediate
cookeyholdercookeyholder

xlsx

Open, edit, clean, and convert XLSX, XLSM, CSV, and TSV spreadsheets.

Community
Intermediate
MCERQUAMCERQUA
1

xlsx

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

Community
Advanced
tiankong0101-bytetiankong0101-byte

minimax-xlsx

Create, read, and analyze XLSX spreadsheet data for tabular workflows.

Community
Intermediate