- Home
- Skills
- Workflow Automation
- excli workbooks
Works with the AI Agents you already use
excli workbooks
Inspect, edit, and convert spreadsheets with excli, including package-preserving edits for supported XLSX/XLSM operations.
$8
excli workbooks
Example session with this skill installed
Use excli to list the sheets in 'quarterly_report.xlsx' and then rename the sheet 'Draft_v1' to 'Final_Q3'.
- Read your context and instructions
- Compiled the excli workbooks
I have inspected the workbook and performed the requested sheet renaming using the excli utility.
Workbook Modification Summary
| Operation | Target File | Details | Status |
|---|---|---|---|
| Inspect | quarterly_report.xlsx | Found sheets: Cover, Draft_v1, Data_Source | Success |
| Rename | quarterly_report.xlsx | Changed Draft_v1 (index 1) to Final_Q3 | Success |
| Verify | quarterly_report.xlsx | Confirmed new sheet list: Cover, Final_Q3, Data_Source | Success |
# Command used to rename the sheet
excli sheet rename --input quarterly_report.xlsx --index 1 --name "Final_Q3"
The package integrity was preserved during this operation. As this was a package-preserving edit, existing styles, metadata, and any embedded macros in other sheets remain untouched.
Next steps
- Run
excli info --input quarterly_report.xlsxto view updated workbook metadata. - Use
excli read --input quarterly_report.xlsx --sheet "Final_Q3"to verify cell contents. - If you need to lock this sheet, I can assist with the
hidecommand.
Connects securely to your tools. The creator never sees your data.
About this skill
Manipulating Excel files via CLI often results in corrupted packages or lost formatting. This skill provides a structured interface for excli, a Rust-based tool designed to handle workbook operations, sheet management, and data conversion while prioritizing package integrity for XLSX and XLSM files. It allows for precise edits without the overhead of heavy office suites or brittle Python libraries that often strip macros and metadata.
What it does
- Package preservation performs in-place edits on XLSX/XLSM files to maintain existing metadata, macros, and styles.
- Sheet management executes commands to add, rename, delete, move, or hide specific worksheets within a workbook.
- Data conversion exports specific sheets to CSV/TSV or extracts single worksheets into new XLSX files.
- Workbook inspection retrieves sheet lists, metadata, and cell values to verify structure before performing operations.
- Cell manipulation handles formula setting, data appending, and rich-text replacement within defined formatting runs.
How it works
- Discovery scans the environment for the
excliorexcli-cliexecutable and verifies available subcommands via--help. - Inspection uses
infoorsheet listto map the workbook structure and identify target indices. - Execution runs specific commands like
replace,write --append, orconvertbased on the requested fidelity level. - Verification validates the operation by reading the modified file to ensure the targeted cells or sheets reflect the changes.
Frameworks & tools
This skill requires the excli command-line tool, a Rust-based utility. It interacts with the local filesystem and shell, supporting .xlsx, .xlsm, .xlsb, .xls, and .ods formats.
Why this beats prompting it yourself
Generic agents often attempt to write custom Python scripts that destroy Excel metadata or fail on large binary formats. This skill uses a specialized CLI with built-in package-preserving logic, ensuring that macros and complex formatting remain intact during simple data edits.
Use cases
- Append logs to an existing production XLSM workbook without breaking embedded VBA macros.
- Extract specific sheets from legacy XLSB or ODS files into clean CSVs for data pipelines.
- Batch rename or reorder worksheets across multiple workbooks via shell automation.
- Update formulas in specific cells programmatically while maintaining the rest of the workbook structure.
Known limitations
Requires excli to be pre-installed or built from source. High-fidelity round trips for complex features like charts or external links are not guaranteed. Rich-text replacement is limited to single runs.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Workflow Automation.
Requires excli CLI installed or built via Cargo. Does not guarantee preservation of charts, external links, or complex formula behaviors. Rebuilding workbooks may result in fidelity loss.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 20 days ago
- Software
- excli CLITerminal access
Install excli (excli or excli-cli) separately.