skills.rest
UntLab
UntLabCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

spreadsheet

Automate spreadsheet creation, editing, analysis, and formatting across Excel, CSV, and TSV.

1|Updated Mar 6, 2026
Search Tags:#analysis#pandas#openpyxl#spreadsheet#excel#data-preparation
One-click install
npx skills add https://github.com/UntLab/codex --skill spreadsheet-untlab
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/UntLab/codex/tree/main/config/codex-skills/spreadsheet
Command: npx skills add https://github.com/UntLab/codex --skill spreadsheet-untlab

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Spreadsheet tasks often require building, updating, analyzing, and formatting workbooks while preserving formulas, references, and layout, and ensuring correct recalculation and presentation for delivery.

Core Features & Use Cases

  • Formula-aware editing and formatting with openpyxl for Excel workbooks (.xlsx) and support for CSV/TSV via pandas.
  • Data analysis, transformation, and reporting with pandas; ability to compute metrics and generate visual-ready outputs.
  • Recalculation, rendering, and validation to ensure formulas are up-to-date before sharing; supports internal tooling when available.

Quick Start

Create or load a workbook with openpyxl, perform edits or analyses with pandas, and save results to output/spreadsheet.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema
How do I edit Excel formulas without breaking existing cell references?▼

Formula-aware spreadsheet editing preserves cell references and layout when modifying Excel workbooks. It uses openpyxl to manipulate .xlsx files directly, ensuring formulas remain intact and recalculated before delivery.

Can I analyze CSV and TSV files using pandas without converting them first?▼

Yes, you can analyze CSV and TSV files directly using pandas for data transformation and metric computation. The Skill handles these formats natively alongside Excel, generating visual-ready analytical outputs.

What's the best way to automate Excel report generation and dashboard creation?▼

Automating Excel reporting and dashboards involves creating workbooks with openpyxl, computing metrics with pandas, and saving formatted results. This workflow ensures formulas are updated and presentation is validated for sharing.

Does openpyxl support spreadsheet recalculation and rendering before sharing files?▼

Openpyxl handles spreadsheet file manipulation and formula preservation, while recalculation and rendering are supported through optional internal tooling. This ensures formulas are up-to-date before sharing workbooks.

How do I prepare spreadsheet data for reporting while preserving styling?▼

Data preparation for reporting uses pandas to transform and compute metrics, while openpyxl preserves existing styling and formulas in Excel workbooks. Outputs are written to a designated directory for delivery.

Related Skills

Explore More Data & Analytics Skills→
Blake-JohnBlake-John

xlsx

Process and convert spreadsheet data across .xlsx, .xlsm, .csv, and .tsv files.

Community
Intermediate
weirdgmeweirdgme
4

platform-engineering

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

Community
Advanced
1479089714790897
7

kwp-data-create-viz

Generate publication-quality static and interactive visualizations with matplotlib, seaborn, and plotly.

Community
Intermediate
pchemguypchemguy

spreadsheet

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

Community
Intermediate