skills.rest
spandios
spandiosCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

spreadsheet

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

Updated Feb 6, 2026
Search Tags:#reporting#data analysis#pandas#openpyxl#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/spandios/vibe-utils --skill spreadsheet-spandios
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/spandios/vibe-utils/tree/main/skills/spreadsheet
Command: npx skills add https://github.com/spandios/vibe-utils --skill spreadsheet-spandios

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines spreadsheet creation, modification, and analysis, ensuring data integrity and professional presentation.

Core Features & Use Cases

  • Workbook Creation: Generate new .xlsx or .csv files with formulas, formatting, and charts.
  • Data Analysis: Perform calculations, aggregations, and filtering on tabular data.
  • Editing & Formatting: Modify existing spreadsheets while preserving formulas and styles.
  • Use Case: Automatically generate a monthly sales report by analyzing raw data, applying financial formulas, and creating summary charts in an .xlsx file.

Quick Start

Use the spreadsheet skill to create a new workbook named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue'.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema
How do I create an Excel file with formulas and charts from raw data?▼

To create an Excel file with formulas and charts, use this Skill to generate new .xlsx workbooks with openpyxl, apply financial formulas, and create summary charts for professional presentation and data integrity.

Can I edit existing .xlsx spreadsheets without losing formulas and formatting?▼

Yes, you can edit existing .xlsx spreadsheets while preserving formulas and styles. The Skill modifies workbook files by utilizing openpyxl to ensure your original formatting and cached recalculations remain intact.

What is the best way to analyze CSV and TSV tabular data for reporting?▼

The best way to analyze CSV and TSV tabular data for reporting is using pandas to perform calculations, aggregations, and filtering, enabling efficient data analysis and automated report generation from delimited formats.

Does this approach support formula-aware workflows and visual review of rendered sheets?▼

Yes, this approach supports formula-aware workflows and cached recalculation. It enables visual review of rendered sheets, ensuring data integrity when generating or modifying spreadsheet files.

How do I automate a monthly sales report using spreadsheet data analysis?▼

You automate a monthly sales report by analyzing raw data with pandas, applying financial formulas via openpyxl, and creating summary charts in an .xlsx file to streamline spreadsheet creation and modification.

Related Skills

Explore More Data & Analytics Skills→
shalevaminshalevamin

spreadsheet

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

Community
Intermediate
bmadiganbmadigan
1

xlsx

Create, edit, and analyze Excel workbooks with openpyxl and pandas.

Community
Intermediate
bowoxdailybowoxdaily

xlsx

Analyze Excel files and generate reports using Python and openpyxl.

Community
Advanced
ArroganceGArroganceG

xlsx

Clean, format, and convert spreadsheet data across .xlsx, .xlsm, .csv, and .tsv files.

Community
Intermediate