spreadsheet

Create, edit, and analyze xlsx and csv spreadsheets using openpyxl and pandas.

Updated Feb 4, 2026
One-click install
npx skills add https://github.com/pchemguy/AISandbox --skill spreadsheet-pchemguy
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/pchemguy/AISandbox/tree/main/docs/AgentSkills/openai/skills/skills/.curated/spreadsheet
Command: npx skills add https://github.com/pchemguy/AISandbox --skill spreadsheet-pchemguy

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve? Working with spreadsheets programmatically often breaks formulas, loses formatting, or produces unstyled output. This Skill provides a structured workflow for creating, editing, analyzing, and visualizing spreadsheets while preserving formulas, references, and formatting. ## Core Features & Use Cases - Workbook Creation & Editing: Build new .xlsx workbooks with formulas, formatting, and structured layouts using openpyxl, or modify existing files without breaking references. - Data Analysis: Filter, aggregate, pivot, and compute metrics on tabular data with pandas, then write results back to .xlsx or .csv. - Visual Verification: Render sheets to PDF/PNG via LibreOffice and Poppler to review layout accuracy before delivery. - Use Case: Build an investment banking style DCF model with proper color conventions, formula-driven derived values, source citations in cell comments, and finance formatting such as red parenthesized negatives. ## Quick Start Use the spreadsheet skill to create a formatted xlsx workbook with formulas and clean styling for this data.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema
How do I create an xlsx spreadsheet with formulas in Python?▼

Use openpyxl to build workbooks and write formulas as strings, such as =SUM(D2:D4), directly into cells. openpyxl does not evaluate formulas, so results calculate when the file opens in Excel or Google Sheets.

openpyxl vs pandas for spreadsheet tasks, which should I use?▼

Use openpyxl when creating or editing .xlsx files where formatting and formulas must be preserved. Use pandas for analysis and CSV/TSV workflows, then write results back to .xlsx or .csv.

Does openpyxl evaluate Excel formulas?▼

No, openpyxl does not evaluate formulas; it stores them as strings and leaves calculation to Excel or Google Sheets. Validate formulas and references manually and guard against errors like #REF! and #DIV/0!.

How can I visually check spreadsheet layout without Excel?▼

Render the workbook with LibreOffice using soffice --headless --convert-to pdf, then convert pages to images with pdftoppm. If these tools are unavailable, ask the user to review the output locally.

How do I edit an existing xlsx without breaking formatting?▼

Render and inspect the spreadsheet before modifying it, preserve existing styles exactly, and match styles for newly filled cells. Load with openpyxl and avoid overwriting formula cells with hardcoded values.