Can this skill handle complex Excel formulas?

Yes, it supports over 80 native Excel functions and can evaluate both standard formulas and array formulas, including cross-sheet references.

Does it support cell styling and formatting?

Absolutely. You can programmatically control background colors, font properties, borders, alignment, and number formats like currency, percentages, or custom Excel codes.

Is it possible to perform multiple updates at once?

Yes, the skill supports atomic batch operations. You can pass a JSON file containing multiple instructions (like put, style, and merge) to update a workbook in a single command.

What file formats can I export my spreadsheet data to?

XL CLI supports exporting to multiple formats including CSV, JSON, PNG, PDF, HTML, SVG, and Markdown tables.

Do I need Microsoft Excel installed to use this skill?

No, XL CLI operates directly on .xlsx files using its own high-performance library. It does not require Microsoft Excel or a JDK to be installed on your system.

XL CLI - Advanced Excel Operations

Name: XL CLI - Advanced Excel Operations
Author: TJC-LP

byTJC-LP

•

Productivity & Workflow

Perform high-performance Excel operations directly from the command line, including cell manipulation, formula evaluation, and multi-format data export.

XL CLI is a powerful extension for Claude Code that enables seamless interaction with Excel workbooks through a specialized command-line interface. It allows users to read, write, style, and evaluate complex formulas within .xlsx files without requiring the Java SDK or a GUI. Whether you need to extract data into structured formats like JSON/CSV, generate visual snapshots in PNG/PDF, or perform bulk updates using atomic JSON batches, this skill provides the speed and flexibility required for automated spreadsheet management and data analysis workflows.

Key Features

01Evaluate complex Excel formulas and array results directly from the CLI.

02Read and write cells, ranges, and named references with native high performance.

031 GitHub stars

04Apply advanced styling including borders, colors, merging, and column auto-fitting.

05Export spreadsheet data to CSV, JSON, PNG, PDF, HTML, and SVG formats.

06Execute atomic bulk operations using structured JSON batch processing.

Use Cases

01Automating data extraction from complex financial models for downstream analysis.

02Auditing large Excel workbooks by searching for patterns and evaluating cell dependencies.

03Programmatically generating, styling, and formatting business reports as .xlsx files.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add tjc-lp/xl xl-cli

For use in Claude.ai and ChatGPT