skills.rest
cuozg
cuozgCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

spreadsheet

Automate spreadsheet creation, editing, analysis, and formatting in .xlsx, .csv, and .tsv.

4|1|Updated Jan 27, 2026
Search Tags:#formatting#data analysis#formulas#spreadsheet#excel#xlsx#csv
One-click install
npx skills add https://github.com/cuozg/oh-my-skills --skill spreadsheet-cuozg
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/cuozg/oh-my-skills/tree/main/skills/spreadsheet
Command: npx skills add https://github.com/cuozg/oh-my-skills --skill spreadsheet-cuozg

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, editing, analysis, and formatting of spreadsheet data, eliminating manual data manipulation and complex formula creation.

Core Features & Use Cases

  • Data Manipulation: Create, edit, and analyze data in .xlsx, .csv, and .tsv formats.
  • Formula & Charting: Add complex formulas, generate charts, and perform pivot analysis.
  • Data Cleaning & Formatting: Clean messy data and apply professional formatting for better readability.
  • Use Case: You have a CSV file with sales data and need to create a summary report with a bar chart showing monthly revenue. This skill can read the CSV, calculate monthly totals, create a chart, and save it as a styled XLSX file.

Quick Start

Use the spreadsheet skill to create a new Excel file named 'sales_report.xlsx' with columns for 'Month', 'Revenue', and 'Profit'.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema
How do I automate Excel data analysis and create charts from a CSV file?▼

You can automate Excel data analysis from a CSV file by reading the dataset, calculating derived columns, generating charts, and exporting a styled XLSX report using pandas and openpyxl.

Can I add formulas and format spreadsheets in xlsx files programmatically?▼

Yes, you can add formulas and format spreadsheets in xlsx files programmatically by leveraging openpyxl to inject calculations, apply professional styling, and manipulate cell data without manual editing.

Does this approach support data cleaning and pivot analysis for TSV files?▼

This approach supports data cleaning and pivot analysis for TSV files by utilizing pandas to ingest the tabular data, clean messy entries, and compute pivot summaries before exporting the results.

What is the best way to generate a summary report from messy spreadsheet data?▼

The best way to generate a summary report from messy spreadsheet data is to clean the dataset, calculate monthly totals, create a visual chart, and save the formatted output as a new spreadsheet file.

Do I need pandas and openpyxl to manipulate CSV and xlsx files for data formatting?▼

Yes, you need pandas and openpyxl to manipulate CSV and xlsx files for data formatting, as pandas handles CSV/TSV analysis workflows and openpyxl manages xlsx manipulation and formula injection.

Related Skills

Explore More Data & Analytics Skills→
shalevaminshalevamin

spreadsheet

Create, edit, analyze, and format .xlsx, .csv, and .tsv spreadsheet files.

Community
Intermediate
4tie4tie

excel-generator

Generate Excel workbooks and Google Sheets with formulas, charts, and PDF exports.

Community
Advanced
lamm-mitlamm-mit
38

seaborn

Create statistical visualizations from pandas DataFrames using seaborn.

Community
Advanced
didclawapp-aididclawapp-ai
11

office-production-daily-report

Generate daily production and quality DOCX reports from xlsx and csv data files.

Community
Intermediate