xlsx

Manipulate Excel (.xlsx) files from the command line without Python or Node dependencies.

40|12|Updated Oct 17, 2011
One-click install
npx skills add https://github.com/lanej/dotfiles --skill xlsx-lanej
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/lanej/dotfiles/tree/main/claude/skills/xlsx
Command: npx skills add https://github.com/lanej/dotfiles --skill xlsx-lanej

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires xlsx-cli.

What problem does it solve?

This Skill eliminates the manual drudgery of interacting with Excel files for data extraction, filtering, or basic editing. It provides a powerful command-line interface to automate these tasks, saving you time and reducing the risk of human error.

Core Features & Use Cases

  • Data Viewing & Exploration: Quickly list sheets, view headers, and inspect sheet contents, even for large files, without opening Excel.
  • SQL-like Filtering: Extract specific data by applying complex WHERE clauses, similar to SQL queries, to filter rows based on conditions.
  • Editing & Transformation: Set cell values, insert or delete rows/columns, and convert Excel files to/from CSV format for further processing.
  • Use Case: Extract all "Active" customer records from a large sales.xlsx file, select only their names and emails, and export the filtered data to a active_customers.csv file, all with a single command.

Quick Start

From the 'sales.xlsx' file, filter for rows where 'Status' is 'Active', select the 'Name', 'Email', and 'Department' columns, and output the result as a CSV file named 'active_users.csv'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I filter and extract specific rows from an Excel file using command-line queries?

You can apply SQL-like WHERE clauses to filter rows in Excel files from the command line. This Skill lets you extract data matching specific conditions—such as all 'Active' customers—and output results to CSV or view them directly, without opening Excel manually.

Can I automate Excel file operations without Python or Node dependencies?

Yes. This Skill manipulates .xlsx files as a self-contained CLI tool with no Python or Node runtime required. You can view, filter, edit, convert, and analyze workbooks in batch or interactive sessions directly from the terminal.

How do I convert Excel files to CSV or edit cell values from the command line?

You can set cell values, insert or delete rows and columns, and convert .xlsx files to or from CSV format using single command-line operations. This enables automated data transformation pipelines without manual Excel interaction.

What's the best way to explore large Excel workbooks without opening them in Excel?

List sheets, view headers, and inspect sheet contents quickly from the command line. This Skill lets you explore large files efficiently to understand structure and identify the data you need before extraction or filtering.

Does this tool support advanced Excel features like formulas, pivot tables, and named ranges?

Yes. Beyond basic viewing and filtering, this Skill supports advanced operations including formulas, pivot tables, charts, and named ranges, plus date format handling and backup protection for safe file manipulation.

Can I batch process multiple Excel files and export filtered results as CSV?

Yes. You can filter data from .xlsx workbooks, select specific columns, and export results to CSV in a single command. This is ideal for batch workflows that extract and transform data across multiple sheets or files.