data-tidy
Data Tidy
Turn messy data — in whatever shape it arrives — into a clean, validated structured table
(.xlsx) plus an audit/change report. The design is intent-first (ask the purpose
and the wanted output before guessing) and human-in-the-loop (propose → confirm →
apply → report). Transforms are deterministic and logged; nothing is changed silently.
Self-sufficient & local engine. Runs on its own — no other toolkit needed. All processing (including OCR) happens on your machine: no cloud OCR, no external APIs, no third-party uploads. Note the AI agent driving the skill does send whatever it reads into its context to your AI provider — "never leaves the machine" is not claimed. See
../../PRINCIPLES.md#data-handling--pii-policy.
Workflow
0 — Intent (ask up front — this is what makes it economical)
Before profiling anything, ask (a short AskUserQuestion):
- What's this data for? (the purpose / where it's going)
- What output do you want? — the target columns / shape, e.g.
Investor | Commitment (£) | Close date (DD MMM YYYY). A one-line sketch is enough. - Any rules? — a master list to validate against, required fields, format preferences.