skills.rest
shalevamin
shalevaminCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/shalevamin/The-_Ultimate_agents --skill spreadsheet-shalevamin
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
jaimedhenriquesjaimedhenriques

spreadsheet

Create and update spreadsheet files while preserving formulas, formatting, and workbook structure.

Community
Advanced
ItsJupiter000ItsJupiter000

excel-generator

Generate formatted Excel workbooks with formulas, charts, and data validation.

Community
Intermediate
jeffpeckyjeffpecky

xlsx

Automate Excel workflows with pandas and openpyxl for data analysis and editing.

Community
Advanced
spandiosspandios

spreadsheet

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

Community
Intermediate