Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+22 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.

    How to use

    Skills on Agensi run inside your AI agent. Copy the prompt, paste it into your agent, and it connects to Agensi and installs this skill for you. If a payment is needed, your agent shows it to you first.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill passes our trust checks below.

    Security scanned

    Passed 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 scanned

    Verified clean 9 days ago

    • Passed all security checks, Safe to install

    Requires

    GitHub
    Python

    Listed11 days ago
    Updated9 days ago

    What's inside

    Frequently Asked Questions