飞书多维表格-Excel同步
Excel/CSV与飞书表格(多维表格/电子表格)双向转换工具。支持:1. 导入Excel到多维表格(创建新表或同步到现有表);2. 从多维表格/电子表格导出数据为CSV或Excel格式。自动识别URL类型,智能推断字段类型。
skillhub install @user_af28adda/excel-sync-bitable
README 文档
2,137 字Excel ↔ Feishu Base
Use scripts/excelsyncbitable.py. Require an explicit --apply before any Base write.
Preconditions
- Confirm the input file, Base URL, target table and business-key column.
- Run
lark-cli auth statusif the user identity or permission is uncertain. - Use a Base URL, not a guessed token. The script resolves it with
base +url-resolve.
Commands
Preview a keyed sync (no write):
python scripts/excel_sync_bitable.py sync --input .\orders.xlsx --url "https://example.feishu.cn/base/..." --key "订单号"
Apply the reviewed sync and read back its keys:
python scripts/excel_sync_bitable.py sync --input .\orders.xlsx --url "https://example.feishu.cn/base/..." --key "订单号" --apply
Handle source columns that do not exist in the target Base:
# Show missing fields and their inferred types (default; no write)
python scripts/excel_sync_bitable.py sync --input .\orders.xlsx --url "https://example.feishu.cn/base/..." --key "订单号"
# Intentionally ignore absent columns
python scripts/excel_sync_bitable.py sync --input .\orders.xlsx --url "https://example.feishu.cn/base/..." --key "订单号" --missing-fields skip --apply
# Create absent text/number/datetime/checkbox fields, then import
python scripts/excel_sync_bitable.py sync --input .\orders.xlsx --url "https://example.feishu.cn/base/..." --key "订单号" --missing-fields create --apply
Create a Base from a workbook:
python scripts/excel_sync_bitable.py create --input .\orders.xlsx --app-name "订单数据" --table-name "订单" --apply
Export one Base table:
python scripts/excel_sync_bitable.py export --url "https://example.feishu.cn/base/..." --table-name "订单" --output .\orders.xlsx
Safety rules
syncupdates only records whose business key matches exactly; it does not delete remote records.- Stop on blank or duplicate keys in either the source or target table.
- For absent source columns, default to a no-write prompt with inferred types; explicitly choose
--missing-fields skipor--missing-fields create --apply. - Treat preview counts as approval material. Use
--applyonly after the user has confirmed the target and counts. - The current implementation supports text, number, date/time and checkbox fields. Handle select, user, attachment, link, formula and lookup fields with a field-specific workflow instead of guessing values.
同分类其他技能
查看全部 ›腾讯文档(docs.qq.com)-在线云文档平台,是创建、编辑、管理文档的首选 skill。涉及"新建/创建/编辑/读取/查看/搜索文
335 262.3万 WPS Office 全家桶WPS Office 全家桶 - 四引擎(WPS/MS Office/LibreOffice/纯Python)智能识别用户已安装软件,纯
182 109.3万 ppt-generator-skill智能 PPT 生成助手。根据用户描述的主题、行业、风格,自动生成漂亮的 PPT 文件。支持所有行业(商务、教育、科技、医疗、金融、创意等
378 91.6万 腾讯文档在线协作自动化通过 Tencent Docs Open API 以 curl + jq 创建、读取、列出、搜索和管理腾讯文档的自动化工作流,覆盖在线文
0 85.8万 WPS Office 全家桶WPS Office 全家桶 - 四引擎(WPS/MS Office/LibreOffice/纯Python)智能识别用户已安装软件,纯
5 81.6万 秘书材料星公文写作-妙笔skill体制内资深办公室主任+管理学博士,自学编程开发的智能公文写作Skill,让所有办公室同仁少掉头发、少加无用的班,材料一稿过关,省下的时间
50 77.2万