xlsx

Create and edit Excel spreadsheets with Python and openpyxl.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/Evilander/ClaudeFileOutput --skill xlsx-evilander
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Evilander/ClaudeFileOutput/tree/main/xlsx
Command: npx skills add https://github.com/Evilander/ClaudeFileOutput --skill xlsx-evilander

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

This Skill automates the creation, editing, and analysis of spreadsheets across Excel formats while preserving templates and existing formulas, reducing manual toil and error-prone updates.

Core Features & Use Cases

  • Spreadsheet creation & editing: Generate new workbooks with formulas, formatting, and data structures that align with established templates.
  • Data analysis & visualization readiness: Read, analyze, and structure data for downstream reporting or visualization while preserving calculations.
  • Template preservation & updates: Modify existing workbooks while respecting original styles, conventions, and embedded formulas.
  • Use Case: Imagine updating a quarterly financial model in an existing template without breaking any formulas, while recalculating and validating results.

Quick Start

Use the xlsx skill to create a new spreadsheet with formulas and formatting, or to modify an existing workbook while preserving formulas.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I edit an Excel template without breaking existing formulas?

To edit an Excel template without breaking existing formulas, this Skill modifies .xlsx workbooks while preserving original styles, conventions, and embedded calculations. It updates data structures reliably without overwriting formula logic.

Can I automate spreadsheet creation with formulas and formatting across different Excel formats?

Yes, you can automate spreadsheet creation across Excel formats. This Skill generates new workbooks with formulas, formatting, and data structures in .xlsx, .xlsm, .csv, and .tsv files, aligning outputs with established templates for reporting.

Does openpyxl support recalculating formulas in modified Excel workbooks?

openpyxl handles spreadsheet operations for Excel workbooks but does not natively recalculate formulas. This Skill uses LibreOffice via the recalc.py script to perform formula recalculation and validate results in modified .xlsx files.

What is the best way to update a financial model in an existing workbook while recalculating results?

The best way to update a financial model in an existing workbook while recalculating results is using automated spreadsheet modification. This Skill edits data while preserving formulas and uses LibreOffice for accurate formula recalculation.

What file formats are supported for automated spreadsheet data analysis and reporting?

Supported file formats for automated spreadsheet data analysis and reporting include .xlsx, .xlsm, .csv, and .tsv. The Skill reads, analyzes, and structures data across these formats while preserving calculations for downstream visualization.

How do I prepare data for visualization without losing embedded spreadsheet calculations?

To prepare data for visualization without losing embedded spreadsheet calculations, use this Skill to read, analyze, and structure data while preserving formulas. It ensures calculation integrity remains intact for downstream reporting workflows.