skills.rest
remiconnesson
remiconnessonCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

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

Updated Apr 9, 2026
Search Tags:#formulas#spreadsheet#excel#csv#data cleaning#workbook#tsv
One-click install
npx skills add https://github.com/remiconnesson/insights-garden --skill xlsx-remiconnesson
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/remiconnesson/insights-garden/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/remiconnesson/insights-garden --skill xlsx-remiconnesson

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill removes the friction of working with spreadsheet files by letting you open, edit, clean, convert, and repair tabular data without manually wrestling with workbook structure or broken formulas.

Core Features & Use Cases

  • Spreadsheet creation and editing: Build new workbooks or update existing sheets, cells, formulas, and formatting.
  • Tabular data cleanup and conversion: Transform messy CSV or TSV data into well-formed spreadsheets and move between common spreadsheet formats.
  • Validation and recalculation: Recompute formulas, check for Excel errors, and verify workbook integrity so files stay usable after changes.
  • Use Case: A finance or analytics user can load a monthly report, add projection formulas, standardize formatting, and export a corrected workbook with confidence.

Quick Start

Use the xlsx skill to open the attached spreadsheet, apply the requested edits, and return the updated workbook.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean and convert messy CSV or TSV data into a well-formed Excel spreadsheet?▼

Yes, this Skill recalculates and recomputes formulas after editing cells, checking for Excel errors and verifying workbook integrity to preserve formula accuracy and prevent broken document relationships.

What's the best way to add projection formulas to an existing Excel workbook without breaking relationships?▼

The best way to add formulas safely is using this Skill, which applies spreadsheet-aware validation and recalculation after edits, ensuring workbook relationships and formulas remain intact and error-free.

Can I use openpyxl to edit xlsm files while preserving formulas and formatting?▼

This Skill handles xlsx, xlsm, csv, and tsv formats, supporting workflows like creating financial models, fixing malformed tables, formatting sheets, and converting between common tabular data formats.

Why do my spreadsheet formulas break after converting from CSV to xlsx?▼

Formulas often break during conversion due to lost workbook structure or missing spreadsheet-aware validation; this Skill prevents that by validating and recalculating formulas to avoid errors and broken relationships.

Related Skills

Explore More Data & Analytics Skills→
eddie-292eddie-292
52

xlsx

Create, edit, clean, convert, and validate xlsx, xlsm, csv, and tsv workbooks.

Community
Advanced
UNO998UNO998

xlsx

Create, edit, and transform Excel workbooks with formulas and formatting.

Community
Advanced
Dev-Dennis-040Dev-Dennis-040
10

data-analytics-reporter

Analyze raw data and generate business insights with dashboards and reports.

Community
Advanced
SeifBenayedSeifBenayed
114

xlsx

Create, edit, format, and clean .xlsx, .xlsm, .csv, and .tsv spreadsheet files.

Community
Intermediate