xlsx

Create, edit, and audit Excel workbooks with formula validation.

602|121|Updated Feb 10, 2026
One-click install
npx skills add https://github.com/AIDotNet/OpenCowork --skill xlsx-aidotnet
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/AIDotNet/OpenCowork/tree/main/resources/skills/xlsx
Command: npx skills add https://github.com/AIDotNet/OpenCowork --skill xlsx-aidotnet

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill removes the manual burden of building, editing, and auditing spreadsheets, especially when formulas, formatting, and recalculation must stay correct after changes.

Core Features & Use Cases

  • Workbook creation: Generate new Excel files with structured sheets, styles, formulas, and readable layouts.
  • Spreadsheet editing: Update existing .xlsx, .xlsm, .csv, and .tsv files while preserving formulas and formatting.
  • Data analysis and visualization: Prepare tabular data for reporting, summaries, and charts.
  • Formula validation: Recalculate workbooks with LibreOffice support and check for common Excel errors before delivery.
  • Use Case: Turn a raw CSV export into a formatted Excel report with totals, calculations, and verified formula results.

Quick Start

Ask me to create, edit, or analyze the attached spreadsheet and return a finished Excel file with formulas and formatting preserved.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert CSV files to formatted Excel reports with formulas?

To convert CSV files to formatted Excel reports, you can transform raw CSV exports into structured .xlsx workbooks while applying styles, adding calculations, and preserving formulas. The process uses openpyxl and pandas to generate readable layouts with verified totals.

Can I edit existing .xlsx files without breaking formulas and formatting?

Yes, you can edit existing .xlsx, .xlsm, .csv, and .tsv files without breaking formulas and formatting. The Skill updates spreadsheet content while preserving formula logic and applied styles, ensuring the workbook structure remains intact after modifications.

Does openpyxl support spreadsheet recalculation to validate formulas?

openpyxl alone does not fully recalculate formulas, but this Skill uses LibreOffice-style recalculation to validate formulas and check for common Excel errors. This ensures calculated values are correct and prevents formula errors before delivering the file.

What's the best way to automate Excel workbook generation with Python?

The best way to automate Excel workbook generation with Python is using openpyxl and pandas to programmatically create structured sheets, apply styles, and insert formulas. This approach handles generation end-to-end and validates results with LibreOffice-style recalculation.

Why do my Excel formulas show errors after editing an .xlsx file?

Excel formulas show errors after editing when recalculation is not properly triggered. This Skill avoids that by applying LibreOffice-style recalculation to validate formulas and detect common Excel errors, ensuring the delivered spreadsheet has correct, error-free results.

Do I need Python to create and audit spreadsheet files?

Yes, you need Python along with openpyxl and pandas to create and audit spreadsheet files using this Skill. These dependencies enable workbook generation, editing, formula preservation, and the LibreOffice-style recalculation required to validate spreadsheet analysis workflows.