xlsx

Create, edit, and analyze spreadsheets while preserving formulas and formatting.

Updated Feb 6, 2026
One-click install
npx skills add https://github.com/chadananda/xswarm-tdd-claude --skill xlsx-chadananda
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/chadananda/xswarm-tdd-claude/tree/main/skills/xlsx
Command: npx skills add https://github.com/chadananda/xswarm-tdd-claude --skill xlsx-chadananda

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill addresses the time-consuming task of creating, editing, and analyzing spreadsheets while preserving formulas and formatting, ensuring consistency across workbooks.

Core Features & Use Cases

  • Spreadsheet creation: Create new workbooks with formulas, formatting, and styles that align with templates.
  • Data analysis and reporting: Read, analyze, and visualize data in spreadsheets, producing reliable insights without breaking formulas.
  • Template maintenance: Modify existing spreadsheets while preserving formulas and established conventions.
  • Use Case: Imagine generating a quarterly sales workbook with a totals row that updates automatically when inputs change.

Quick Start

Create a new workbook with a data table and a simple formula (e.g., =SUM(B2:B10)), then recalculate formulas using recalc.py to verify correctness.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I edit Excel spreadsheets without breaking formulas?

To edit Excel spreadsheets without breaking formulas, you need a process that enforces formula integrity. This skill modifies existing .xlsx and .xlsm sheets while automatically preserving formulas, formatting, and established conventions.

Can I create a new xlsx workbook with formulas that update automatically?

Yes, you can create a new xlsx workbook with formulas that update automatically. This skill generates workbooks with Excel-compatible formulas and invokes a recalculation script to verify totals update correctly when inputs change.

Does this spreadsheet automation approach support CSV and TSV files?

Yes, this spreadsheet automation approach supports CSV and TSV files. It reads, analyzes, and modifies data across common formats including .xlsx, .xlsm, .csv, and .tsv while enforcing formula integrity.

What is the best way to automate data analysis and reporting in Excel?

The best way to automate data analysis and reporting in Excel is using a process that reads, analyzes, and visualizes data while maintaining formatting. This skill produces reliable insights and reproducible results without breaking existing formulas.

How do I recalculate formulas across an entire workbook?

To recalculate formulas across an entire workbook, you need a full recalculation process that enforces reproducible results. This skill uses a dedicated recalculation script to process Excel-compatible formulas across your spreadsheets.

Why do my spreadsheet formulas stop working after automated edits?

Your spreadsheet formulas stop working after automated edits because formula integrity is not preserved. This skill solves that by enforcing Excel-compatible formulas and template preservation during any sheet modification or data injection.