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

Ready to run

npx skills add https://github.com/UntLab/codex --skill spreadsheet-untlab

💬 Prompt for ChatGPT / Claude Chat▼

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.