xlsx

Read, edit, and format Excel and tabular files into .xlsx outputs.

Updated Mar 19, 2026
One-click install
npx skills add https://github.com/gaos6e/MyOpenclaw --skill xlsx-gaos6e
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/gaos6e/MyOpenclaw/tree/main/skills/xlsx
Command: npx skills add https://github.com/gaos6e/MyOpenclaw --skill xlsx-gaos6e

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill helps you automate everyday spreadsheet tasks, turning manual Excel work into repeatable, error-free processes.

Core Features & Use Cases

  • Open, read, edit, format, and clean .xlsx, .xlsm, .csv, and .tsv files; create new spreadsheets from scratch or from other data sources.
  • Convert between tabular formats and apply formulas, organize data, and generate ready-to-share spreadsheets (reports, dashboards, or exports).
  • Use cases include cleaning messy data, restructuring columns, and preparing polished Excel workbooks for colleagues or clients.

Quick Start

Create a new spreadsheet from the provided dataset and save it as an .xlsx file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate cleaning and formatting Excel xlsx files in bulk?

You can automate Excel xlsx cleaning and formatting by using Python scripts with openpyxl to read, restructure columns, apply formulas, and export polished spreadsheet outputs automatically.

Can I convert csv or tsv files into a formatted xlsx spreadsheet?

Yes, you can convert csv and tsv files into formatted xlsx spreadsheets by reading the tabular input data and writing it into a new Excel workbook with applied formatting and formulas.

Does openpyxl support reading and writing xlsm macro-enabled spreadsheets?

Yes, openpyxl supports reading and writing xlsm macro-enabled spreadsheets, allowing you to automate data workflows while preserving existing macro structures within the Excel workbook file.

What is the best way to apply formulas and restructure columns in an Excel workbook?

The best way to apply formulas and restructure columns in an Excel workbook is using openpyxl scripts to programmatically edit cell values, insert formulas, and reorganize data structures.

Do I need Python to automate spreadsheet tasks like generating Excel reports?

Yes, you need Python with openpyxl, defusedxml, and lxml libraries to automate spreadsheet tasks, enabling script-based data cleaning, formatting, and report generation for xlsx outputs.

Why does my spreadsheet automation fail when reading large xlsx files?

Spreadsheet automation may fail reading large xlsx files due to memory constraints or invalid XML structures, but defusedxml and lxml provide validation and error handling to mitigate parsing issues.