spreadsheet
Tool for manipulating and analyzing spreadsheets using Python libraries.
Install
mkdir -p .claude/skills/spreadsheet-cdrguru && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/13500" && unzip -o skill.zip -d .claude/skills/spreadsheet-cdrguru && rm skill.zipInstalls to .claude/skills/spreadsheet-cdrguru
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
Use when tasks involve creating, editing, analyzing, or formatting spreadsheets (`.xlsx`, `.csv`, `.tsv`) using Python (`openpyxl`, `pandas`), especially when formulas, references, and formatting need to be preserved and verified.Key capabilities
- →Build new workbooks with formulas and formatting
- →Read and analyze tabular data
- →Modify existing workbooks without breaking formulas
- →Visualize data with charts
- →Validate formulas and references
How it works
The skill confirms file type and goals, uses `openpyxl` for `.xlsx` edits and `pandas` for analysis, then validates formulas and saves outputs.
Inputs & outputs
When to use spreadsheet
- →Automate Excel report generation
- →Analyze tabular data
- →Modify workbook structure
About spreadsheet
Provides automated editing for .xlsx and .csv files while preserving formatting, references, and formulas.
Use when tasks involve creating, editing, analyzing, or formatting spreadsheets (`.xlsx`, `.csv`, `.tsv`) using Python (`openpyxl`, `pandas`), especially when formulas, references, and formatting need to be preserved and verified.
When not to use it
- →When the task does not involve spreadsheets (`.xlsx`, `.csv`, `.tsv`)
- →When `openpyxl` or `pandas` are not suitable for the task
Prerequisites
Limitations
- →`openpyxl` does not evaluate formulas
- →If rendering tools are unavailable, ask the user to review the output locally
How it compares
This skill provides a structured workflow for spreadsheet manipulation and analysis using specific Python libraries, ensuring formula integrity and formatting, unlike manual editing.
Compared to similar skills
spreadsheet side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| spreadsheet (this skill) | 0 | 6mo | No flags | Intermediate |
| Excel Analysis | 0 | 5mo | No flags | Intermediate |
| csv-data-summarizer | 15 | 11mo | Review | Beginner |
| finance-manager | 12 | 10mo | Review | Intermediate |
Try saying
Example prompts that trigger this skill in your AI assistant.
More by cdrguru
View all by cdrguru →You might also like
Excel Analysis
Joyooosama
Analyze Excel spreadsheets, create pivot tables, generate charts, and perform data analysis. Use when analyzing Excel files, spreadsheets, tabular data, or .xlsx files.
csv-data-summarizer
coffeefuelbump
Analyzes CSV files, generates summary stats, and plots quick visualizations using Python and pandas.
finance-manager
ailabs-393
Comprehensive personal finance management system for analyzing transaction data, generating insights, creating visualizations, and providing actionable financial recommendations. Use when users need to analyze spending patterns, track budgets, visualize financial data, extract transactions from PDFs, calculate savings rates, identify spending trends, generate financial reports, or receive personalized budget recommendations. Triggers include requests like "analyze my finances", "track my spending", "create a financial report", "extract transactions from PDF", "visualize my budget", "where is my money going", "financial insights", "spending breakdown", or any finance-related analysis tasks.
xlsx
anthropics
Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
excel-analysis
davila7
Analyze Excel spreadsheets, create pivot tables, generate charts, and perform data analysis. Use when analyzing Excel files, spreadsheets, tabular data, or .xlsx files.
spreadsheet-formula-helper
ComposioHQ
Write and debug spreadsheet formulas (Excel/Google Sheets), pivot tables, and array formulas; translate between dialects; use when users need working formulas with examples and edge-case checks.