spreadsheet

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

8|4|Updated Jan 15, 2026

Search Tags:#automation #formatting #data analysis #formulas #spreadsheet #excel

Ready to run

npx skills add https://github.com/jscraik/Agent-Skills --skill spreadsheet-jscraik

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/jscraik/Agent-Skills/tree/main/utilities/spreadsheet
Command: npx skills add https://github.com/jscraik/Agent-Skills --skill spreadsheet-jscraik

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation, editing, analysis, and formatting of spreadsheet files, ensuring data integrity and efficient workflows.

Core Features & Use Cases

Formula-aware Workflows: Create and modify spreadsheets with robust formula support.
Data Analysis & Formatting: Analyze tabular data, apply consistent styling, and generate charts.
Use Case: Generate a monthly sales report by analyzing raw sales data, applying financial formatting, and creating summary charts within an .xlsx file.

Quick Start

Use the spreadsheet skill to create a new workbook with sales data and formulas.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema

How do I automate spreadsheet creation and formatting in Excel files?▼

Spreadsheet automation handles workbook creation, formatting, and formula preservation for .xlsx files using Python libraries like openpyxl and pandas, ensuring data integrity and presentation-ready outputs.

Can I edit existing .xlsx and .csv files without breaking formulas?▼

Yes, formula-aware workflows support modifying existing .xlsx, .csv, and .tsv files while preserving formulas and maintaining deterministic workbook edits to ensure data integrity.

How does pandas data analysis integrate with Excel formatting for report generation?▼

Data analysis with pandas processes raw tabular data, applies consistent visual styling, and generates summary charts within an .xlsx file to produce presentation-ready financial reports.

Do I need openpyxl and pandas installed to automate spreadsheet workflows?▼

Yes, openpyxl and pandas are required dependencies for executing spreadsheet automation, as they provide the underlying Python libraries for workbook manipulation and tabular data analysis.

What is the best way to apply financial formatting to raw sales data in Excel?▼

The best way is using spreadsheet automation to analyze raw sales data, apply consistent financial formatting, and create summary charts within an .xlsx file for structured reporting.

Are there limitations when using openpyxl for spreadsheet automation compared to other tools?▼

Openpyxl focuses on deterministic workbook edits and formula preservation for .xlsx files, meaning it may lack advanced interactive features found in other spreadsheet automation tools within the same category.