xlsx

Create, edit, and analyze Excel spreadsheets with formulas and formatting.

5|Updated Nov 18, 2025
One-click install
npx skills add https://github.com/krishagel/geoffrey --skill xlsx-krishagel
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/krishagel/geoffrey/tree/main/skills/xlsx
Command: npx skills add https://github.com/krishagel/geoffrey --skill xlsx-krishagel

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

This Skill enables rapid spreadsheet creation, analysis, and formula-preserving edits, reducing manual workbook maintenance.

Core Features & Use Cases

  • Spreadsheet creation: generate new workbooks with formulas and formatting.
  • Data analysis: read, summarize, and visualize data.
  • Formula integrity: recalculate and validate formulas to avoid errors.
  • Template preservation: update templates while preserving existing styles.

Quick Start

Create a new budget workbook with a few formulas and formatted tables.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create spreadsheets with formulas using openpyxl?

Create spreadsheets with formulas by using openpyxl to build new .xlsx workbooks, define cell formulas using Excel syntax, and apply formatting. The Skill automates formula entry, ensuring zero errors and recalculation compatibility with standard workflows.

Can I read and analyze data from existing Excel and CSV files?

Yes. The Skill reads .xlsx, .xlsm, .csv, and .tsv files, extracts and summarizes data, and performs analysis while preserving existing formulas and formatting in templates, avoiding manual recalculation.

How do I edit existing spreadsheets without breaking formulas?

Modify existing spreadsheets while preserving all formulas and template structure. The Skill updates cells and formatting without altering formula logic, then recalculates formulas to validate accuracy and prevent errors.

What's the best way to automate spreadsheet formatting and data visualization?

Automate formatting with standard color and number styles, then generate data visualizations and summaries. The Skill enforces strict Excel formulas instead of hardcoded values, maintaining recalculation integrity and template consistency.

Does the Skill support recalculation of complex formulas across multiple sheets?

Yes. The Skill recalculates formulas using the LibreOffice-based recalc.py workflow, validating formula logic across sheets and ensuring zero errors while maintaining template and formula integrity.

Can I use this for batch operations on multiple .xlsx and .csv files?

The Skill automates spreadsheet creation, editing, and analysis across .xlsx, .xlsm, .csv, and .tsv workflows, enabling batch processing with consistent formula application, formatting, and recalculation across multiple files.