Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Excel & CSV Automation Kit

    1

    17 standalone Python tools for Excel and CSV: merge, dedupe, filter, split, VLOOKUP, aggregate, validate, plus CSV to Excel conversion.

    $24

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Excel & CSV Automation Kit

    Excel & CSV Automation Kit

    Example session with this skill installed

    Use the excel-csv-automation-kit skill. Convert a.csv to Excel, then total Sales by Region.

    • Read your context and instructions
    • Compiled the excel & csv
    • Generated the data export

    Summary

    Two tools from the kit were run on a synthetic 3-row file. The CSV was converted to a workbook, then aggregated by region.

    python skills/automate-excel/scripts/csv_to_excel.py --input a.csv --output a.xlsx
    python skills/automate-excel/scripts/aggregate_excel.py --input a.xlsx --group-by Region --agg "Sales:sum" --output out.xlsx
    
    StepOutput
    csv_to_excel.pyConverted 3 rows -> a.xlsx (sheet: a)
    aggregate_excel.pyAggregation complete, 2 rows -> out.xlsx
    RegionSales
    EU15
    US7

    This is the real output of the shipped scripts on synthetic input, not a customer project.

    Next steps

    Run validate_excel.py --require-cols Region,Sales on the result before sharing it.

    a.xlsx

    CSV · data export

    Generated

    Example file from a real run - the skill writes it into your workspace.

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

    About this skill

    Command-line Excel and CSV tools your coding agent can run

    Two Agent Skills and 18 standalone Python scripts for the spreadsheet jobs that eat an afternoon: combining monthly files, removing duplicates, joining a lookup table, summarising by group, and checking a file before you send it on.

    Who this is for: analysts and operators who already use a local coding agent (Claude Code, Codex, Cursor, OpenCode) and want repeatable spreadsheet steps instead of hand-editing.

    What you get

    • automate-excel: merge sheets, deduplicate by key, filter rows, split by row count or column value, VLOOKUP and multi-table lookup, group and aggregate, validate required columns and duplicate keys, transpose, rename sheets, fill a template, conditional formatting, set columns as text, Excel to CSV.
    • csv-to-excel: formatted Excel output with encoding detection and several CSVs into one workbook.
    • A command reference, worked examples, and a root SKILL.md that points your agent to the right skill.

    Read before you buy

    • Needs Python 3 and pip install -r skills/automate-excel/scripts/requirements.txt (openpyxl, pandas, xlrd).
    • Local files only. .xls is read-only (via xlrd).
    • Work on a copy of your data first.
    • Verified on macOS arm64 with synthetic data. A six-step chain (merge, dedupe, VLOOKUP, aggregate, format, validate) was run end to end; no real customer data was used.

    Works on local files only. Legacy .xls is read-only. Requires Python 3 with openpyxl, pandas and xlrd. Verified on macOS arm64 with synthetic data; large-file performance is not claimed.

    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 1 month ago

    Requires

    GitHub
    Python

    Permissions

    Terminal / Shell

    Allowed Hosts

    github.com
    Listed1 month ago
    Updated1 month ago

    What's inside

    Frequently Asked Questions

    Two Agent Skills (automate-excel and csv-to-excel), 18 standalone Python scripts, a command reference with worked examples, a root SKILL.md, a pinned requirements.txt, and INSTALL.md.

    It is built for coding agents that run local shell commands and read SKILL.md, such as Claude Code, Codex, Cursor and OpenCode. Skill discovery in each host is not independently verified, and the scripts also run directly from a terminal without any agent.

    The scripts are fixed, so the same command gives the same result each run. A six-step chain (merge, dedupe, VLOOKUP, aggregate, format, validate) was run end to end on synthetic data. Edge cases and very large files are not claimed to be covered; test on a copy of your data first.

    Legacy .xls files can be read (via xlrd, read-only). Output is written as .xlsx or .csv. Check the reference.md for which scripts accept .xls input before relying on it.

    Python 3 and the pinned packages in skills/automate-excel/scripts/requirements.txt (openpyxl, pandas, xlrd). Install with pip install -r skills/automate-excel/scripts/requirements.txt.

    The scripts read and write local files and do not call any service. The bundled scripts make no network calls; your agent host, however, may send file content to its own model provider depending on how you use it.

    New in Workflow Automation