xlsx

Automate spreadsheet editing and conversion across XLSX, CSV, and TSV files.

1|Updated Apr 9, 2026

Search Tags:#formulas #excel #xlsx #conversion #data-processing #data-cleaning

Ready to run

npx skills add https://github.com/DEEP-PolyU/matopt-xlab --skill xlsx-deep-polyu

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/DEEP-PolyU/matopt-xlab/tree/main/backend/skills/xlsx
Command: npx skills add https://github.com/DEEP-PolyU/matopt-xlab --skill xlsx-deep-polyu

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Use this Skill to automate the manipulation, cleaning, formatting, and conversion of spreadsheet files across XLSX, XLSM, CSV, and TSV, eliminating tedious manual tasks.

Core Features & Use Cases

Open, read, edit, and fix existing spreadsheets (.xlsx, .xlsm, .csv, .tsv), including applying formulas and formatting.
Create new spreadsheets from data sources or convert between formats, with support for charts and data cleaning.
Typical use cases include cleaning messy data, enforcing templates, and producing ready-to-share outputs.

Quick Start

Process a workbook to standardize formatting and update formulas.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I automate cleaning messy data in an xlsx spreadsheet?▼

You can clean messy data by automating spreadsheet workflows that read xlsx files, standardize formatting, apply formulas, and produce ready-to-share outputs without manual editing.

Can I convert csv files to xlsx while preserving formulas and charts?▼

Yes, you can convert csv files to xlsx while preserving formulas and charts. It uses openpyxl for Excel I/O and LibreOffice-based recalculation workflows to maintain formula integrity across formats.

Does openpyxl support recalculating formulas when converting xlsx files?▼

openpyxl handles Excel I/O for reading and writing xlsx files, while LibreOffice-based recalculation workflows ensure formula integrity during conversion, delivering production-ready outputs with correctly calculated values.

What is the best way to enforce a standard template across multiple xlsx workbooks?▼

The best way to enforce a standard template across multiple xlsx workbooks is to automate the workflow, applying consistent formatting and formulas to existing files and producing standardized outputs.

Why do my formulas break when converting between csv and xlsx formats?▼

Formulas can break during csv and xlsx conversion if standard tools strip formula logic. This automation uses LibreOffice-based recalculation workflows to maintain formula integrity and deliver production-ready outputs.

Can I create new spreadsheets from external data sources?▼

Yes, you can create new spreadsheets from external data sources. The automation supports creating new workbooks, applying formatting and formulas, and converting between xlsx, csv, and tsv formats.