skills.rest
cdrguru
cdrguruCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

spreadsheet

Automate Excel, CSV, and TSV spreadsheet creation, editing, and analysis with Python.

1|Updated Dec 21, 2025
Search Tags:#pandas#openpyxl#spreadsheet#excel#data-analysis#xlsx#csv
One-click install
npx skills add https://github.com/cdrguru/portable-agent-kit --skill spreadsheet-cdrguru
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/cdrguru/portable-agent-kit/tree/main/.codex/skills/spreadsheet
Command: npx skills add https://github.com/cdrguru/portable-agent-kit --skill spreadsheet-cdrguru

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Automates end-to-end spreadsheet workflows by programmatically creating, editing, and analyzing Excel workbooks (.xlsx), CSV, and TSV data while preserving formulas, formatting, and references.

Core Features & Use Cases

  • Create and modify spreadsheets using Python libraries openpyxl and pandas, preserving structure and formatting.
  • Analyze data, compute metrics, and generate summaries or charts from tabular data.
  • Validate formulas and references to avoid breakages and ensure reliable outputs for reporting and data pipelines.

Quick Start

Provide a target spreadsheet task (create, analyze, or format) and I will generate or modify the workbook using Python.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema
How do I automate Excel workflows and edit xlsx files with Python?▼

You can automate Excel workflows by using Python libraries like openpyxl and pandas to programmatically create, edit, and analyze xlsx files while preserving formulas, formatting, and references.

Can I analyze CSV and TSV data and generate summary charts using Python?▼

Yes, you can analyze CSV and TSV data using Python with pandas to compute metrics, generate summaries, and create charts from tabular data for reporting or data pipelines.

Does openpyxl evaluate formulas when modifying Excel workbooks?▼

No, openpyxl does not evaluate formulas when modifying Excel workbooks; it preserves existing formulas and references without calculating their updated values during programmatic edits.

What is the best way to preserve formulas and references when editing spreadsheets programmatically?▼

The best way to preserve formulas and references during programmatic spreadsheet edits is to use Python with openpyxl, which maintains workbook structure and formatting without breaking existing cell logic.

How do I validate spreadsheet formulas to avoid broken references in data pipelines?▼

You can validate spreadsheet formulas and references programmatically using Python to ensure reliable outputs and avoid breakages across business reporting and automated data pipelines.

Where are modified spreadsheet files saved when using Python for data analysis?▼

Modified spreadsheet files are saved to the output/spreadsheet directory, while intermediate files generated during analysis are stored in the tmp/spreadsheets directory for temporary processing.

Related Skills

Explore More Data & Analytics Skills→
HellKaiser45HellKaiser45

xlsx

Read, edit, format, and convert Excel-compatible files using openpyxl and pandas.

Community
Intermediate
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
bloknayrbbloknayrb
2

Excel Analysis

Analyzes and transforms data in .xlsx files using Python libraries.

Community
Intermediate
Blake-JohnBlake-John

xlsx

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

Community
Intermediate