xlsx

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

1|Updated Feb 3, 2026
One-click install
npx skills add https://github.com/run6270/skill --skill xlsx-run6270
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/run6270/skill/tree/main/document-skills/xlsx
Command: npx skills add https://github.com/run6270/skill --skill xlsx-run6270

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill empowers users to create, edit, analyze, and manage complex Excel spreadsheets, including formulas, formatting, and data visualization, directly through AI interaction.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new .xlsx files or modify existing ones, including adding data, formulas, and formatting.
  • Data Analysis & Visualization: Analyze data within spreadsheets using pandas and create visualizations.
  • Formula Management: Ensure formula accuracy, preserve existing formulas, and recalculate them using LibreOffice.
  • Use Case: Automatically generate a financial projection model in Excel, complete with industry-standard formatting, formulas, and assumptions, based on provided business metrics.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and populate it with the provided sales data.

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 using AI?

To create an Excel spreadsheet with formulas and formatting, you can use AI to generate new .xlsx files or modify existing ones, implementing formulas and applying advanced formatting directly through natural language interaction.

Can I analyze spreadsheet data with pandas and visualize the results?

Yes, you can analyze spreadsheet data with pandas and visualize the results by instructing the AI to process your .xlsx files, allowing for comprehensive data analysis and dynamic reporting without manual coding.

Does this approach support recalculating existing Excel formulas automatically?

Recalculating existing Excel formulas automatically is supported using LibreOffice, which ensures formula accuracy and preserves your existing formulas when you update or modify the spreadsheet data.

What is the best way to generate a financial modeling report in Excel from business metrics?

The best way to generate a financial modeling report in Excel is to provide your business metrics to the AI, which will automatically build a complete .xlsx file with industry-standard formatting, formulas, and assumptions.

Can I use this tool to edit .csv and .tsv files for data reporting?

Yes, you can use this tool to edit .csv and .tsv files for data reporting, as it facilitates comprehensive spreadsheet management across multiple file formats including .xlsx and .xlsm.

What are the limitations when preserving formulas during spreadsheet editing?

A key limitation when preserving formulas during spreadsheet editing is ensuring formula accuracy without breaking existing references, which is why LibreOffice is utilized to recalculate and validate formulas after updates.