skills.rest
DrugClaw
DrugClawOFFICIAL
Explore all skills by this author →
WebsiteGitHub

xlsx

Create, edit, and analyze spreadsheet files with pandas and openpyxl.

126|8|Updated Mar 10, 2026
Search Tags:#reporting#data analysis#formulas#spreadsheet#excel#data cleaning
One-click install
npx skills add https://github.com/DrugClaw/DrugClaw --skill xlsx-drugclaw
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/DrugClaw/DrugClaw/tree/main/skills/built-in/xlsx
Command: npx skills add https://github.com/DrugClaw/DrugClaw --skill xlsx-drugclaw

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, python-docx, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet files, automating tedious tasks and ensuring data accuracy.

Core Features & Use Cases

  • Data Manipulation: Read, write, and modify data in .xlsx, .xlsm, .csv, and .tsv files using pandas.
  • Formula Management: Create, apply, and verify Excel formulas, ensuring zero errors and adherence to best practices.
  • Formatting & Analysis: Apply professional formatting, perform data analysis, and generate reports from tabular data.
  • Use Case: Automatically clean messy tabular data from a CSV, format it into a professional Excel report with correct formulas, and ensure all calculations are error-free.

Quick Start

Use the xlsx skill to read the data from 'sales_report.xlsx' and calculate the total revenue for each region.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel formula application and verification in xlsx files?▼

To automate Excel formula application and verification in xlsx files, this Skill uses openpyxl alongside a dedicated recalculation script to create, apply, and verify formulas, ensuring zero errors and adherence to best practices.

What is the best way to clean messy tabular data from a CSV and format it into a professional report?▼

The best way to clean messy tabular data from a CSV and format it into a professional report is using this Skill's pandas integration to manipulate data, apply professional formatting, and generate error-free reports.

Does this spreadsheet automation tool support reading and writing both csv and xlsm file formats?▼

Yes, this spreadsheet automation tool supports reading, writing, and modifying both csv and xlsm file formats, as well as tsv and xlsx files, using pandas for comprehensive data manipulation.

Can I use pandas for complex financial modeling and data analysis on tsv files?▼

You can use pandas for complex financial modeling and data analysis on tsv files, as this Skill handles tasks ranging from basic data entry to advanced modeling and data cleaning across supported formats.

How do I calculate total revenue by region from an existing sales report spreadsheet?▼

To calculate total revenue by region from a sales report spreadsheet, the Skill reads the data using pandas, applies the necessary formulas with openpyxl, and verifies all calculations to ensure accuracy.

Related Skills

Explore More Data & Analytics Skills→
OwnLabAIOwnLabAI
21

xlsx

Reads and writes spreadsheet data, transforms formats, and exports to XLSX/CSV/TSV.

Official
Intermediate
Xza85hrfXza85hrf

doc-generation

Generate branded DOCX, PPTX, PDF, and XLSX documents from structured data.

Community
Intermediate
EnztunEnztun

xlsx

Automate Excel spreadsheet operations with Python libraries like openpyxl, pandas, and matplotlib.

Community
Advanced
ChenYCLChenYCL

xlsx

Create, read, edit, and analyze Excel spreadsheet files with openpyxl and pandas.

Community
Intermediate