xlsx

Create, edit, and analyze spreadsheet files with formulas and formatting.

Updated Jan 21, 2026
One-click install
npx skills add https://github.com/HsnSaboor/open-engineer --skill xlsx-hsnsaboor
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/HsnSaboor/open-engineer/tree/main/src/skills/bundled/anthropics-xlsx
Command: npx skills add https://github.com/HsnSaboor/open-engineer --skill xlsx-hsnsaboor

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet files, ensuring professional formatting, accurate formulas, and efficient data handling.

Core Features & Use Cases

  • Automated Spreadsheet Creation & Editing: Generate new Excel files or modify existing ones with data, formulas, and formatting.
  • Formula Recalculation & Error Checking: Ensures all formulas are correctly calculated and free of errors using LibreOffice.
  • Data Analysis: Leverage pandas for powerful data manipulation and insights from spreadsheet data.
  • Use Case: Automatically generate a monthly sales report in XLSX format from raw data, including complex financial calculations and industry-standard formatting.

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 data.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation and formatting?

You can automate spreadsheet creation by using this Skill to generate new .xlsx files or modify existing ones, ensuring professional fonts, accurate formulas, and zero formula errors. It populates data and applies industry-standard formatting automatically.

Can I recalculate formulas in an existing xlsx file?

Yes, you can recalculate formulas in an xlsx file using the integrated LibreOffice recalculation script. This mechanism ensures all formulas are correctly calculated and free of errors while preserving your existing templates.

Does this tool support data analysis with pandas for CSV files?

Yes, this tool supports data analysis with pandas for CSV files, allowing powerful data manipulation and insights. It handles .csv, .tsv, .xlsm, and .xlsx formats, enabling you to clean messy data and convert between tabular file formats.

What is the best way to generate a monthly sales report in Excel?

The best way to generate a monthly sales report in Excel is using this Skill to automatically create an .xlsx file from raw data, including complex financial calculations, computed formulas, and professional charting.

How do I clean messy data and convert between spreadsheet formats?

You can clean messy data and convert between tabular file formats like .csv, .tsv, and .xlsx using this Skill. It leverages pandas for data manipulation to ensure your spreadsheet data is structured and ready for analysis.