- Home
- Skills
- Workflow Automation
- Excel & CSV Automation Kit
Works with the AI Agents you already use
Excel & CSV Automation Kit
17 standalone Python tools for Excel and CSV: merge, dedupe, filter, split, VLOOKUP, aggregate, validate, plus CSV to Excel conversion.
$24
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
| Step | Output |
|---|---|
csv_to_excel.py | Converted 3 rows -> a.xlsx (sheet: a) |
aggregate_excel.py | Aggregation complete, 2 rows -> out.xlsx |
| Region | Sales |
|---|---|
| EU | 15 |
| US | 7 |
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
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.mdthat 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.
.xlsis read-only (viaxlrd). - 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
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 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
Permissions
Allowed Hosts