xlsx

Automate spreadsheet manipulation across .xlsx, .xlsm, .csv, and .tsv formats.

1|Updated Mar 26, 2026
One-click install
npx skills add https://github.com/daxiangnaoyang/lobster-bot --skill xlsx-daxiangnaoyang
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/daxiangnaoyang/lobster-bot/tree/main/skills/skills/xlsx
Command: npx skills add https://github.com/daxiangnaoyang/lobster-bot --skill xlsx-daxiangnaoyang

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

The Skill automates complex spreadsheet workflows, enabling users to open, read, edit, clean, format, compute formulas, chart, and convert between spreadsheet formats (.xlsx, .xlsm, .csv, .tsv), turning messy data into polished workbook outputs.

Core Features & Use Cases

  • Open, read, edit, and fix existing spreadsheets across common formats (.xlsx, .xlsm, .csv, .tsv)
  • Create new spreadsheets from scratch or from other data sources, applying formatting, formulas, and basic analytics
  • Convert between tabular file formats while preserving data integrity and structure
  • Use case: convert a messy CSV export into a clean, formatted Excel workbook with calculated fields and charts

Quick Start

Process the file at path/to/your.xlsx to clean, restructure, and transform its data into a polished spreadsheet.

Frequently Asked Questions about xlsx

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

FAQPage Schema
Can I edit and fix existing spreadsheets while preserving formulas and formatting?

Yes, spreadsheet automation can open and edit existing .xlsx, .xlsm, .csv, and .tsv files directly. It preserves existing formulas and formatting while applying data cleaning, restructuring, and new calculations to your workbook outputs.

Does openpyxl support creating charts and calculating formulas in new spreadsheets?

The best way to automate spreadsheet data cleaning and format conversion is using Python tooling to read workbooks, validate outputs, restructure data, and write clean .xlsx or .tsv files while maintaining data integrity and structure.

What is the best way to automate spreadsheet data cleaning and format conversion?

Yes, openpyxl supports creating new spreadsheets from scratch or other data sources by applying formatting, calculating formulas, and generating charts. It validates outputs to ensure data integrity in the final workbook.

Can I edit and fix existing spreadsheets while preserving formulas and formatting?

To convert a messy CSV export into a formatted Excel workbook, openpyxl-based automation reads the CSV, cleans the data, applies formatting, computes formulas, and outputs a polished .xlsx file with calculated fields and charts.