xlsx

What This Skill Does

The xlsx skill provides a comprehensive toolkit for professional-grade spreadsheet manipulation. It enables OpenClaw to create, read, edit, and analyze various spreadsheet formats including .xlsx, .xlsm, .csv, and .tsv. This skill is engineered to support complex financial modeling, data visualization, and rigorous formula management. It enforces industry-standard formatting conventions, ensures zero-error formula outputs, and preserves the structural integrity of existing templates. By leveraging LibreOffice for recalculations, the skill ensures that all dynamic data remains accurate and reliable during operations.

Installation

You can install this skill by running the following command in your terminal or via the OpenClaw management console: clawhub install openclaw/skills/skills/seanphan/xlsx

Use Cases

• Financial Modeling: Building complex three-statement models, DCFs, and valuation scenarios using professional color-coding and standardized number formatting.
• Data Analysis & Visualization: Importing raw datasets to identify trends, create pivot tables, and generate charts directly within spreadsheets.
• Template Maintenance: Modifying existing corporate workbooks while strictly adhering to established formatting styles and preserving complex formula logic.
• Data Cleaning: Batch processing of CSV or TSV files to standardize inputs, perform lookups, and validate data integrity.
• Automation: Recalculating complex workbooks that require external engine support for formula execution.

Example Prompts

1. "Please update the financial model in 'FY2025_Projection.xlsx'. Add a new growth assumption for Q4, ensure all hardcoded inputs are colored blue, and verify that all formulas use cell references rather than hard values."
2. "Analyze the attached 'Sales_Report.csv'. Group the data by region and calculate the total revenue for each, then create a summary sheet with a bar chart visualizing this growth."
3. "Open 'Investment_Memo.xlsx' and fix any #REF! errors. Add a documentation comment to the revenue growth cell citing the Q2 2025 10-Q filing on page 12."

Tips & Limitations

• Formula Accuracy: Always allow the skill to run the recalc.py script if you have introduced new formulas to ensure all values are computed correctly before final output.
• Template Consistency: When editing existing files, explicit instructions to 'preserve formatting' will help the agent prioritize your existing visual layout over default styles.
• Large Files: For extremely large datasets (millions of rows), ensure you provide specific ranges for analysis to keep performance optimal.
• Documentation: Always provide source citations for hardcoded inputs to maintain auditability in your financial models.