skills.rest
Estom
EstomCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

spreadsheet

Manipulate and analyze .xlsx, .csv, and .tsv files while preserving formulas and formatting.

Updated Mar 17, 2026
Search Tags:#visualization#pandas#openpyxl#formulas#spreadsheet#xlsx#csv
One-click install
npx skills add https://github.com/Estom/aiflex --skill spreadsheet-estom
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/Estom/aiflex/tree/main/skills-repo/openai-skills/spreadsheet
Command: npx skills add https://github.com/Estom/aiflex --skill spreadsheet-estom

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Programmatic spreadsheet tasks often break formulas, lose formatting, or require repetitive manual edits; this Skill ensures spreadsheets are created, modified, and validated while preserving formulas, references, and visual layout.

Core Features & Use Cases

  • Preserve formulas and formatting: Use openpyxl to modify .xlsx files without destroying cell formulas or styles.
  • Tabular analysis and conversion: Use pandas for CSV/TSV ingestion, aggregation, pivoting, and exporting to Excel.
  • Visual verification and charts: Prefer openpyxl.chart for native Excel charts and optionally render sheets to PDF/PNG for visual review.
  • Finance-focused conventions: Handles number/date formats, negative-number styling, citation of data sources in cell comments, and IB-style layout conventions for valuation models.
  • Examples: Build financial models, generate KPI dashboards with formulas, or clean and aggregate large CSV datasets into styled workbooks for reporting.

Quick Start

Create a new .xlsx that summarizes monthly sales by region with formulas for totals and growth rates, include a chart, and save the result to output/spreadsheet/monthly_sales.xlsx.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema
How do I edit xlsx files without destroying existing formulas and formatting?▼

To edit xlsx files without destroying formulas and formatting, use openpyxl to modify workbooks while preserving cell formulas, references, styles, and visual layout.

Can I use pandas to aggregate and pivot large CSV datasets for Excel reporting?▼

Yes, you can use pandas for CSV and TSV ingestion, aggregation, pivoting, and exporting to Excel, cleaning large datasets into styled workbooks for reporting.

Does openpyxl evaluate formulas when modifying spreadsheet workbooks?▼

No, openpyxl does not evaluate formulas when modifying spreadsheet workbooks; it preserves formula strings and may require LibreOffice and Poppler for rendering and visual verification.

What is the best way to generate KPI dashboards with native Excel charts?▼

The best way to generate KPI dashboards with native Excel charts is using openpyxl.chart to build financial models with formulas and apply finance-focused layout conventions.

How do I validate spreadsheet layout and formatting modifications visually?▼

To validate spreadsheet layout and formatting modifications visually, render sheets to PDF or PNG using LibreOffice and Poppler for visual review after applying layout-sensitive edits.

Related Skills

Explore More Data & Analytics Skills→
cookeyholdercookeyholder

xlsx

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

Community
Intermediate
diegocamara89diegocamara89
3

spreadsheet

Create, edit, and analyze spreadsheets while preserving formulas and formatting.

Community
Intermediate
Science-DiscoveryScience-Discovery
71

Excel Analysis

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

Official
Intermediate
kollaboraikollaborai
1

xlsx

Create, edit, analyze, and convert Excel spreadsheet files with formulas.

Community
Advanced