xlsx

Edit, clean, and convert spreadsheet files with formula recalculation.

Updated Apr 5, 2026
One-click install
npx skills add https://github.com/rizaldiem/digital-invitation-web_V2 --skill xlsx-rizaldiem
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/rizaldiem/digital-invitation-web_V2/tree/main/.windsurf/skills/xlsx
Command: npx skills add https://github.com/rizaldiem/digital-invitation-web_V2 --skill xlsx-rizaldiem

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill handles tasks where a spreadsheet file is the primary input or output — opening, reading, cleaning, editing, creating, converting, and validating .xlsx, .xlsm, .csv, and .tsv files — and ensures deliverables are dynamic Excel workbooks with correct formulas and no formula errors.

Core Features & Use Cases

  • Reading & Writing: Load and save Excel and delimited files while preserving templates and formatting.
  • Formula-first Workflows: Insert Excel formulas (never hardcode calculated results), add references across sheets, and enforce formula consistency.
  • Recalculation & Validation: Recalculate formulas using LibreOffice via scripts/recalc.py and scan for Excel errors (#REF!, #DIV/0!, #NAME?, etc.).
  • Repair & Packaging Tools: Utilities to unpack/pack Office files, validate OOXML against XSDs, and repair common XML/template issues.
  • Data Cleaning & Conversion: Restructure malformed tabular data, add computed columns, convert between CSV/TSV/XLSX, and produce clean deliverables.
  • Use Case Example: Convert a messy export (malformed CSV) into a multi-sheet .xlsx, add dynamic formulas and scenario inputs, run recalculation, and return an error-free, production-ready workbook.

Quick Start

Open 'sales_export.csv', clean malformed rows and headers, add a totals column with an Excel formula linking sheets, recalculate formulas using scripts/recalc.py, and save the result as 'sales_model.xlsx'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I fix malformed rows and headers in a messy CSV export?

To fix malformed rows and headers in a messy CSV export, this Skill cleans and restructures tabular data, repairs formatting issues, and saves the result as a validated .xlsx, .csv, or .tsv file.

Can I insert dynamic Excel formulas instead of hardcoded values when generating xlsx files?

Yes, you can insert dynamic Excel formulas instead of hardcoded values. It enforces a formula-first workflow, adding references across sheets to ensure calculations remain dynamic and update automatically.

How do I recalculate Excel formulas and check for errors like #REF! or #DIV/0!?

You recalculate Excel formulas and check for errors like #REF! or #DIV/0! by running a recalculation script via LibreOffice, which evaluates the workbook and scans for any existing formula errors.

Does openpyxl support converting between CSV, TSV, and XLSX formats?

Yes, openpyxl supports converting between CSV, TSV, and XLSX formats. The Skill loads delimited files, restructures the tabular data, and exports clean deliverables across these supported formats.

What is the best way to create a multi-sheet financial model from an existing spreadsheet?

The best way to create a multi-sheet financial model from an existing spreadsheet is to load the source data, add computed columns with dynamic formulas, link scenario inputs across sheets, and validate the final workbook.

Why do I need LibreOffice to validate an Excel workbook generated with openpyxl?

You need LibreOffice to validate an Excel workbook because openpyxl writes formulas without computing their results. LibreOffice recalculates the formulas to ensure they evaluate correctly and contain zero Excel errors.