xlsx

Create and edit XLSX, XLSM, CSV, and TSV spreadsheets with formulas and formatting.

45|50|Updated Jan 24, 2026
One-click install
npx skills add https://github.com/zocomputer/skills --skill xlsx-zocomputer
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/zocomputer/skills/tree/main/External/xlsx
Command: npx skills add https://github.com/zocomputer/skills --skill xlsx-zocomputer

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers users to create, edit, and analyze complex spreadsheet files (.xlsx, .xlsm, .csv, .tsv) without manual formula errors or formatting inconsistencies.

Core Features & Use Cases

  • Formula Creation & Management: Generate and maintain accurate Excel formulas, ensuring zero errors.
  • Data Analysis & Visualization: Analyze data using pandas and create visualizations within spreadsheets.
  • Formatting & Styling: Apply industry-standard formatting and preserve existing templates.
  • Use Case: Automatically generate a financial projection model with dynamic formulas, industry-standard color-coding, and precise number formatting based on user-provided assumptions.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add a formula in the 'Revenue' column to sum the values.

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 without manual errors?

To create a spreadsheet without manual formula errors, use an automated tool that generates accurate Excel formulas and applies industry-standard formatting directly to XLSX files, ensuring zero calculation errors and consistent styling.

What is the best way to analyze CSV and XLSX data using pandas?

Analyzing CSV and XLSX data using pandas involves loading the file formats into DataFrames, performing data operations, and generating visualizations within the spreadsheet to transform raw data into actionable insights.

Does LibreOffice work with openpyxl for Excel formula recalculation and error checking?

LibreOffice works with openpyxl by handling formula recalculation and error checking via a recalculation script, while openpyxl manages formula creation and formatting within the XLSX file structure.

Can I automatically generate a financial projection model in XLSX with dynamic formulas?

You can automatically generate a financial projection model in XLSX by providing assumptions to a spreadsheet generation tool, which outputs dynamic formulas, color-coding, and precise number formatting.

How to edit XLSM, CSV, and TSV files while preserving existing templates?

Editing XLSM, CSV, and TSV files while preserving templates requires a tool that supports multiple spreadsheet formats, maintains existing styling, and updates data without breaking the original layout.