spreadsheet

Create, edit, and analyze xlsx, csv, and tsv spreadsheets with formula-aware workflows.

Updated Jul 7, 2026
One-click install
npx skills add https://github.com/jamsdoescode/Erik-s-Portfolio --skill spreadsheet-jamsdoescode
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/jamsdoescode/Erik-s-Portfolio/tree/main/openclicky/AppResources/OpenClicky/OpenClickyBundledSkills/spreadsheet
Command: npx skills add https://github.com/jamsdoescode/Erik-s-Portfolio --skill spreadsheet-jamsdoescode

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 that requires manual cleanup. This Skill provides a structured workflow for creating, editing, and analyzing spreadsheets while preserving formulas, styles, and layout integrity. ## Core Features & Use Cases - Formula-Aware Editing: Modify existing workbooks with openpyxl without breaking formulas, references, or established formatting, and recalculate cached values before delivery. - Analysis and Visualization: Use pandas for filtering, aggregation, and pivoting of CSV/TSV data, plus openpyxl charts and LibreOffice rendering for visual review. - Finance-Grade Formatting: Apply investment banking conventions such as blue inputs, black formulas, red parenthesized negatives, and cited sources in cell comments. - Use Case: Build a DCF valuation model from raw assumptions, with proper number formats, section headers, formula-driven totals, and rendered sheets reviewed for layout issues before delivery. ## Quick Start Use the spreadsheet skill to create a styled xlsx workbook from my sales data with formulas for totals and a summary sheet.

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 file with formulas in Python?

Use openpyxl to create a workbook, write values to cells, and assign formula strings like =SUM(D2:D4) to derived cells. Save with wb.save(path), then recalculate with a rendering tool since openpyxl does not evaluate formulas itself.

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

Use openpyxl for creating and editing xlsx files when formatting, styles, and formula preservation matter. Use pandas for analysis workflows like filtering, aggregation, and CSV/TSV processing, then write results back to xlsx or csv.

Why do openpyxl formulas show no calculated values?

openpyxl writes formulas but never evaluates them, so cached values are missing until a spreadsheet application recalculates. Use LibreOffice headless conversion or another recalculation tool before delivery so cached values exist in the workbook.

How do I render an xlsx file to images for visual review?

Convert the workbook to PDF with soffice --headless --convert-to pdf, then run pdftoppm -png on the output to get per-page images. This requires LibreOffice and Poppler installed on the system.

Which Excel functions should I avoid in generated workbooks?

Avoid dynamic array functions like FILTER, XLOOKUP, SORT, and SEQUENCE, plus volatile functions like INDIRECT and OFFSET. Prefer simple formulas with helper cells and explicit cell references over hardcoded numbers.