skills.rest
heyzude
heyzudeCOMMUNITY
Explore all skills by this author →
GitHub

spreadsheet

Create, edit, analyze, and format .xlsx, .csv, and .tsv spreadsheet files.

4|Updated Feb 13, 2026
Search Tags:#automation#reporting#data analysis#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/heyzude/skills_for_codex --skill spreadsheet-heyzude
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/heyzude/skills_for_codex/tree/main/skills_by_openai/spreadsheet
Command: npx skills add https://github.com/heyzude/skills_for_codex --skill spreadsheet-heyzude

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, matplotlib, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the creation, editing, analysis, and formatting of spreadsheets, eliminating manual data manipulation and ensuring formula accuracy.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new workbooks or modify existing ones with formulas, formatting, and structured layouts.
  • Data Analysis & Visualization: Analyze tabular data, compute metrics, and create charts within spreadsheets.
  • Formula-Aware Workflows: Ensures formulas are correctly applied and recalculated, preserving data integrity.
  • Use Case: Automatically generate a monthly sales report by pulling data from multiple sources, applying complex calculations, and formatting it for clear presentation.

Quick Start

Use the spreadsheet skill to create a new workbook with sales data for Q1.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema
How do I automate Excel spreadsheet creation and editing with formulas?▼

You can automate spreadsheet creation and editing using openpyxl to generate .xlsx workbooks with structured layouts, applying formulas correctly and preserving data integrity through cached recalculation.

What is the best way to analyze CSV and TSV files for automated reporting?▼

Analyzing CSV and TSV files for automated reporting is handled by pandas, which computes metrics from tabular data and can optionally generate charts within spreadsheets using openpyxl.chart.

Does this spreadsheet automation approach support formula-aware workflows?▼

Yes, formula-aware workflows are supported, ensuring that formulas applied during spreadsheet creation or editing are correctly managed and recalculated to maintain accurate cached values.

Can I use pandas for spreadsheet data analysis and then visualize the results?▼

You can use pandas for spreadsheet data analysis to compute metrics, and then visualize the results by creating charts directly within the spreadsheet files using openpyxl.chart.

How do I visually review rendered spreadsheets after automated formatting?▼

To visually review rendered spreadsheets after automated formatting, the skill utilizes LibreOffice and Poppler to render the sheets, allowing you to inspect the final visual output.

What are the limitations of using openpyxl for spreadsheet manipulation?▼

While openpyxl handles .xlsx spreadsheet manipulation, .csv and .tsv processing relies on pandas, meaning visual rendering and charting depend on optional external tools like LibreOffice and Poppler.

Related Skills

Explore More Data & Analytics Skills→
shalevaminshalevamin

spreadsheet

Create, edit, analyze, and format .xlsx, .csv, and .tsv spreadsheet files.

Community
Intermediate
soq123soq123

excel-generator

Generate and format Excel workbooks with formulas, charts, and pivot summaries using Python.

Community
Advanced
Buntyarora97Buntyarora97

excel-generator

Create Excel spreadsheets with formatting, formulas, charts, and data validation.

Community
Advanced
HunterMcGrewHunterMcGrew

prism-data

Analyze business metrics and generate dashboards with xlsx integration.

Community
Advanced