xlsx

Process, edit, and generate XLSX spreadsheets with formula-safe integrity checks.

2|Updated Mar 31, 2026
One-click install
npx skills add https://github.com/marktantongco/promptc-os --skill xlsx-marktantongco
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/marktantongco/promptc-os/tree/main/skills/xlsx
Command: npx skills add https://github.com/marktantongco/promptc-os --skill xlsx-marktantongco

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, XlsxWriter.

What problem does it solve?

Provide a single, scene-driven workbench for any task where a spreadsheet file is the primary input or output: opening, reading, cleaning, transforming, analyzing, charting, converting, or generating .xlsx/.xlsm/.csv/.tsv outputs while preserving formulas, styling, and data provenance.

Core Features & Use Cases

  • File conversion & ingestion: Convert CSV/TSV/JSON/PDF tables to polished XLSX workbooks and merge multiple tabular sources into one workbook.
  • Edit, clean & transform: Data cleaning, merging, pivot creation, structural edits, and formula-safe rewrites while preserving original styles and VBA when required.
  • Analysis, charts & QA: Run pandas/openpyxl analysis, insert native Excel charts or embedded matplotlib images, and enforce integrity via recalculation, audit, and scan workflows (recalc → audit → scan → validate).
  • Use case: Combine five monthly CSV exports into a single multi-sheet Excel report, add a summary dashboard with KPI cards and charts, and run the QA pipeline to ensure zero formula errors.

Quick Start

Convert the file data.csv into a cleaned Excel workbook with a Summary sheet, pivot tables, and charts, then run the built-in validation and recalc.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert CSV and JSON files into a formatted Excel workbook?

To convert CSV and JSON files into a formatted Excel workbook, you can ingest multiple tabular sources and merge them into a single polished .xlsx file with sheets, pivots, and charts while preserving data integrity.

Can I edit existing xlsx files without breaking formulas and styling?

Yes, you can perform formula-safe edits and structural rewrites on .xlsx and .xlsm files while preserving the original cell styles, VBA, and data provenance during cleaning and transformation.

What is the best way to build pivot tables and charts from spreadsheet data?

The best way to build pivot tables and charts from spreadsheet data is using openpyxl and pandas to run analysis, insert native Excel charts or embedded matplotlib images, and generate summary dashboards.

How do you audit Excel workbooks for formula errors and data issues?

You audit Excel workbooks by running a self-check integrity pipeline that executes recalculation, audit, scan, and validation steps to identify and resolve formula errors and structural data issues.

Does this spreadsheet processing approach support csv and tsv files?

Yes, this spreadsheet processing approach fully supports .csv and .tsv files alongside .xlsx and .xlsm formats, allowing you to read, clean, transform, and convert these sources into polished Excel reports.

Why do I need openpyxl and XlsxWriter for Excel file generation?

You need openpyxl and XlsxWriter for Excel file generation because they provide the programmatic formatting, chart insertion, and structural writing capabilities required to create complex workbooks with preserved formulas and styling.