skills.rest
cdeistopened
cdeistopenedCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze .xlsx, .xlsm, and .csv files with pandas.

24|6|Updated Nov 15, 2025
Search Tags:#financial modeling#data analysis#pandas#spreadsheet#excel#xlsx#formula
One-click install
npx skills add https://github.com/cdeistopened/skill-stack --skill xlsx-cdeistopened
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/cdeistopened/skill-stack/tree/main/.claude/skills/anthropic-skills/skills/xlsx
Command: npx skills add https://github.com/cdeistopened/skill-stack --skill xlsx-cdeistopened

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers users to create, edit, and analyze spreadsheet data with advanced formula support, formatting, and data analysis capabilities, eliminating manual spreadsheet drudgery.

Core Features & Use Cases

  • Formula Creation & Management: Generate complex formulas, ensure zero formula errors, and maintain existing templates.
  • Data Analysis & Visualization: Utilize pandas for in-depth data analysis and visualization directly within spreadsheet workflows.
  • Formatting & Standards: Adheres to industry-standard color-coding and number formatting for financial models.
  • Use Case: Transform raw sales data into a dynamic financial forecast, complete with industry-standard formatting and error-checked formulas, ready for presentation.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_forecast.xlsx' with columns for 'Month', 'Revenue', and 'Growth Rate', including a formula in the 'Growth Rate' column to calculate the percentage change from the previous month.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I generate complex Excel formulas and ensure there are zero errors in my spreadsheet?▼

You can generate complex Excel formulas programmatically and validate them using LibreOffice recalculation to ensure zero formula errors while maintaining existing templates and adhering to financial modeling standards.

Can I use pandas for data analysis directly within an xlsx spreadsheet workflow?▼

Yes, pandas is integrated directly into the spreadsheet workflow to perform in-depth data analysis and visualization, allowing you to manipulate and analyze .xlsx, .xlsm, and .csv file data seamlessly without leaving the environment.

Do I need LibreOffice to recalculate formulas and validate financial models?▼

Yes, LibreOffice is a required dependency for recalculating formulas and validating spreadsheet data, executed via a dedicated recalc.py script to guarantee accuracy and zero formula errors in your financial models.

What is the best way to apply industry-standard color-coding and formatting to a financial forecast?▼

Automated spreadsheet operations enforce industry-standard color-coding and number formatting for financial models, transforming raw data into presentation-ready dynamic forecasts while strictly adhering to established formatting standards.

Does this spreadsheet tool support editing .xlsm and .csv files alongside standard .xlsx formats?▼

Yes, comprehensive spreadsheet operations support creating, editing, and analyzing .xlsx, .xlsm, and .csv files, enabling seamless data manipulation, formula generation, and formatting across all three file formats.

Related Skills

Explore More Finance & Accounting Skills→
jeffpeckyjeffpecky

xlsx

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

Community
Advanced
chekoschekos
5

financial-models

Provide financial modeling templates for revenue forecasting and P&L statements.

Community
Basic
7126112171261121

xlsx

Create, edit, and analyze Excel spreadsheet files with formulas and formatting.

Community
Advanced
rezosndrezosnd

excel-generator

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

Community
Intermediate