Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    excli workbooks

    1

    Inspect, edit, and convert spreadsheets with excli, including package-preserving edits for supported XLSX/XLSM operations.

    $8

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    excli workbooks

    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

    OperationTarget FileDetailsStatus
    Inspectquarterly_report.xlsxFound sheets: Cover, Draft_v1, Data_SourceSuccess
    Renamequarterly_report.xlsxChanged Draft_v1 (index 1) to Final_Q3Success
    Verifyquarterly_report.xlsxConfirmed new sheet list: Cover, Final_Q3, Data_SourceSuccess
    
    # 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.xlsx to 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 hide command.

    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

    1. Discovery scans the environment for the excli or excli-cli executable and verifies available subcommands via --help.
    2. Inspection uses info or sheet list to map the workbook structure and identify target indices.
    3. Execution runs specific commands like replace, write --append, or convert based on the requested fidelity level.
    4. 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.

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

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    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

    Requires

    excli CLI
    Terminal access

    Permissions

    Read Files
    Write Files
    Terminal / Shell
    Listed20 days ago

    What's inside

    Frequently Asked Questions

    Unlike standard Python libraries that often strip macros, this skill uses a Rust-based CLI designed to perform in-place edits that preserve VBA projects, metadata, and complex formatting in XLSM and XLSX files.

    This skill acts as a bridge to the `excli` tool; you must have the `excli` or `excli-cli` executable installed on your system and available in your environment's PATH for the agent to function.

    Yes, the skill supports a wide range of formats including modern XLSX/XLSM, binary XLSB, legacy XLS, and OpenDocument ODS files for both inspection and conversion tasks.

    The skill includes the logic for workbook discovery, sheet management (add/rename/delete), data conversion to CSV/TSV, and precise cell manipulation including formula updates.

    This skill is designed to work with any AI agent framework capable of executing shell commands and managing local file systems, such as AutoGPT, Open Interpreter, or custom LangChain agents.

    New in Workflow Automation