xlsx

Create, modify, and analyze Excel, CSV, and TSV spreadsheets with openpyxl.

1|1|Updated Jan 23, 2026
One-click install
npx skills add https://github.com/Hollis36/claude-skill --skill xlsx-hollis36
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Hollis36/claude-skill/tree/main/skills/xlsx
Command: npx skills add https://github.com/Hollis36/claude-skill --skill xlsx-hollis36

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

This skill automates and accelerates spreadsheet-centric tasks that are repetitive and error-prone, such as creating, updating, and analyzing Excel workbooks while preserving formulas and templates to ensure consistency.

Core Features & Use Cases

  • Spreadsheet creation: Generate new workbooks with formulas, formatting, and template structures.
  • Data analysis & reading: Read data from .xlsx, .csv, and .tsv files and perform lightweight analyses.
  • Preserve and update formulas: Modify existing spreadsheets without breaking formulas or predefined styles.
  • Visualization & reporting: Create simple data visualizations and summaries within Excel-compatible formats.
  • Use Case: A finance team auto-generates monthly budget dashboards by wiring data from CSV exports into an Excel template with automatic formula recalculation.

Quick Start

Create a new spreadsheet template with basic formulas and formatting.

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 while preserving existing formulas and styles?

To automate spreadsheet creation while preserving formulas, use a Python openpyxl workflow that modifies workbooks without breaking predefined styles. This approach streamlines repetitive data workflows by applying template structures and formatting programmatically across Excel files.

Can I read and analyze data from CSV and TSV files to generate Excel reports?

Yes, you can read data from .csv and .tsv files and perform lightweight data analysis to generate Excel reports. The workflow imports data from these formats into Excel templates, recalculating formulas using an external LibreOffice-based script to produce updated workbooks.

Does openpyxl support recalculating formulas when updating existing spreadsheets?

openpyxl supports modifying existing spreadsheets and preserving formulas, but formula recalculation requires an external LibreOffice-based script. This pairing ensures that updated data triggers accurate formula recalculation within the modified Excel workbooks.

What is the best way to update financial templates with new data without breaking formatting?

The best way to update financial templates without breaking formatting is using a Python openpyxl workflow. It modifies existing spreadsheets while preserving predefined styles and formulas, ensuring consistency across auto-generated financial dashboards and reports.

How do I create data visualizations and summaries within Excel-compatible formats?

To create data visualizations and summaries within Excel-compatible formats, use a spreadsheet automation workflow that generates workbooks with formulas and formatting. This process builds simple visualizations directly inside the Excel files to streamline data reporting.