xlsx

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

24|2|Updated Dec 30, 2025

Search Tags:#automation #Excel #formulas #spreadsheet #data-analysis #xlsx #recalculate

Ready to run

npx skills add https://github.com/michaelboeding/skills --skill xlsx-michaelboeding

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/michaelboeding/skills/tree/main/skills/xlsx
Command: npx skills add https://github.com/michaelboeding/skills --skill xlsx-michaelboeding

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill reduces the manual burden of creating, editing, and analyzing spreadsheets by automating common tasks and preserving formulas across changes.

Core Features & Use Cases

Create new spreadsheets with formulas and formatting.
Read, analyze, and visualize data across sheets.
Modify existing spreadsheets while preserving formulas and automatically recalculating results.

Quick Start

Create a new spreadsheet named 'budget.xlsx' with a formatted header row and a simple SUM formula in the Total column.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I create a spreadsheet with formulas that automatically recalculate?▼

Create spreadsheets with formulas by defining cells with SUM, averages, or custom calculations. The Skill automatically recalculates formulas across datasets when data changes, eliminating manual updates and ensuring results stay current.

Can I edit an existing Excel file without losing its formulas?▼

Yes. Modify existing spreadsheets while preserving all formulas and formatting. The Skill maintains formula integrity during edits and automatically recalculates dependent cells, so your data analysis stays intact.

What's the best way to automate spreadsheet creation and data analysis?▼

Automate spreadsheet workflows by generating new sheets with formatted headers and formulas, reading data across multiple sheets, and analyzing results without manual data entry or formula re-entry for each task.

How do I handle large datasets across multiple spreadsheet sheets?▼

Read, analyze, and recalculate formulas across large datasets spanning multiple sheets. The Skill applies consistent formatting and formula logic uniformly, scaling analysis without performance degradation or manual sheet management.

Does this work with standard Excel formatting and functions?▼

Yes. The Skill uses Excel-compatible tools and preserves standard formatting, functions, and formula syntax. Your spreadsheets remain compatible with Excel while gaining automation for creation, modification, and recalculation.

When should I automate spreadsheet tasks instead of editing manually?▼

Automate when you need repeatable spreadsheet creation, consistent formula application, or frequent recalculation across large datasets. Manual editing becomes impractical at scale; automation ensures consistency and eliminates copy-paste errors.