skills.rest
Postalocity
PostalocityOFFICIAL
Explore all skills by this author →
GitHub

xlsx

Clean, transform, and generate .xlsx workbooks from .xlsx, .xlsm, .csv, and .tsv inputs.

1|Updated Mar 5, 2026
Search Tags:#excel#xlsx#data-transformation#data-cleaning#format-conversion#csv-to-xlsx#sheet-editing
One-click install
npx skills add https://github.com/Postalocity/template-microsite --skill xlsx-postalocity
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Postalocity/template-microsite/tree/main/.opencode/skills/anthropic-skills--xlsx
Command: npx skills add https://github.com/Postalocity/template-microsite --skill xlsx-postalocity

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Automates cleaning, transformation, and generation of spreadsheet files to replace manual, error-prone editing and formatting tasks.

Core Features & Use Cases

  • Open, read, edit, and repair spreadsheet files in .xlsx/.xlsm and convert from .csv/.tsv formats.
  • Clean messy tabular data, normalize columns, apply formatting, and update formulas to produce a consistent workbook.
  • Create new spreadsheets from existing data sources or transform and export to a polished .xlsx for reporting.
  • Use case: a data analyst cleans a messy CSV of sales data then exports a ready-to-share Excel workbook.

Quick Start

Provide a sample spreadsheet file and request a transformation, and the tool will return a cleaned, finalized .xlsx.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert a CSV file to a formatted Excel workbook?▼

Yes, you can clean messy spreadsheet data by normalizing columns, applying formatting, and updating formulas to produce a consistent .xlsx workbook from disorganized inputs.

Can I edit and repair existing .xlsx or .xlsm spreadsheet files?▼

You can open, read, edit, and repair spreadsheet files in .xlsx and .xlsm formats, updating formulas and applying consistent formatting to generate a finalized Excel workbook.

What is the best way to automate Excel data transformation for reporting?▼

Automating spreadsheet transformation involves processing raw .csv, .tsv, or .xlsm files to clean columns and export a structured .xlsx deliverable for analysis.

Does this Excel cleaning tool support macro-enabled workbooks?▼

Yes, the tool supports opening, reading, and editing macro-enabled .xlsm spreadsheet files alongside standard .xlsx formats, allowing you to transform and export them effectively.

What formats can I use to generate a new Excel spreadsheet?▼

You can generate a new Excel spreadsheet by providing existing data sources in .csv, .tsv, .xlsm, or .xlsx formats, which are then cleaned and exported as a polished .xlsx file.

Related Skills

Explore More Data & Analytics Skills→
pablomat555pablomat555
1

xlsx

Clean, transform, and format spreadsheet data into finalized .xlsx files.

Community
Intermediate
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
AgentTeam-TaichuAIAgentTeam-TaichuAI
630

xlsx

Process and validate XLSX workbooks offline using openpyxl.

Community
Advanced
expanso-ioexpanso-io

expanso-csv-to-json

Convert CSV files to JSON with schema inference and type coercion.

Official
Basic