xlsx

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

804|117|Updated Oct 4, 2025
One-click install
npx skills add https://github.com/tfriedel/claude-office-skills --skill xlsx-tfriedel
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/tfriedel/claude-office-skills/tree/main/public/xlsx
Command: npx skills add https://github.com/tfriedel/claude-office-skills --skill xlsx-tfriedel

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill eliminates the tedious, error-prone, and time-consuming manual work involved in spreadsheet creation, editing, and analysis. It ensures data accuracy and adherence to complex formatting standards, especially for financial models.

Core Features & Use Cases

  • Comprehensive Spreadsheet Management: Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files.
  • Formula & Formatting Mastery: Work with complex formulas, apply advanced formatting, and perform data analysis and visualization.
  • Financial Model Compliance: Adhere to industry-standard color coding, number formatting, and formula construction rules for financial models.
  • Automated Recalculation & Error Detection: Automatically recalculate formulas and identify common Excel errors (e.g., #REF!, #DIV/0!) to ensure data integrity.
  • Use Case: Automatically generate a monthly financial report, populating it with data, applying specific financial formatting (e.g., blue for inputs, black for formulas), and verifying all calculations are error-free before delivery.

Quick Start

Recalculate formulas in an Excel file and check for errors

This script automatically configures LibreOffice on first run.

python recalc.py output.xlsx

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation with formulas and formatting?

Automate spreadsheet creation by using openpyxl to programmatically add formulas, apply financial formatting conventions (blue for inputs, black for formulas), and generate `.xlsx` files. The Skill handles formula construction and color-coding standards to ensure compliance with industry requirements.

How can I verify that formulas in my Excel workbook are error-free?

Run recalc.py on your `.xlsx` file to automatically recalculate all formulas using LibreOffice and detect common errors like #REF! and #DIV/0!. This ensures data integrity before sharing financial reports or models.

Can I edit existing Excel spreadsheets while preserving formulas and templates?

Yes. The Skill modifies existing `.xlsx`, `.xlsm`, `.csv`, and `.tsv` files while maintaining existing formulas, templates, and formatting. Changes integrate seamlessly without disrupting your original structure or calculations.

What's the best way to apply financial modeling standards to spreadsheets?

Use the Skill to enforce industry-standard formatting: blue cell colors for inputs, black for formula results, proper number formatting, and cell reference conventions. This ensures your financial models meet compliance and readability standards consistently.

How do I analyze and visualize data in Excel files programmatically?

The Skill reads and analyzes `.xlsx` data using pandas and openpyxl, enabling data extraction, transformation, and visualization. This eliminates manual data handling and ensures accuracy across complex datasets.

Does this work with CSV and TSV files, or only Excel?

The Skill handles `.xlsx`, `.xlsm`, `.csv`, and `.tsv` files, so you can create, edit, and analyze spreadsheets across multiple formats. This flexibility lets you work with data regardless of its original file type.