skills.rest
mattmacleod16-svg
mattmacleod16-svgCOMMUNITY
Explore all skills by this author →
GitHub

spreadsheet

Automate spreadsheet creation, editing, analysis, and formatting with openpyxl and pandas.

1|Updated Feb 25, 2026
Search Tags:#pandas#openpyxl#formulas#spreadsheet#data-analysis#xlsx#csv
One-click install
npx skills add https://github.com/mattmacleod16-svg/freedomforge-max --skill spreadsheet-mattmacleod16-svg
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/mattmacleod16-svg/freedomforge-max/tree/main/.agents/skills/spreadsheet
Command: npx skills add https://github.com/mattmacleod16-svg/freedomforge-max --skill spreadsheet-mattmacleod16-svg

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Spreadsheets are central to data handling but manual editing, inconsistent formulas, and formatting drift slow analysis and risk errors. This Skill automates creating, editing, analyzing, and formatting spreadsheets while preserving formulas, references, and styling across file formats like .xlsx, .csv, and .tsv.

Core Features & Use Cases

  • Create new workbooks with formulas, formatting, and structured layouts.
  • Read or analyze data (filter, aggregate, pivot, compute metrics).
  • Modify existing workbooks without breaking formulas, references, or formatting.
  • Visualize data with charts and sensible spreadsheet styling.
  • Recalculate formulas and verify outputs before delivery.

Quick Start

Ask the AI to create or edit an Excel workbook (xlsx) with formulas and formatting, and verify the results.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema
How do I automate spreadsheet editing without breaking existing formulas and formatting?▼

Automate spreadsheet editing by using Python libraries like openpyxl and pandas to read and write .xlsx files, ensuring formulas, references, and styling are preserved during modifications.

Can I use pandas to analyze and aggregate data from a CSV or TSV file?▼

Use pandas to analyze data from CSV and TSV files by filtering, aggregating, pivoting, and computing metrics to streamline data-cleaning and reporting workflows.

Do I need openpyxl and pandas installed to create and format Excel workbooks?▼

Yes, you need a capable runtime environment with openpyxl and pandas installed to create new workbooks with structured layouts, formulas, formatting, and charts.

What is the best way to modify existing xlsx files while recalculating and verifying formulas?▼

The best way to modify xlsx files is using openpyxl to edit content and recalculate formulas, allowing you to verify outputs before final delivery without losing styling.

Does this approach to spreadsheet automation support creating charts and visualizing data?▼

Yes, spreadsheet automation supports visualizing data with charts and applying sensible spreadsheet styling to ensure reports are readable and correctly formatted.

Related Skills

Explore More Data & Analytics Skills→
vibeingingvibeinging
49

xlsx

Read, analyze, and generate results from Excel and CSV files.

Community
Intermediate
pablomat555pablomat555
1

xlsx

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

Community
Intermediate
georgekhananaevgeorgekhananaev
27

xlsx

Create, edit, and analyze Excel workbooks in XLSX, XLSM, and CSV formats.

Community
Advanced
rshankrasrshankras
603

Deep Linking Generator

Generate deep linking infrastructure for iOS and macOS apps.

Community
Advanced