xlsx

Automate spreadsheet creation, editing, and analysis with formula preservation.

1|Updated Feb 2, 2026

Search Tags:#automation #formulas #spreadsheet #excel #data-analysis #xlsx #recalculation

Ready to run

npx skills add https://github.com/coolsocket/skills-for-GCP --skill xlsx-coolsocket

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automate the creation, editing, and analysis of spreadsheets to replace tedious manual work, ensuring formulas stay intact and results stay consistent across workflows.

Core Features & Use Cases

Create new spreadsheets with formulas and formatting, based on templates or data inputs.
Read, analyze, and modify existing workbooks while preserving formulas and templates.
Recalculate formulas across sheets to ensure up-to-date results, and generate data visualizations or reports from spreadsheet data.

Quick Start

Create a new workbook from your data, apply formatting, and recalculate all formulas.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I automate spreadsheet creation and analysis while preserving formulas?▼

To automate spreadsheet creation and analysis while preserving formulas, you can use this Skill to generate, edit, and recalculate workbooks end-to-end. It leverages Python libraries like openpyxl to ensure deterministic formula handling and template preservation.

What is cross-sheet recalculation and when do I need it for Excel analytics?▼

Cross-sheet recalculation updates formula results across multiple worksheet tabs to ensure data consistency. You need it for Excel analytics and reporting tasks when dependent values change, which this Skill handles using a LibreOffice-based recalc pipeline.

Can I modify existing Excel workbooks without breaking formatting and templates?▼

Yes, you can read, analyze, and modify existing Excel workbooks without breaking formatting and templates. The Skill preserves your original template structures while applying data-cleaning, budget planning, or analytics modifications programmatically.

Does this approach work with both Excel and CSV formats for data-cleaning tasks?▼

Yes, this approach works with both Excel and CSV formats for data-cleaning tasks. It automates end-to-end editing and analysis across both file types, ensuring reproducible data structures and consistent reporting outputs.

What's the best way to generate data visualizations from spreadsheet data programmatically?▼

The best way to generate data visualizations from spreadsheet data programmatically is using an automation pipeline that recalculates formulas first. This Skill ensures your visualizations reflect up-to-date results by running a LibreOffice-based recalculation before reporting.

Why do my Excel formulas return stale cached values when processed by scripts?▼

Excel formulas return stale cached values when processed by scripts because standard libraries do not execute formula calculations. This Skill solves the issue by applying a LibreOffice-based recalc pipeline to force cross-sheet recalculation for accurate results.