skills.rest
loongclaw-ai
loongclaw-aiOFFICIAL
Explore all skills by this author →
Website𝕏@loongclawaiGitHub

xlsx

Convert messy tabular files into validated Excel spreadsheets with recalculated formulas.

641|104|Updated Mar 5, 2026
Search Tags:#spreadsheet#excel#xlsx#libreoffice#data-cleaning#recalc#formula-validation
One-click install
npx skills add https://github.com/loongclaw-ai/loongclaw --skill xlsx-loongclaw-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/loongclaw-ai/loongclaw/tree/main/skills/anthropic-office/xlsx
Command: npx skills add https://github.com/loongclaw-ai/loongclaw --skill xlsx-loongclaw-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill keeps spreadsheet-driven work confined to Excel-compatible deliverables, so whenever a user wants to open, clean, restructure, or create .xlsx/.xlsm/.csv/.tsv files the outcome is a polished spreadsheet with professional fonts and zero formula errors while respecting existing templates.

Core Features & Use Cases

  • Context-aware triggers: Activate when the user references a spreadsheet file or messy tabular data, then let the assistant ingest the source with pandas, restructure columns, or add computed rows before writing back to Excel.
  • Governance-first formatting: Apply professional fonts, industry color-coding for hard inputs, formulas, links, and assumptions, and preserve the original template conventions while keeping all assumptions on separate cells.
  • Formula integrity pipeline: Build every calculation as an Excel formula via openpyxl, then run scripts/recalc.py with LibreOffice to detect and fix #REF!, #DIV/0!, #NAME?, and other errors before handing over the file.
  • Use Case: Turn a malformed CSV export into a clean workbook, compute scenario drivers with reference-based formulas, and export a fully recalculated XLSX that matches the required color and number formatting standards.

Quick Start

Ask the skill to load 'sales-downloads.xlsx', normalize the headers, add scenario formulas, and export a recalculated workbook.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean a messy CSV export and convert it into a formatted XLSX file?▼

To clean a messy CSV export, ingest the tabular source with pandas, normalize headers, restructure columns, and export a recalculated XLSX file with professional fonts and strict formatting standards.

Why do my openpyxl formulas show #REF! or #NAME? errors when I open the workbook?▼

Formulas show #REF! or #NAME? errors due to broken references or syntax issues. Run scripts/recalc.py with LibreOffice to detect and fix formula validation errors before delivering the final XLSX file.

Do I need LibreOffice to recalculate Excel formulas generated via openpyxl?▼

Yes, you need LibreOffice to recalculate Excel formulas. The workflow uses openpyxl to build calculations and scripts/recalc.py with LibreOffice to validate and fix errors like #DIV/0! before delivery.

What is the best way to add scenario formulas to a spreadsheet without breaking existing templates?▼

The best way to add scenario formulas is by using openpyxl to build calculations and preserving original template conventions while keeping assumptions on separate cells to prevent formatting or reference breaks.

Can I process TSV files and export them as professional XLSX workbooks?▼

Yes, you can process TSV files. The workflow ingests messy tabular sources including TSV, cleans and reshapes the data, and exports a fully recalculated XLSX workbook with industry color-coding and professional fonts.

Does this spreadsheet workflow support XLSM files with macros?▼

Yes, the workflow supports XLSM files. It ingests, cleans, and restructures XLSM sources while respecting existing template conventions to produce polished spreadsheet deliverables with zero formula errors.

Related Skills

Explore More Data & Analytics Skills→
OwnLabAIOwnLabAI
21

xlsx

Reads and writes spreadsheet data, transforms formats, and exports to XLSX/CSV/TSV.

Official
Intermediate
SebastianLHYSebastianLHY
5

xlsx

Automate spreadsheet creation, editing, and analysis for Excel-compatible workbooks.

Community
Advanced
shuff57shuff57

xlsx

Manage and analyze Excel files using openpyxl and pandas.

Community
Advanced
miriamdongmiriamdong
2

xlsx

Clean, transform, and format XLSX, CSV, and TSV files with Python.

Community
Intermediate