Excel and Spreadsheet Automator
SkillSkill
Complex formulas, VBA macros, and Apps Script — for Excel and Google Sheets.
About
Automates Excel and Google Sheets tasks — complex formulas, VBA macros, Apps Script functions, CSV processing pipelines, and interactive dashboard layouts.
Capabilities:
- Complex formula generation (XLOOKUP, INDEX-MATCH, array formulas, dynamic arrays)
- VBA macro creation for repetitive workflows
- Google Apps Script functions and triggers
- CSV/TSV processing pipelines with data transformation
- Conditional formatting rules and dynamic formatting
- Pivot table automation and custom calculated fields
- Interactive dashboard layouts with charts and slicers
- Cross-sheet and cross-workbook reference management
Need financial models specifically? Check out Financial Modeling ($9) — purpose-built for startup financial models with revenue projections, unit economics, and cap table management.
Need analytics dashboards? Data Dashboard Builder ($9) covers SQL-powered dashboards in Grafana and Metabase.
What you get:
One SKILL.md file. Add it to your Claude project at .claude/skills/ and reference it in CLAUDE.md. Works with Claude.ai Projects, Claude Code, and the Claude API.
Version: 1.1.0 | Type: Free Skill | Ecosystem: OpenClaw / ClawMart
Core Capabilities
- Advanced formula generation
- VBA macro creation
- Google Sheets Apps Script
- Data transformation pipelines
- Pivot table design
- CSV processing automation
- Data validation rules
- Conditional formatting
- Dashboard layout design
- Cross-sheet references
- Named range management
- Template generation
Customer ratings
0 reviews
No ratings yet
- 5 star0
- 4 star0
- 3 star0
- 2 star0
- 1 star0
No reviews yet. Be the first buyer to share feedback.
Version History
This skill is actively maintained.
March 1, 2026
One-time purchase
$5
By continuing, you agree to the Buyer Terms of Service.
Creator
iceboks
Creator
Software engineer building production AI tools. Skills and personas for engineering, DevOps, and executive leadership. Free skills that actually work. Paid personas with real decision frameworks and three-tier memory. Our agents include setup scripts and instructions on how to install. I'm always open to feed back for improvements or feature requests
View creator profile →Details
- Type
- Skill
- Category
- Productivity
- Price
- $5
- Version
- 1
- License
- One-time purchase
Works With
Works with OpenClaw, Claude Projects, Custom GPTs and other instruction-friendly AI tools.
Compatible With
Ledger - CFO and Head of Finance
Works great with
Personas that pair well with this skill.
INDIE Persona
Freelance Business Ops Partner
A complete AI business partner — personality, memory, workflows, and autonomous operations, pre-configured.
$79
Networking Emails Bundle
Persona
Professional networking emails collection
$9
Productivity Planner Bundle
Persona
Goal tracking and productivity system
$9