excel

What This Skill Does

The Excel skill for OpenClaw is a powerful, comprehensive utility designed to streamline spreadsheet manipulation directly within your terminal or via agent automation. It supports the full lifecycle of Excel (.xlsx) file handling, allowing you to read data, create new workbooks, edit specific cells, apply complex formulas, and format content dynamically. Whether you are generating reports, parsing large datasets, or performing quick data cleanup, this skill abstracts the complexity of working with the OpenPyXL library into a clean, intuitive command-line interface. It is perfect for users who need to transform data into structured Excel formats or extract insights from existing spreadsheets without opening a GUI.

Installation

To begin, ensure you have Python installed on your system. You can install the dependency via pip:

pip install openpyxl

For best results with OpenClaw, use the provided installation command: clawhub install openclaw/skills/skills/dbhurley/excel

Use Cases

• Automated Reporting: Automatically convert daily JSON data exports into formatted Excel files with headers.
• Data Migration: Quickly convert massive CSV datasets into native .xlsx files, preserving layout preferences.
• Bulk Editing: Use scripts to perform find-and-replace operations across hundreds of cells in multiple workbooks simultaneously.
• Spreadsheet Auditing: Extract specific cell ranges or sheet metadata into machine-readable formats like JSON or Markdown for further analysis in downstream pipelines.

Example Prompts

1. "Open 'Q3_Sales.xlsx', read the 'Summary' sheet, and export the content as a markdown table for my report."
2. "Create a new workbook named 'Inventory.xlsx' with sheets for 'Hardware', 'Software', and 'Services', then populate 'Hardware' with this JSON data: {"headers": ["Item", "Count"], "rows": [["Laptop", 50], ["Mouse", 100]]}."
3. "In the 'Budget.xlsx' file, update cell C12 with the formula =SUM(C2:C10) and then convert the whole file to CSV format for the accounting team."

Tips & Limitations

• Efficiency: When working with massive files, utilize the --range parameter to read only the specific area of interest to save memory and processing time.
• Formula Handling: While the tool supports writing formulas, ensure that syntax matches Excel standards, as invalid formulas will appear as strings inside the cells.
• Data Structure: When writing data, ensure your input matches the structure expected by the CLI (2D arrays vs. key-value objects) to avoid layout errors.
• Safety: As this skill performs file writes, ensure you have backups of critical data before running bulk automated modifications.