spreadsheet

Create, edit, and analyze spreadsheets with openpyxl and pandas.

Updated Apr 12, 2026
One-click install
npx skills add https://github.com/BoraPerusic/agents --skill spreadsheet-boraperusic
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/BoraPerusic/agents/tree/main/skills/to%20try/spreadsheet
Command: npx skills add https://github.com/BoraPerusic/agents --skill spreadsheet-boraperusic

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill reduces the manual effort of creating, editing, validating, and formatting spreadsheets, while ensuring formulas and data structures remain intact across tasks.

Core Features & Use Cases

  • Create and initialize workbooks with multiple sheets and predefined headers.
  • Edit data, maintain formulas, apply styling, and generate simple charts or summaries.
  • Analyze data with basic to intermediate transformations using openpyxl and pandas, then export to .xlsx or .csv.

Quick Start

Create a new workbook, input data, and define core formulas to produce live results.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema
How do I create an Excel workbook with multiple sheets and formulas?

To create an Excel workbook with multiple sheets, you can initialize a new file, define headers, and input core formulas to produce live results. This process builds structured workbooks while preserving formulas and applying styling.

Can I edit existing .xlsx files without losing formulas and styling?

Yes, you can edit existing .xlsx files without losing formulas and styling. The process applies data transformations and updates business reports while ensuring formulas and data structures remain intact across tasks.

How do I analyze spreadsheet data using pandas and export to CSV?

To analyze spreadsheet data using pandas, you perform basic to intermediate data transformations and generate summaries. After analyzing the data, you can export the final output to either .xlsx or .csv format.

Does openpyxl support generating charts and summaries for business reports?

Yes, openpyxl supports generating simple charts and summaries for business reports. It works alongside pandas to automate data transformations, validate workbooks, and output formatted results.

What is the best way to automate end-to-end spreadsheet creation and validation?

The best way to automate end-to-end spreadsheet creation and validation is to use openpyxl and pandas. This approach reduces manual effort, maintains data structures, and outputs formatted .xlsx or .csv files.