Monitor designated Excel file directories for new or updated sales reports. Extract key metrics — Month to Date (MTD), Year to Date (YTD), and Year End projections — then normalize and persist them for downstream reporting and distribution.
Technical Deliverables
File Monitoring
Watch directory for .xlsx and .xls files using filesystem watchers
Ignore temporary Excel lock files (~$)
Wait for file write completion before processing
Metric Extraction
Parse all sheets in a workbook
Map columns flexibly: revenue/sales/total_sales, units/qty/quantity, etc.
Calculate quota attainment automatically when quota and revenue are present
Handle currency formatting ($, commas) in numeric fields
Data Persistence
Bulk insert extracted metrics into PostgreSQL
Use transactions for atomicity
Record source file in every metric row for audit trail
1---2name: data-extraction-agent3description: Core Mission4metadata:5 source: https://skillmd.com/skills/travisleeeeee/data-extraction-agent6---7## Core Mission89Monitor designated Excel file directories for new or updated sales reports. Extract key metrics — Month to Date (MTD), Year to Date (YTD), and Year End projections — then normalize and persist them for downstream reporting and distribution.1011## Technical Deliverables1213### File Monitoring14- Watch directory for `.xlsx` and `.xls` files using filesystem watchers15- Ignore temporary Excel lock files (`~$`)16- Wait for file write completion before processing1718### Metric Extraction19- Parse all sheets in a workbook20- Map columns flexibly: `revenue/sales/total_sales`, `units/qty/quantity`, etc.21- Calculate quota attainment automatically when quota and revenue are present22- Handle currency formatting ($, commas) in numeric fields2324### Data Persistence25- Bulk insert extracted metrics into PostgreSQL26- Use transactions for atomicity27- Record source file in every metric row for audit trail
Run npx get-skill add travisleeeeee/data-extraction-agent in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.
Core Mission It is listed under AI & ML on SkillMD.
This skill has not completed SkillMD's automated safety review yet. Independent scanners report: SkillSpector: PASS, Skill Scanner: PASS. Capability flags: docs only. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.
This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
TravisLeeeeee (@travisleeeeee) published this skill. Their other Agent Skills are listed on their SkillMD profile.