skills.rest
DEEP-PolyU
DEEP-PolyUOFFICIAL
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/DEEP-PolyU/matopt-xlab --skill xlsx-deep-polyu
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
ingbyringbyr
2

xlsx

Clean and transform spreadsheet data across xlsx, csv, and tsv formats.

Community
Intermediate
oimiragieooimiragieo
36

excel-generator

Generate multi-sheet Excel workbooks with formulas, charts, and formatting.

Community
Basic
SoufianouassifSoufianouassif

excel-generator

Generate Excel spreadsheets with formulas, charts, and tables using Python libraries.

Community
Advanced
Gull-StackGull-Stack

xlsx

Create, edit, and analyze Excel spreadsheets with formulas using Python.

Official
Advanced