Turn messy spreadsheets into clean, analyzable data
Handles the spreadsheets from hell — merged cells, multiple header rows, color-coded data, footnotes mixed with values, data starting at cell B7. Extracts clean tabular data from Excel files without forcing you to reverse-engineer the formatting first.
Create a skill called "Spreadsheet Rescue". When I give you an Excel file, don't just try to read it blindly. First, inspect every sheet: find the actual data region (it might not start at A1), detect merged cells, identify multi-row headers, and spot total/subtotal rows mixed with data. Then clean it: unmerge cells by propagating values where appropriate, flatten multi-row headers into single-row column names, remove summary rows, and if formatting is being used as data (for example, colored rows mean "overdue"), extract that meaning into an explicit column whenever possible. Output a clean CSV for each data region found, plus a data dictionary describing each column. If the file contains formulas, document the business logic they appear to encode.
Business users build spreadsheets for humans to read, not machines to parse.
You get merged cells everywhere, header rows spanning three lines, totals
mixed in with data rows, and color used as a signal instead of a column.
This skill detects the real data region, normalizes the sheet structure,
and gives you clean tabular output you can actually analyze.
Fix broken CSVs before they break your pipeline
Drop any CSV on your Claw and get a clean, validated file back. It detects encoding issues, mixed delimiters, malformed rows, broken quoting, BOM markers, and type mismatches — then fixes everything and tells you what it changed.
Tame every date format into one standard
Scan any dataset for date columns, detect the formats in use (even mixed formats within the same column), flag ambiguous dates like 03/04/2024, and standardize everything to ISO 8601 with consistent timezone handling.
Update pricing across all your Airbnb listings without clicking through each one
Automate bulk rate changes across multiple Airbnb listings using your Claw. Useful for seasonal pricing updates, last-minute discounts, or syncing rates after a change in your hosting strategy.
Email and calendar without leaving your terminal
Full Gmail control via the gog CLI. Read, send, search, organize emails. Create events, set reminders, RSVP to invitations. All from natural language or CLI commands.