skills.rest
hacket
hacketCOMMUNITY
Explore all skills by this author →
Website𝕏@hacketGitHub

xlsx

Create, edit, and analyze Excel spreadsheets with formulas and formatting.

38|6|Updated Aug 4, 2025
Search Tags:#automation#financial modeling#data analysis#formulas#spreadsheet#excel#libreoffice
One-click install
npx skills add https://github.com/hacket/ClaudeCodeTips --skill xlsx-hacket
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/hacket/ClaudeCodeTips/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/hacket/ClaudeCodeTips --skill xlsx-hacket

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Manually creating, editing, and analyzing complex spreadsheets is time-consuming and prone to errors. This Skill automates these tasks, ensuring accuracy and efficiency, especially for financial models, so you can focus on insights, not data entry.

Core Features & Use Cases

  • Formula-Driven Creation: Build new spreadsheets with dynamic formulas, not hardcoded values, adhering to financial modeling best practices.
  • Advanced Data Analysis: Read, analyze, and visualize data using powerful tools like pandas for quick insights.
  • Error-Free Recalculation: Automatically recalculate formulas and identify/fix errors using LibreOffice integration, guaranteeing data integrity.
  • Use Case: Generate a quarterly financial forecast model, complete with revenue projections, expense calculations, and valuation multiples, ensuring all formulas are correct and color-coded to industry standards.

Quick Start

Create an Excel spreadsheet with a 3-year revenue forecast. Assume 10% growth year-over-year starting from $1M.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create Excel spreadsheets with formulas instead of hardcoded values?▼

Create spreadsheets with dynamic formulas by using openpyxl to build formulas directly into cells rather than static numbers. This ensures calculations update automatically and follows financial modeling best practices for accuracy and maintainability.

Can I automate the creation of financial models in Excel with formulas and formatting?▼

Yes. Automate financial model creation by generating .xlsx files with formula-driven calculations, industry-standard color coding, and number formatting applied programmatically. The Skill handles formula preservation and recalculation validation.

How do I read and analyze data from Excel and CSV files quickly?▼

Analyze spreadsheet data using pandas for fast reading, filtering, and summarization of .xlsx, .xlsm, .csv, and .tsv files. Extract insights without manual data entry or sorting.

What's the best way to ensure Excel formulas are error-free and recalculate correctly?▼

Validate formulas automatically using LibreOffice-based recalculation to identify and fix errors before export. This guarantees data integrity and eliminates formula bugs in financial models.

Can I modify existing Excel templates while keeping formulas intact?▼

Yes. Edit existing .xlsx and .xlsm files while preserving all formulas, formatting, and structure. The Skill maintains template integrity during updates and recalculates dependent cells automatically.

Does this work with LibreOffice spreadsheets and multiple file formats?▼

The Skill supports .xlsx, .xlsm, .csv, and .tsv formats and integrates with LibreOffice for formula validation and recalculation across all supported file types.

Related Skills

Explore More Finance & Accounting Skills→
Benmore-StudioBenmore-Studio
1

xlsx

Parse, clean, and transform spreadsheet data across .xlsx, .xlsm, .csv, and .tsv formats.

Official
Intermediate
kongaharshakongaharsha
1

create-viz

Generate publication-quality static and interactive charts from data.

Community
Intermediate
Gull-StackGull-Stack

xlsx

Create, edit, and analyze Excel spreadsheets with formulas using Python.

Official
Advanced
vuhuudovuhuudo

xlsx

Create, edit, and analyze Excel spreadsheets using pandas and openpyxl.

Community
Advanced