xlsx

Create and edit Excel workbooks with openpyxl and recalc.py.

2|1|Updated Feb 9, 2026
One-click install
npx skills add https://github.com/costa-marcello/skillkit --skill xlsx-costa-marcello
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/costa-marcello/skillkit/tree/main/skills/xlsx
Command: npx skills add https://github.com/costa-marcello/skillkit --skill xlsx-costa-marcello

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This skill automates the creation, editing, and analysis of Excel workbooks, helping users maintain formula integrity and consistent formatting while handling multiple formats.

Core Features & Use Cases

  • Create new workbooks from scratch and build financial models with clear, auditable formulas.
  • Read, modify, and analyze data across multiple sheets while preserving existing formulas and formats.
  • Recalculate formulas programmatically and validate results using the included recalc script.

Quick Start

Create a new Excel workbook with a sample dataset, then run the recalc script to verify all formulas compute without errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel workbook creation and editing without breaking existing formulas?

Automate Excel workbook creation and editing using openpyxl to read, modify, and analyze data across multiple sheets while preserving existing formulas and maintaining consistent formatting.

Can I programmatically recalculate formulas in .xlsx and .xlsm files?

Yes, you can programmatically recalculate formulas in .xlsx and .xlsm files using the included recalc.py script to verify results and ensure all formulas compute without errors.

Does this openpyxl workflow support building financial models from scratch?

Yes, this openpyxl workflow supports building financial models from scratch by creating new workbooks with clear, auditable formulas and applying consistent formatting across multiple sheets.

What is the best way to process CSV and TSV files for data cleaning and report generation?

The best way to process CSV and TSV files for data cleaning and report generation is using an automated Excel workflow that handles multiple formats, validates formulas, and generates reports across sheets.

Why do my Excel formulas lose integrity when I edit workbooks across multiple sheets?

Excel formulas lose integrity during manual editing across multiple sheets, but automating workbook manipulation with openpyxl and running a recalc script ensures formula integrity and validates computed results.

Do I need openpyxl installed to automate .xlsx, .xlsm, .csv, and .tsv workflows?

Yes, you need openpyxl installed as the core dependency to automate workbook creation, editing, and analysis across .xlsx, .xlsm, .csv, and .tsv formats including financial models and data cleaning.