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