XLSX Toolkit: Read, Create, and Transform Excel Spreadsheets

    2

    Complete skill for spreadsheet automation without needing Excel

    Free

    16 usesSecurity scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    XLSX Toolkit: Read, Create, and Transform Excel Spreadsheets

    Example session with this skill installed

    Create a 3-year revenue projection in a new Excel file. Use 2024 as the base year with $5M revenue and a 10% growth rate assumption. Use standard financial modeling colors.

    • Read your context and instructions
    • Compiled the xlsx toolkit

    I have created 'projection.xlsx'. Cell B2 contains the $5,000,000 input (blue text), and C2 contains the formula '=B2*(1+$B$5)' (black text) for 2025. All formulas were verified with zero errors (#REF!, #DIV/0!) using the recalculation script.

    I have created 'projection.xlsx

    Connects securely to your tools. The creator never sees your data.

    About this skill

    The problem

    LLMs often struggle with structured spreadsheet tasks, frequently hardcoding values instead of formulas or producing broken cell references. Manual data cleaning and financial modeling in Excel are time-consuming and prone to human calculation errors.

    What it does

    • Generates dynamic .xlsx and .csv files using Python libraries like pandas and openpyxl.
    • Implements industry-standard financial modeling practices including specific color-coding for inputs and formulas.
    • Constructs live Excel formulas (SUM, AVERAGE, growth rates) rather than static values to ensure files remain updateable.
    • Validates spreadsheet integrity by scanning for #REF!, #DIV/0!, and #VALUE! errors using a dedicated recalculation engine.
    • Cleans messy tabular data, fixes malformed rows, and converts between spreadsheet formats.

    Frameworks & tools

    Python, pandas, openpyxl, and LibreOffice for formula recalculation.

    Why this beats prompting it yourself

    Standard prompts often yield static data snapshots that break when edited. This skill enforces strict formula-based construction and uses a verification loop to catch broken references before delivery, ensuring professional-grade financial models every time.

    Use cases

    • Build dynamic three-statement financial models with standardized color-coding and assumptions.
    • Clean and restructure malformed CSV exports into formatted Excel reports.
    • Automate repetitive spreadsheet updates while preserving existing stylistic templates.
    • Perform bulk data analysis and visualization across multi-sheet workbooks.

    Known limitations

    Requires a local environment with LibreOffice installed to execute the mandatory formula recalculation script. Not intended for Google Sheets API integrations or generating Word/HTML reports.

    Based on the open-source skill from Anthropic's anthropics/skills repository (Apache-2.0). See NOTICE.md.

    For merging several documents into one, see Multi-Source Document Merger by Shogun Labs.

    Requires a local environment with LibreOffice installed to execute the mandatory formula recalculation script. Not intended for Google Sheets API integrations.

    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

    16 uses

    Times used to date

    Free forever

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 6 days ago

    • Free with an Agensi account

    Requires

    Python

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Environment Variables
    Listed4 months ago
    Updated1 day ago

    What's inside

    Frequently Asked Questions

    This toolkit uses Python-based verification to ensure all cell references are valid and formulas (like SUM or growth rates) are functional, preventing the static, broken data issues common with standard LLM outputs.

    Yes, a local installation of LibreOffice is required because the skill uses its engine to perform mandatory formula recalculation and integrity checks before finalizing any file.

    The skill includes a standardized system for dynamic financial modeling, encompassing input/formula color-coding, multi-sheet workbook construction, and support for three-statement models.

    The XLSX Toolkit is designed for seamless integration with any AI agent or framework capable of executing Python scripts and managing file system operations.

    This skill is purpose-built for local .xlsx and .csv file manipulation; it does not currently support cloud-based platforms like Google Sheets or file formats like .docx or .pdf.

    Upon purchase, you receive the full skill logic, integration documentation, and the verification engine scripts required to automate spreadsheet creation and data cleaning.

    New in Data & Databases