Auto Fill — Data skill for Claude Code

Intelligent Office Auto-Fill Skill

A Claude Code skill for filling Word and Excel forms from reusable, source-backed reference data.

The skill is designed for real-world forms with blank table cells, placeholders, checkboxes, merged cells, bilingual Chinese/English labels, repeatable tables, and legacy Office formats. It separates semantic planning from file editing: Claude creates a validated fill plan, and deterministic scripts apply that plan while preserving formatting.

What it does

• Fills .docx, .doc, .xlsx, .xlsm, and .xls forms.
• Uses reusable YAML, JSON, CSV, TXT, Markdown, Word, and Excel reference files.
• Bootstraps reusable reference profiles from previously filled forms.
• Generates an auditable fill_plan.json before editing any Office file.
• Preserves document and spreadsheet formatting as much as possible.
• Leaves missing, ambiguous, conflicting, or unsupported fields blank.
• Produces Markdown and JSON filling reports for manual review.

Safety rule

This skill never invents values.

A field is filled only when the value is explicitly present in the provided references or explicitly supplied by the user in the current task. Ambiguous or unsupported fields are skipped and reported.

Repository layout

.
├── SKILL.md                         # Claude Code skill instructions
├── scripts/                         # Extraction, matching, validation, and writing scripts
├── schemas/                         # JSON schemas for fields, facts, plans, and reports
├── assets/                          # Prompts, field hints, and report templates
├── docs/                            # Architecture and workflow notes
├── examples/                        # Sample plans and template sketches
├── tests/                           # Unit tests
├── requirements.txt
└── pyproject.toml

Requirements

• Python 3.10 or newer
• Claude Code
• Python packages in requirements.txt
• LibreOffice, optional but recommended for .doc and `.x