officecli-xlsx

Automate Excel workbook creation, editing, and validation via OfficeCLI.

Updated Apr 22, 2026
One-click install
npx skills add https://github.com/MicroTools-Hub/Excel-V2 --skill officecli-xlsx-microtools-hub
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: officecli-xlsx
Source: https://github.com/MicroTools-Hub/Excel-V2/tree/main/sources/OfficeCLI-main/OfficeCLI-main/skills/officecli-xlsx
Command: npx skills add https://github.com/MicroTools-Hub/Excel-V2 --skill officecli-xlsx-microtools-hub

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill enables automated end-to-end Excel workbook workflows, reducing manual boilerplate work across creation, editing, and maintenance of .xlsx files by translating natural-language requests into deterministic OfficeCLI actions.

Core Features & Use Cases

  • Read, create, modify, and validate workbooks including formulas, charts, pivot tables, and data formats across multiple sheets.
  • Support incremental, batched, or script-driven operations with built-in QA checks to catch issues early.
  • Use cases include building financial models, dashboards, trackers, and data migrations by describing the desired outcome and letting the tool apply changes.

Quick Start

Describe the target .xlsx file and the exact changes you want (for example, add a sheet named Revenue, set B2 to 1000, and apply a SUM formula in D2) and I will execute them incrementally using OfficeCLI.

Frequently Asked Questions about officecli-xlsx

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

FAQPage Schema
How do I automate Excel workbook workflows from natural language requests?

Automating Excel workbook workflows from natural language requests is achieved by interpreting your descriptions and applying changes via OfficeCLI. This skill translates text into deterministic, one-command-at-a-time operations to create, edit, and format .xlsx files.

Can I create pivot tables and charts in xlsx files programmatically?

Yes, you can create pivot tables and charts in xlsx files programmatically. This skill targets creating, reading, editing, and analyzing workbooks across multiple sheets, including formulas, charts, and pivot tables, by describing the desired outcome.

Does OfficeCLI support building financial models and dashboards in Excel?

OfficeCLI does support building financial models and dashboards in Excel. This skill automates end-to-end workbook workflows, allowing you to build models, dashboards, and trackers by describing the exact changes you want applied incrementally.

What's the best way to edit multiple sheets in an existing xlsx file?

The best way to edit multiple sheets in an existing xlsx file is using incremental, batched, or script-driven operations with built-in validation. This skill applies changes across multiple sheets with QA checks to catch issues early.

How do I validate data when migrating CSV files into Excel?

To validate data when migrating CSV files into Excel, this skill uses built-in QA checks during deterministic execution. It triggers when users mention spreadsheet, workbook, Excel, or .xlsx/.csv filenames, applying changes one command at a time to catch issues early.

Are there limitations to automating Excel workflows with natural language commands?

A limitation of automating Excel workflows with natural language commands is that execution is deterministic with one-command-at-a-time operations. You must describe the target .xlsx file and exact changes explicitly, as the tool applies changes incrementally rather than through open-ended interpretation.