xlsx

Open and manipulate xlsx, xlsm, csv, and tsv spreadsheet files.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/Prestonigo/Claude-Skills --skill xlsx-prestonigo
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Prestonigo/Claude-Skills/tree/main/skills-main/skills/xlsx
Command: npx skills add https://github.com/Prestonigo/Claude-Skills --skill xlsx-prestonigo

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps users automate repetitive spreadsheet tasks across Excel, CSV, and TSV formats, reducing manual data wrangling and error-prone edits.

Core Features & Use Cases

  • Open, read, edit, and fix existing spreadsheets (.xlsx, .xlsm), or convert between tabular formats like .csv and .tsv.
  • Create new workbooks from scratch or from data sources, apply formulas, format cells, and generate charts.
  • Clean and restructure messy tabular data (malformed rows, misplaced headers, junk data) to produce clean, reusable spreadsheets.

Quick Start

Provide your input file path and desired output format; the Skill will perform the requested transformations and save a new spreadsheet.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate cleaning messy spreadsheet data and fixing malformed rows?▼

To automate cleaning messy spreadsheet data, the Skill opens files like xlsx or csv to restructure misplaced headers and remove junk data. This process fixes malformed rows and exports a clean, reusable spreadsheet in your desired format.

Can I convert a CSV file to xlsx and apply formulas to the data?▼

Yes, you can convert CSV to xlsx and apply formulas. The process opens tabular data, computes the required formulas, formats the cells, and saves the final result as a functional xlsx spreadsheet.

What is the best way to automate adding columns and formatting in an existing xlsx workbook?▼

The best way to automate adding columns and formatting in an xlsx workbook is using a data processing script. It opens the existing spreadsheet, manipulates the data by adding columns, applies formatting, and exports the updated file.

Does this approach support generating charts in new spreadsheets created from raw data?▼

Yes, this approach supports generating charts in new spreadsheets. You can create a new workbook from raw data sources, apply formulas, format cells, and generate charts before exporting the final xlsx file.

Can I open and edit xlsm files or am I limited to standard xlsx spreadsheets?▼

You can open and edit xlsm files as well as standard xlsx spreadsheets. The process also supports csv and tsv formats, allowing you to read, edit, and convert between these tabular file types seamlessly.

Why does my spreadsheet conversion drop formulas when exporting from xlsx to csv?▼

When exporting from xlsx to csv, formulas are computed and saved as static values because csv is a plain text format without formula support. The conversion process calculates the formulas and exports the resulting data.