anthropics-xlsx

Clean spreadsheet headers and convert CSV, TSV, XLSX, or XLSM files into standardized XLSX outputs.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides a streamlined approach to open, read, edit, clean, and convert spreadsheet files. It covers common formats such as .xlsx, .xlsm, .csv, and .tsv, and helps standardize headers, formatting, and simple transformations to produce production-ready outputs.

Core Features & Use Cases

  • Open, read, and modify spreadsheet workbooks across multiple formats (xlsx/xlsm/csv/tsv).
  • Clean messy data, normalize headers, apply formatting, and convert between tabular formats.
  • Use cases include preparing data for analysis, reporting, or sharing in education, research, or business settings.

Quick Start

Process the attached CSV and output a cleaned XLSX with standardized headers.

Frequently Asked Questions about anthropics-xlsx

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

FAQPage Schema
How do I convert CSV to XLSX and clean messy spreadsheet headers?

To convert CSV to XLSX and clean messy spreadsheet headers, use a deterministic script-driven workflow powered by openpyxl that standardizes headers, normalizes formats, and outputs production-ready workbooks suitable for analysis or reporting.

What is the best way to standardize spreadsheet data from different formats into one output?

Standardizing spreadsheet data from different formats involves opening xlsx, xlsm, csv, and tsv files, then normalizing headers and applying consistent formatting to produce a clean, standardized XLSX output for downstream analysis.

Does openpyxl support reading and modifying xlsm files with macros?

Openpyxl supports opening, reading, and modifying spreadsheet workbooks across multiple formats including xlsx, xlsm, csv, and tsv, allowing you to clean data and reformat headers within these file types.

How do I clean tabular data for reporting without introducing formatting errors?

Cleaning tabular data for reporting without formatting errors is achieved through a deterministic script-driven workflow that normalizes formats and headers, generating error-free, well-formatted spreadsheets ready for business or research use.

Can I batch convert tsv files into production-ready Excel workbooks?

You can convert tsv files into production-ready Excel workbooks by processing the tabular inputs through a Python-based workflow that cleans the data, standardizes headers, and exports a formatted XLSX file.

What are the limitations of using openpyxl for spreadsheet data cleaning and conversion?

The workflow uses openpyxl to perform deterministic, script-driven transformations for cleaning headers and normalizing formats, but complex formula recalculations or advanced macro execution are not part of its stated data-cleaning and conversion scope.