skills.rest
yahav123147
yahav123147COMMUNITY
Explore all skills by this author →
GitHub

xlsx

Clean and repair Excel/CSV spreadsheets with formula recalculation via LibreOffice.

1|Updated Apr 13, 2026
Search Tags:#financial modeling#xlsx#data cleaning#tabular data#LibreOffice recalculation#excel formulas#CSV conversion
One-click install
npx skills add https://github.com/yahav123147/paid-ads-cro-skills --skill xlsx-yahav123147
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/yahav123147/paid-ads-cro-skills/tree/main/skills/xlsx
Command: npx skills add https://github.com/yahav123147/paid-ads-cro-skills --skill xlsx-yahav123147

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

It eliminates the time-consuming work of cleaning, restructuring, fixing, and rebuilding spreadsheet files while ensuring formulas work correctly without Excel errors.

Core Features & Use Cases

  • Create and edit spreadsheets: Build new Excel files from scratch, add columns/rows, restructure tables, and update formatting with reliable formula-based calculations.
  • Analyze messy tabular data: Clean malformed rows, fix misplaced headers, normalize inconsistent columns, and produce a valid spreadsheet deliverable.
  • Repair formula integrity: Enforce zero Excel formula errors by recalculating formulas via LibreOffice and iterating on detected issues like #REF!, #DIV/0!, #VALUE!, and #NAME?.
  • Financial-model-friendly structure: Supports disciplined assumptions placement and standardized formatting conventions for projection models.

Quick Start

Use the xlsx skill to clean and fix the spreadsheet you attached at the path 'report.xlsx' so it contains 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 fix broken Excel formulas like #REF! and #DIV/0! in my spreadsheet?▼

To fix broken Excel formulas, the spreadsheet is recalculated via LibreOffice to detect errors like #REF!, #DIV/0!, and #VALUE!, then iterates on the issues until the output guarantees zero Excel formula errors.

What is the best way to clean messy tabular data and normalize inconsistent columns in an xlsx file?▼

Cleaning messy tabular data involves fixing malformed rows, correcting misplaced headers, and normalizing inconsistent columns to produce a valid, correctly structured spreadsheet deliverable.

Can I use this to convert CSV or TSV files into a formatted Excel workbook?▼

Yes, you can convert between tabular formats. It processes .csv and .tsv inputs and can generate a newly corrected .xlsx or .xlsm spreadsheet with reliable formula-based calculations.

Does this approach support building financial modeling spreadsheets from scratch?▼

Yes, building financial models is supported. It enforces disciplined assumptions placement and standardized formatting conventions for reliable projection models using formula-driven calculations.

Why do my spreadsheet recalculations show #NAME? errors and how can I resolve them?▼

Recalculation errors like #NAME? occur from invalid formula syntax or missing references. It enforces mandatory LibreOffice-based recalculation to validate and iterate on detected issues until resolved.

Do I need a specific environment to ensure zero Excel errors when rebuilding workbooks?▼

Yes, achieving zero Excel errors requires mandatory LibreOffice-based recalculation for validation, ensuring the corrected spreadsheet output contains no formula calculation errors.

Related Skills

Explore More Data & Analytics Skills→
remiconnessonremiconnesson

xlsx

Edit, clean, and convert spreadsheet files while preserving formulas and workbook structure.

Community
Advanced
run6270run6270
1

Excel Analysis

Analyze and manipulate Excel spreadsheet data with pandas and openpyxl.

Community
Intermediate
WizarckWizarck

xlsx

Clean, reorganize, and convert tabular data across .xlsx, .xlsm, .csv, and .tsv formats.

Community
Intermediate
Victory-HugoVictory-Hugo
1

xlsx

Create, edit, and analyze Excel workbooks with formulas using Python openpyxl and LibreOffice recalculation.

Community
Advanced