xlsx

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

29|15|Updated Oct 17, 2025
One-click install
npx skills add https://github.com/NickCrew/claude-cortex --skill xlsx-nickcrew
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/NickCrew/claude-cortex/tree/main/skills/document-skills/xlsx
Command: npx skills add https://github.com/NickCrew/claude-cortex --skill xlsx-nickcrew

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill enables creating, editing, and analyzing spreadsheets with formulas, formatting, and data visualization while preserving template integrity.

Core Features & Use Cases

  • Formulas & Formatting: Produce zero-error, formula-safe spreadsheets.
  • Data Analysis: Use pandas for data analysis and recalc with LibreOffice.
  • Templates: Maintain existing templates when updating files.

Quick Start

Create a new workbook with a simple revenue table and apply a SUM formula.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create an Excel spreadsheet with formulas and formatting?

Use openpyxl to create new workbooks with formulas, cell formatting, and data. You can add SUM, reference, and calculation formulas while applying number formats and color coding to maintain template standards and ensure zero formula errors.

Can I edit existing Excel files while keeping formulas intact?

Yes, openpyxl preserves existing formulas and templates when you modify spreadsheets. You can update data and formatting without disrupting calculation logic or template structure.

How do I analyze data in Excel files using pandas?

Pandas reads Excel data into DataFrames for analysis, filtering, and aggregation. Combined with openpyxl, you can extract insights from spreadsheets and write results back with formulas recalculated.

What's the best way to recalculate Excel formulas after updates?

Use LibreOffice-based formula recalculation to validate and refresh all formulas after modifying spreadsheet data. This ensures formulas return current values and eliminates calculation errors across the workbook.

Do I need to use formulas instead of hardcoding values in spreadsheets?

Yes, this Skill enforces formula-based calculations to maintain data integrity and enable dynamic updates. Formulas ensure values recalculate automatically when inputs change, meeting template and compliance requirements.