Excel / XLSX
Create, edit, and manage professional Excel workbooks with full support for formulas, formatting, templates, and complex spreadsheet structures.
by
Iván
Excel / XLSX Overview
Excel / XLSX enables high-fidelity interaction with Excel workbooks, preserving formulas, formatting, merged cells, and workbook structure.
It is designed to prevent data corruption and formatting drift across .xlsx, .xlsm, .xls, .csv, and .tsv workflows.
How It Works
Load sheets, styles, named ranges, and hidden elements to keep structure stable.
Keep long identifiers and zip codes intact by enforcing explicit types.
Account for Excel's 1900/1904 date systems and serial date behavior.
Save with original styles, templates, and formulas preserved.
Key Features
Formula Support
Write live formulas instead of static values to keep workbooks interactive.
Template Preservation
Maintain existing styles, print settings, and workbook structures during edits.
Data Type Protection
Prevents Excel from mangling ZIP codes, phone numbers, or long IDs by enforcing correct data types.
Multi-Format Compatibility
Supports .xlsx, .xlsm, .xls, .csv, and .tsv files.
Large File Handling
Optimized for memory efficiency using streaming and chunked reads for massive datasets.
Requirements
- No VM required.
- Local processing only; no external API keys or cloud services required.
Use Cases
Financial Modeling
Generate complex workbooks with cross-sheet formulas and assumptions.
Report Automation
Update templates with new data while keeping branding and conditional formatting.
Data Migration
Convert CSV or TSV into structured Excel files with correct types and headers.
How to Install
npx clawhub@latest install excel-xlsxRun in your terminal, or click the Install button at the top of this page for one-click setup.
FAQ
Does this skill support Excel macros?
It supports .xlsm files for reading and writing; macro execution is handled by Excel itself.
How does it handle dates?
It handles Excel's 1900/1904 date systems, the 1900 leap-year quirk, and fractional times.
Can it handle files with hundreds of thousands of rows?
Yes. It uses streaming and chunked reads to manage large datasets.
Will it preserve named ranges and hidden sheets?
Yes. It keeps workbook structure including named ranges and hidden elements.
Does it prevent Excel from auto-formatting IDs?
Yes. It applies explicit formats for IDs, phone numbers, and large integers to avoid truncation.