xlsx

Create and edit .xlsx/.xlsm/.csv/.tsv files with formula-based results and recalculation.

7|2|Updated Apr 30, 2026
One-click install
npx skills add https://github.com/MRWillisT/PullNexus --skill xlsx-mrwillist
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/MRWillisT/PullNexus/tree/main/skills/xlsx
Command: npx skills add https://github.com/MRWillisT/PullNexus --skill xlsx-mrwillist

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Excel work often involves tedious editing, fragile updates, and formula errors that are hard to diagnose after the fact, especially when spreadsheet changes must stay consistent and recalculable.

Core Features & Use Cases

  • Creates and transforms spreadsheets: Build new Excel workbooks from scratch and convert tabular data formats (.csv/.tsv/.xlsx).
  • Edits existing workbooks safely: Update templates while preserving existing formats, styles, and conventions.
  • Prevents broken models: Enforce ZERO Excel formula errors and recalculates formulas reliably using LibreOffice.

Quick Start

Use the xlsx skill to clean and restructure the spreadsheet located at 'messy-data.xlsx' into a corrected workbook with valid formulas and zero Excel errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I edit existing Excel templates without breaking formulas and formatting?

To edit Excel templates without breaking formatting, use openpyxl to update cell values while preserving existing styles, conventions, and formula structures, ensuring template integrity remains intact throughout the modification process.

Can I convert CSV or TSV files into a formatted xlsx workbook with working formulas?

Yes, you can convert CSV or TSV files into xlsx workbooks by transforming tabular data inputs into dynamic Excel deliverables, replacing hardcoded values with valid formulas, and running recalculation to ensure zero formula errors.

Why does my spreadsheet recalculation produce formula errors after automated updates?

Spreadsheet recalculation errors often occur when automated updates inject hardcoded values instead of formula-based results, which is why running a reliable recalc process through LibreOffice enforces zero Excel formula errors.

What is the best way to clean messy spreadsheet data and fix broken Excel formulas?

The best way to clean messy spreadsheet data involves restructuring inputs into corrected workbooks, applying formula-based logic instead of static values, and running a recalculation step to verify zero Excel formula errors.

Does openpyxl support preserving styles and conventions when updating xlsm files?

Yes, openpyxl supports editing xlsm files by preserving existing formats, styles, and template conventions during updates, allowing safe modifications while maintaining the original workbook's visual and structural integrity.

How do I generate new Excel workbooks from scratch with dynamic formulas instead of static values?

To generate Excel workbooks with dynamic formulas, build the file from scratch using openpyxl to inject formula-based results rather than Python hardcoded values, then run recalculation to validate the deliverable.