xlsx

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

14|4|Updated Nov 22, 2025
One-click install
npx skills add https://github.com/pacphi/sindri --skill xlsx-pacphi
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/pacphi/sindri/tree/main/docker/lib/extensions/vf-xlsx/resources
Command: npx skills add https://github.com/pacphi/sindri --skill xlsx-pacphi

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas.

What problem does it solve?

This Skill eliminates the tedious, manual, and error-prone tasks associated with creating, editing, and analyzing spreadsheets. It ensures dynamic, formula-driven outputs and provides robust data analysis capabilities, saving significant time and reducing complexity in financial modeling and data reporting.

Core Features & Use Cases

  • Comprehensive Spreadsheet Management: Create and modify .xlsx files with full support for formulas, advanced formatting, and data validation.
  • Dynamic Formula Recalculation: Automatically recalculate all formulas in a spreadsheet and verify for errors, ensuring accuracy and data integrity.
  • Powerful Data Analysis: Leverage pandas for in-depth data manipulation, analysis, and visualization within spreadsheet contexts.
  • Use Case: Automate the monthly update of a financial model, ensuring all formulas are correctly recalculated, existing formatting is preserved, and any errors (like #REF!) are identified and reported for immediate correction.

Quick Start

Create a new Excel file named 'quarterly_sales.xlsx' with columns for 'Product', 'Q1 Sales', 'Q2 Sales', and a 'Total Sales' column that sums Q1 and Q2. Populate with sample data for three products.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate creating Excel spreadsheets with formulas and formatting?

Automate spreadsheet creation using openpyxl to build .xlsx files with formulas, number formatting, and data validation in a single operation. Define columns, populate data, embed formulas like SUM(), and apply industry-standard formatting to eliminate manual work and ensure consistency across workbooks.

Can I modify existing Excel files while keeping formulas intact?

Yes. Edit existing .xlsx, .xlsm, .csv, and .tsv files while preserving all formulas and template conventions. The Skill loads workbooks, updates data or structure, and saves changes without altering formula logic, ensuring downstream calculations remain accurate.

How do I catch formula errors like #REF! in spreadsheets?

Automatically recalculate all formulas in a spreadsheet and scan for errors including #REF!, #VALUE!, and #DIV/0!. The Skill integrates LibreOffice recalculation to verify formula integrity and reports any issues for immediate correction before distributing the file.

What's the best way to analyze and visualize data within Excel files?

Leverage pandas within the Skill to perform data manipulation, analysis, and visualization on spreadsheet data. Extract ranges, compute statistics, and generate insights without leaving the Excel workflow, then export results back to formatted cells.

Does this work with CSV and TSV files, or only .xlsx?

The Skill handles .xlsx, .xlsm, .csv, and .tsv formats interchangeably. Automate analysis and transformation across all these formats, apply formulas to structured data, and convert between formats while maintaining data integrity and formatting rules.

Do I need to know Python formulas to use this for financial modeling?

No. Use native Excel formulas instead of Python calculations for all financial logic. The Skill embeds formulas directly into cells, ensuring models remain auditable, portable, and aligned with industry standards for financial reporting and compliance.