npx skills add https://github.com/claude-office-skills/skills --skill 'PDF Form Filler'自动填写 PDF 表单并从已填写的表单中提取数据。
此技能可帮助您:
"使用以下数据填写此 PDF 表单:
- 姓名:John Smith
- 日期:2026-01-29
- 金额:$1,500"
"从此 PDF 中提取所有表单字段值"
"此表单中填写了什么数据?"
"使用电子表格中的数据填写此表单的 50 份副本"
"为此 CSV 中的每一行生成表单"
| 字段类型 | 描述 | 填写方法 |
|---|---|---|
| 文本字段 | 单行/多行文本 |
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
| 直接文本输入 |
| 复选框 | 是/否选择 | 勾选/取消勾选 |
| 单选按钮 | 多选一选项 | 选择选项 |
| 下拉列表 | 列表选择 | 选择值 |
| 日期字段 | 日期选择器 | 日期值 |
| 签名 | 数字签名 | 签名图像/证书 |
| 组合框 | 带文本输入的下拉列表 | 选择或输入 |
## 表单字段:[表单名称]
### 字段映射
| 字段名称 | 类型 | 必填 | 页码 | 备注 |
|------------|------|----------|------|-------|
| applicant_name | Text | Yes | 1 | 最多 50 个字符 |
| birth_date | Date | Yes | 1 | MM/DD/YYYY |
| gender | Radio | Yes | 1 | M/F/Other |
| employed | Checkbox | No | 1 | 如果是则勾选 |
| state | Dropdown | Yes | 2 | 美国各州 |
| signature | Signature | Yes | 3 | 数字签名 |
## 表单填写模板:[表单名称]
### 表单信息
- **文件**:application_form.pdf
- **总字段数**:25
- **必填字段**:15
### 字段映射
```yaml
# 个人信息
applicant_name: "${firstName} ${lastName}"
date_of_birth: "${birthDate}"
ssn_last_four: "${ssnLast4}"
phone: "${phone}"
email: "${email}"
# 地址
street_address: "${address.street}"
city: "${address.city}"
state: "${address.state}"
zip_code: "${address.zip}"
# 就业情况
currently_employed: ${isEmployed} # checkbox
employer_name: "${employer.name}"
job_title: "${employer.title}"
# 选择项
payment_method: "${paymentMethod}" # dropdown
agree_terms: true # checkbox
{
"firstName": "John",
"lastName": "Smith",
"birthDate": "1990-05-15",
"phone": "555-123-4567",
"email": "john.smith@email.com",
"address": {
"street": "123 Main St",
"city": "New York",
"state": "NY",
"zip": "10001"
},
"isEmployed": true,
"employer": {
"name": "Acme Corp",
"title": "Manager"
},
"paymentMethod": "Direct Deposit"
}
## 表单填写结果
### 摘要
| 状态 | 值 |
|--------|-------|
| **表单** | application_form.pdf |
| **已填字段** | 23/25 |
| **错误** | 2 |
| **输出** | filled_application.pdf |
### 已填字段
| 字段 | 值 | 状态 |
|-------|-------|--------|
| applicant_name | John Smith | ✅ |
| date_of_birth | 05/15/1990 | ✅ |
| phone | 555-123-4567 | ✅ |
| state | NY | ✅ |
| payment_method | Direct Deposit | ✅ |
### 错误/警告
| 字段 | 问题 | 建议 |
|-------|-------|------------|
| ssn | 未找到字段 | 检查字段名称 |
| signature | 需要证书 | 手动添加签名 |
### 验证
- ✅ 所有必填字段已填写
- ✅ 日期格式正确
- ⚠️ 签名字段需要手动完成
## 表单数据提取
### 来源:completed_form.pdf
### 提取的值
```json
{
"form_title": "Employment Application",
"submission_date": "2026-01-29",
"fields": {
"applicant_name": "Jane Doe",
"date_of_birth": "1985-03-20",
"email": "jane.doe@email.com",
"phone": "555-987-6543",
"address": "456 Oak Ave, Chicago, IL 60601",
"position_applied": "Senior Developer",
"salary_expectation": "$120,000",
"available_start": "2026-03-01",
"references_provided": true
}
}
| 指标 | 值 |
|---|---|
| 总字段数 | 30 |
| 已填字段数 | 28 |
| 空字段数 | 2 |
| 提取置信度 | 98% |
## 批量表单填写
### 配置
- **模板表单**:w9_form.pdf
- **数据源**:vendors.csv
- **记录数**:150
- **输出文件夹**:/filled_w9s/
### 数据预览
| 行 | 名称 | TIN | 地址 |
|-----|------|-----|---------|
| 1 | Acme Corp | XX-XXX1234 | 123 Main St |
| 2 | Beta LLC | XX-XXX5678 | 456 Oak Ave |
| ... | ... | ... | ... |
### 进度
| 状态 | 数量 | % |
|--------|-------|---|
| ✅ 已完成 | 145 | 97% |
| ⚠️ 警告 | 3 | 2% |
| ❌ 错误 | 2 | 1% |
### 错误
| 行 | 问题 |
|-----|-------|
| 47 | 无效的 TIN 格式 |
| 89 | 缺少必填项:地址 |
### 输出文件
- w9_acme_corp.pdf
- w9_beta_llc.pdf
- ...
## 表单验证规则
### 字段验证
| 字段 | 规则 | 错误信息 |
|-------|------|---------------|
| email | 有效的电子邮件格式 | "无效的电子邮件地址" |
| phone | 10 位数字 | "电话必须是 10 位数字" |
| ssn | XXX-XX-XXXX 格式 | "无效的 SSN 格式" |
| date | MM/DD/YYYY | "使用 MM/DD/YYYY 格式" |
| zip | 5 或 9 位数字 | "无效的邮政编码" |
| amount | 数字,> 0 | "输入正数" |
### 跨字段验证
| 规则 | 字段 | 条件 |
|------|--------|-----------|
| 条件性必填 | employer_name | 如果 employed = true 则为必填 |
| 日期范围 | end_date | 必须在 start_date 之后 |
| 总和检查 | item_totals | 必须等于 grand_total |
## 填写前验证
### 数据验证结果
| 字段 | 值 | 有效 | 问题 |
|-------|-------|-------|-------|
| email | john@email | ❌ | 缺少域名 |
| phone | 555-1234 | ❌ | 只有 7 位数字 |
| date | 2026-01-29 | ✅ | - |
| zip | 10001 | ✅ | - |
### 摘要
- ✅ 有效:18 个字段
- ❌ 无效:2 个字段
- ⚠️ 警告:3 个字段
### 建议
1. 修复电子邮件格式:添加域名(例如 @company.com)
2. 使用区号补全电话号码
| 表格 | 用途 | 关键字段 |
|---|---|---|
| W-9 | 税务识别 | TIN、姓名、地址 |
| I-9 | 就业资格 | 身份信息、公民身份 |
| W-4 | 预扣税 | 津贴、状态 |
| 1099 | 承包商收入 | 收入、付款人信息 |
| 表格 | 用途 | 关键字段 |
|---|---|---|
| 保密协议 | 保密性 | 各方、条款、日期 |
| 发票 | 账单 | 项目、金额、条款 |
| 采购订单 | 采购订单 | 项目、数量、供应商 |
| 申请表 | 各种用途 | 个人信息、历史记录 |
每周安装次数
0
仓库
GitHub 星标数
5
首次出现时间
1970年1月1日
安全审计
Fill out PDF forms automatically and extract data from completed forms.
This skill helps you:
"Fill this PDF form with the following data:
- Name: John Smith
- Date: 2026-01-29
- Amount: $1,500"
"Extract all form field values from this PDF"
"What data is filled in this form?"
"Fill 50 copies of this form using data from the spreadsheet"
"Generate forms for each row in this CSV"
| Field Type | Description | Fill Method |
|---|---|---|
| Text Field | Single/multi-line text | Direct text entry |
| Checkbox | Yes/No selection | Check/uncheck |
| Radio Button | One of many options | Select option |
| Dropdown | List selection | Choose value |
| Date Field | Date picker | Date value |
| Signature | Digital signature | Signature image/certificate |
| Combo Box | Dropdown with text entry | Select or type |
## Form Fields: [Form Name]
### Field Map
| Field Name | Type | Required | Page | Notes |
|------------|------|----------|------|-------|
| applicant_name | Text | Yes | 1 | Max 50 chars |
| birth_date | Date | Yes | 1 | MM/DD/YYYY |
| gender | Radio | Yes | 1 | M/F/Other |
| employed | Checkbox | No | 1 | Check if yes |
| state | Dropdown | Yes | 2 | US states |
| signature | Signature | Yes | 3 | Digital sig |
## Form Fill Template: [Form Name]
### Form Info
- **File**: application_form.pdf
- **Total Fields**: 25
- **Required Fields**: 15
### Field Mappings
```yaml
# Personal Information
applicant_name: "${firstName} ${lastName}"
date_of_birth: "${birthDate}"
ssn_last_four: "${ssnLast4}"
phone: "${phone}"
email: "${email}"
# Address
street_address: "${address.street}"
city: "${address.city}"
state: "${address.state}"
zip_code: "${address.zip}"
# Employment
currently_employed: ${isEmployed} # checkbox
employer_name: "${employer.name}"
job_title: "${employer.title}"
# Selections
payment_method: "${paymentMethod}" # dropdown
agree_terms: true # checkbox
{
"firstName": "John",
"lastName": "Smith",
"birthDate": "1990-05-15",
"phone": "555-123-4567",
"email": "john.smith@email.com",
"address": {
"street": "123 Main St",
"city": "New York",
"state": "NY",
"zip": "10001"
},
"isEmployed": true,
"employer": {
"name": "Acme Corp",
"title": "Manager"
},
"paymentMethod": "Direct Deposit"
}
## Output Formats
### Fill Result Report
```markdown
## Form Fill Result
### Summary
| Status | Value |
|--------|-------|
| **Form** | application_form.pdf |
| **Fields Filled** | 23/25 |
| **Errors** | 2 |
| **Output** | filled_application.pdf |
### Filled Fields
| Field | Value | Status |
|-------|-------|--------|
| applicant_name | John Smith | ✅ |
| date_of_birth | 05/15/1990 | ✅ |
| phone | 555-123-4567 | ✅ |
| state | NY | ✅ |
| payment_method | Direct Deposit | ✅ |
### Errors/Warnings
| Field | Issue | Suggestion |
|-------|-------|------------|
| ssn | Field not found | Check field name |
| signature | Requires certificate | Add signature manually |
### Validation
- ✅ All required fields filled
- ✅ Date formats correct
- ⚠️ Signature field needs manual completion
## Form Data Extraction
### Source: completed_form.pdf
### Extracted Values
```json
{
"form_title": "Employment Application",
"submission_date": "2026-01-29",
"fields": {
"applicant_name": "Jane Doe",
"date_of_birth": "1985-03-20",
"email": "jane.doe@email.com",
"phone": "555-987-6543",
"address": "456 Oak Ave, Chicago, IL 60601",
"position_applied": "Senior Developer",
"salary_expectation": "$120,000",
"available_start": "2026-03-01",
"references_provided": true
}
}
| Metric | Value |
|---|---|
| Total fields | 30 |
| Filled fields | 28 |
| Empty fields | 2 |
| Extraction confidence | 98% |
## Batch Processing
### Batch Fill Job
```markdown
## Batch Form Fill
### Configuration
- **Template Form**: w9_form.pdf
- **Data Source**: vendors.csv
- **Records**: 150
- **Output Folder**: /filled_w9s/
### Data Preview
| Row | Name | TIN | Address |
|-----|------|-----|---------|
| 1 | Acme Corp | XX-XXX1234 | 123 Main St |
| 2 | Beta LLC | XX-XXX5678 | 456 Oak Ave |
| ... | ... | ... | ... |
### Progress
| Status | Count | % |
|--------|-------|---|
| ✅ Completed | 145 | 97% |
| ⚠️ Warnings | 3 | 2% |
| ❌ Errors | 2 | 1% |
### Errors
| Row | Issue |
|-----|-------|
| 47 | Invalid TIN format |
| 89 | Missing required: Address |
### Output Files
- w9_acme_corp.pdf
- w9_beta_llc.pdf
- ...
## Form Validation Rules
### Field Validations
| Field | Rule | Error Message |
|-------|------|---------------|
| email | Valid email format | "Invalid email address" |
| phone | 10 digits | "Phone must be 10 digits" |
| ssn | XXX-XX-XXXX format | "Invalid SSN format" |
| date | MM/DD/YYYY | "Use MM/DD/YYYY format" |
| zip | 5 or 9 digits | "Invalid ZIP code" |
| amount | Numeric, > 0 | "Enter positive number" |
### Cross-Field Validations
| Rule | Fields | Condition |
|------|--------|-----------|
| Conditional required | employer_name | Required if employed = true |
| Date range | end_date | Must be after start_date |
| Sum check | item_totals | Must equal grand_total |
## Pre-Fill Validation
### Data Validation Results
| Field | Value | Valid | Issue |
|-------|-------|-------|-------|
| email | john@email | ❌ | Missing domain |
| phone | 555-1234 | ❌ | Only 7 digits |
| date | 2026-01-29 | ✅ | - |
| zip | 10001 | ✅ | - |
### Summary
- ✅ Valid: 18 fields
- ❌ Invalid: 2 fields
- ⚠️ Warnings: 3 fields
### Recommendations
1. Fix email format: add domain (e.g., @company.com)
2. Complete phone number with area code
| Form | Purpose | Key Fields |
|---|---|---|
| W-9 | Tax identification | TIN, name, address |
| I-9 | Employment eligibility | ID info, citizenship |
| W-4 | Withholding | Allowances, status |
| 1099 | Contractor income | Income, payer info |
| Form | Purpose | Key Fields |
|---|---|---|
| NDA | Confidentiality | Parties, terms, dates |
| Invoice | Billing | Items, amounts, terms |
| PO | Purchase order | Items, quantities, vendor |
| Application | Various | Personal info, history |
Weekly Installs
0
Repository
GitHub Stars
5
First Seen
Jan 1, 1970
Security Audits
头脑风暴技能:AI协作设计流程,将创意转化为完整规范与实施计划
77,000 周安装
OpenAPI 转 TypeScript 工具 - 自动生成 API 接口与类型守卫
563 周安装
数据库模式设计器 - 内置最佳实践,自动生成生产级SQL/NoSQL数据库架构
564 周安装
Rust Unsafe代码检查器 - 安全使用Unsafe Rust的完整指南与最佳实践
564 周安装
.NET并发编程模式指南:async/await、Channels、Akka.NET选择决策树
565 周安装
韩语语法检查器 - 基于国立国语院标准的拼写、空格、语法、标点错误检测与纠正
565 周安装
技能安全扫描器 - 检测Claude技能安全漏洞,防范提示注入与恶意代码
565 周安装