spreadsheet

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

Updated Mar 7, 2026

Search Tags:#reporting #data analysis #pandas #openpyxl #formulas #spreadsheet #excel

Ready to run

npx skills add https://github.com/shalevamin/The-_Ultimate_agents --skill spreadsheet-shalevamin

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/shalevamin/The-_Ultimate_agents/tree/main/.claude/skills/spreadsheet
Command: npx skills add https://github.com/shalevamin/The-_Ultimate_agents --skill spreadsheet-shalevamin

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, modification, and analysis of spreadsheet files, streamlining data management and reporting tasks.

Core Features & Use Cases

Spreadsheet Creation: Generate new .xlsx or .csv files with custom data, formulas, and formatting.
Data Analysis: Perform calculations, aggregations, and transformations on tabular data.
Formula Management: Apply and preserve complex formulas, ensuring accurate recalculations.
Use Case: Automatically generate a monthly sales report by pulling data from a database, calculating year-over-year growth, and formatting it with clear headers and currency values.

Quick Start

Use the spreadsheet skill to create a new Excel file named 'sales_report.xlsx' with columns for 'Month', 'Revenue', and 'Growth'.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema

How do I automate Excel report generation and apply formulas?▼

Automate Excel report generation by using this Skill to create `.xlsx` files, apply custom formulas, and format headers and currency values. It handles formula-aware workflows and cached recalculations for accurate reporting.

Can I use pandas for data analysis on CSV and TSV files?▼

Yes, you can use pandas for data analysis on CSV and TSV files. This Skill utilizes pandas specifically for transforming, aggregating, and analyzing tabular CSV and TSV data workflows.

What's the best way to edit existing xlsx workbooks with openpyxl?▼

The best way to edit existing `.xlsx` workbooks is using this Skill's openpyxl integration. It modifies existing workbooks, preserves complex formulas, and applies visual formatting changes directly to the file.

Does this spreadsheet tool support formula-aware calculations?▼

Yes, this spreadsheet tool supports formula-aware workflows and cached recalculations. It applies and preserves complex formulas within `.xlsx` files, ensuring accurate recalculations when modifying or generating workbooks.

What are the limitations of pandas for modifying Excel formatting?▼

Pandas is primarily used here for data analysis and CSV/TSV workflows. For modifying `.xlsx` visual formatting, creating custom layouts, and preserving complex formulas, this Skill relies on openpyxl instead.

Do I need openpyxl and pandas installed to create spreadsheets?▼

Yes, you need both openpyxl and pandas installed. These dependencies are required to handle `.xlsx` manipulation, perform data analysis, and process CSV and TSV tabular data formats.