skills.rest
mdnaimul22
mdnaimul22COMMUNITY
Explore all skills by this author →
GitHub

xlsx

Build, edit, and convert .xlsx/.xlsm/.csv/.tsv spreadsheets with formula recalculation.

2|Updated Apr 15, 2026
Search Tags:#financial modeling#xlsx#data conversion#formula recalculation#template preservation#spreadsheet cleaning
One-click install
npx skills add https://github.com/mdnaimul22/human-skills --skill xlsx-mdnaimul22
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/mdnaimul22/human-skills/tree/main/skills/xlsx
Command: npx skills add https://github.com/mdnaimul22/human-skills --skill xlsx-mdnaimul22

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, LibreOffice, validators, and includes scripts (resource) components.

What problem does it solve?

This Skill eliminates the guesswork of working with spreadsheets by ensuring your deliverable spreadsheet files are correctly edited, converted, and recalculated—without formula errors.

Core Features & Use Cases

  • Spreadsheet creation, editing, and conversion: Build or modify .xlsx/.xlsm files and convert between tabular formats (including cleanup of messy data).
  • Formula-safe updates: Enforces “use formulas, not hardcoded results” and prevents common Excel formula errors.
  • Mandatory recalculation + verification: Recalculates formulas via LibreOffice (with automated macro setup) and checks for Excel error markers like #REF!, #DIV/0!, #VALUE!, and #NAME?.
  • Financial model guardrails: Applies consistent formatting and color conventions for assumptions and links (including template preservation).

Quick Start

Create or fix the spreadsheet at "report.xlsx" so all formulas recalculate cleanly and the output has zero Excel formula errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert and clean messy tabular data into a valid xlsx file?▼

Spreadsheet conversion and cleaning restructures messy tabular data into error-free .xlsx, .xlsm, .csv, or .tsv files. It opens existing files by path, normalizes tabular formats, and adds required columns while preserving original templates.

Can I use LibreOffice to recalculate Excel formulas and detect errors automatically?▼

Yes, LibreOffice-based formula recalculation runs automated macros to recompute formulas and detect Excel error tokens like #REF!, #DIV/0!, #VALUE!, #N/A, and #NAME?. This prevents hardcoded calculated values by enforcing actual Excel formulas.

What's the best way to build financial models in xlsx without formula errors?▼

Building financial models requires using Excel formulas instead of hardcoded results, applying consistent formatting and color conventions for assumptions and links, and verifying zero formula errors through mandatory LibreOffice recalculation.

Does pandas support converting csv to xlsx while preserving existing template formatting?▼

Yes, pandas combined with openpyxl converts .csv to .xlsx while preserving existing template formatting. The process updates spreadsheets with formulas and charts, ensuring template structures remain intact during data transformation.

Why does my spreadsheet conversion keep producing #REF! and #VALUE! errors?▼

Spreadsheet conversion produces #REF! and #VALUE! errors when formulas reference deleted cells or mismatched data types. The Skill addresses this by enforcing proper formula usage and running LibreOffice recalculation to detect and flag these specific Excel error tokens.

Related Skills

Explore More Data & Analytics Skills→
yukieijiyukieiji

xlsx

Create, edit, and analyze Excel files using pandas and openpyxl.

Community
Advanced
Ryno-Crypto-Mining-ServicesRyno-Crypto-Mining-Services

xlsx

Create, edit, and analyze spreadsheets while preserving formulas and templates.

Official
Advanced
KnoWhizKnoWhiz
6

spreadsheet

Create, edit, analyze, and format spreadsheet files using Python libraries.

Official
Intermediate
npownpow
4

xlsx

Create, edit, analyze, convert, and validate spreadsheet files with pandas and openpyxl.

Community
Advanced