xlsx

Read, edit, and convert xlsx, xlsm, csv, and tsv spreadsheet files.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/PoyoPoak/FastAPI-App-Template --skill xlsx-poyopoak
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/PoyoPoak/FastAPI-App-Template/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/PoyoPoak/FastAPI-App-Template --skill xlsx-poyopoak

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill eliminates the manual, repetitive work of reading, editing, formatting, and converting spreadsheets, saving time and reducing errors across large tabular datasets.

Core Features & Use Cases

  • Read, modify, and generate standard spreadsheet formats (xlsx, xlsm, csv, tsb) including conversions between them.
  • Clean and normalize messy tabular data, align column structures, and apply consistent formatting across multiple files.
  • Automate common spreadsheet tasks in analytics, reporting, data migration, and data preparation workflows.

Quick Start

Process a sample workbook to clean data, standardize formats, and export a cleaned file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate data cleaning and column manipulation in xlsx files?

Automate spreadsheet data cleaning and column manipulation by running deterministic scripts that read, modify, and standardize messy tabular data across xlsx, xlsm, csv, and tsv files, replacing manual Excel work with traceable change logs.

Can I convert csv to xlsx while preserving formulas and formatting?

Yes, you can convert csv to xlsx while preserving formulas and formatting. The scripts use explicit formulas during sheet reading and writing to maintain data integrity, ensuring standard tabular formats remain intact and traceable during format conversion.

What is the best way to prepare tabular data for analytics and reporting?

The best way to prepare tabular data for analytics and reporting is to normalize structures and apply consistent formatting across multiple files. Automating this spreadsheet workflow eliminates manual errors and saves time across large datasets.

Does openpyxl support automated data migration across different spreadsheet formats?

Yes, openpyxl supports automated data migration across different spreadsheet formats. It enables the reading, editing, and writing of xlsx and xlsm files, allowing seamless transformation and format conversion for data migration scenarios.

What are the limitations of using scripts for spreadsheet format conversion?

Limitations of using scripts for spreadsheet format conversion include relying on deterministic processing, which means complex dynamic Excel features may not evaluate as expected. The scripts use explicit formulas to ensure data integrity rather than dynamic recalculation.