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