skills.rest
yeeehaooo
yeeehaoooCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create and edit Excel workbooks with formulas and formatting using openpyxl.

Updated Jan 8, 2026
Search Tags:#automation#visualization#openpyxl#spreadsheet#data-analysis#xlsx#formula
One-click install
npx skills add https://github.com/yeeehaooo/agent-kit --skill xlsx-yeeehaooo
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/yeeehaooo/agent-kit/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/yeeehaooo/agent-kit --skill xlsx-yeeehaooo

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the end-to-end workflow of spreadsheet creation, editing, and analysis, reducing manual data handling, preserving formulas and templates, and enabling scalable data work across multiple spreadsheet formats.

Core Features & Use Cases

  • Automated Workbook Creation: generate new spreadsheets with formulas, formatting, and data structures.
  • Data Ingestion & Analysis: read and summarize data from .xlsx, .xlsm, .csv, and .tsv files.
  • Template-Preserving Updates: modify existing workbooks while preserving formulas and established formatting conventions.

Quick Start

Use the xlsx skill to create a new workbook named 'example.xlsx' with a sheet 'Overview' containing a header row and a formula cell that sums a data column.

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 analysis with openpyxl?▼

Automating spreadsheet creation with openpyxl allows you to generate workbooks, apply formulas, structure formatting, and ingest data from .xlsx, .xlsm, .csv, and .tsv files for analysis.

Can I modify an existing xlsx workbook while preserving formulas and formatting?▼

Modifying an existing xlsx workbook while preserving formulas and formatting is possible through template-preserving updates, allowing you to edit data and recalculate formulas without breaking established layouts.

What is the best way to build financial models and analyze data across multiple spreadsheet formats?▼

Building financial models and analyzing data across spreadsheet formats is best handled by automating workbook creation, template updates, and formula recalculations using Python tools like openpyxl and pandas for scalable processing.

Does this spreadsheet automation approach support ingesting data from CSV and TSV files?▼

This spreadsheet automation approach supports ingesting data from CSV and TSV files, allowing you to read, summarize, and integrate external data into your .xlsx or .xlsm workbooks for analysis.

How do I document hardcoded values and formulas when modifying spreadsheets?▼

Documenting hardcoded values and formulas when modifying spreadsheets involves programmatically maintaining templates and recording cell contents, ensuring transparency in automated data work and recalculations.

Related Skills

Explore More Data & Analytics Skills→
ollieb89ollieb89

spreadsheet

Automates spreadsheet creation, editing, analysis, and formatting with Python libraries.

Community
Intermediate
vasilyu1983vasilyu1983
73

document-xlsx

Create, edit, and analyze Excel workbooks with formulas and charts.

Community
Advanced
pchemguypchemguy

spreadsheet

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

Community
Intermediate
Gull-StackGull-Stack

xlsx

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

Official
Advanced